Oracle 1Z0-071 Quiz 6 Topic 10 Questions 26-30

Question: 1

You execute these commands:

CREATE TABLE customers (customer_id INTEGER, customer_name VARCHAR2 (20) )

TNSERT INTO customers VALUES (1, 'Customer 1 ' ) ;

SAVEPOTNT post_insert;

INSERT INTO customers VALUES (2, 'Customer 2');

SELECT COUNT(*) FROM customers;

Which two, used independently, can replace so the query returns 1?

AROLLBACK TO SAVEPOINT post_insert;

BROLLBACK TO post_insert;

CCOMMIT TO SAVEPOINT post_insert;

Dcommit;

EROLLBACK,'

Show Answer

Question: 2

BOOK_SEQ is an existing sequence in your schema.

Which two CREATE TABLE commands are valid?

A)

q2_1Z0-071

B)

q2_1Z0-071

C)

q2_1Z0-071

D)

q2_1Z0-071

E)

q2_1Z0-071

AOption A

BOption B

COption C

DOption D

EOption E

Show Answer

Question: 3

Examine these statements which execute successfully:

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYY HH24 :MT:SS;'

ALTER SESSION SET TIME-ZONE = '-5:00;:

Examine the result:

q3_1Z0-071

If LOCALTIMESTAMP was selected at the same time, what would it return?

A11-JUL-2019 6.00.00.00000000 AM

B11-JUL-2019 11.00.00.00000000 AM

C11-JUL_2019 6.00.00.00000000 AM -05:00

D11-JUL_2019 11.00.00.00000000 AM -05:00

Show Answer

Question: 4

Examine this query and its output:

q4_1Z0-071

Examine this query with an incomplete was WHERE clause:

q4_1Z0-071

Which two are true about operators that can be used In the WHERE clause?

AUsing not in or <> any will give the same result.

BUsing in will display all the product names,

CUsing not in or <> all will give the same result.

DUsing <> any will display all the product names except the product named Fork.

EUsing <> any will display all the product names.

Show Answer

Question: 5

Examine this query:

SELECT 2

FROM DUAL D1

CROSS JOIN DUA d2

CROSSS JOIN DUAL D3

WHERE 2 =3;

What is the result?

ANo rows

BAn error

C3 rows

D8 row

E1 row

F6 rows

Show Answer

Oracle 1Z0-071 Quiz:6 Topic:10 Questions:26-30