Question 1

Examine this SQL statement:

SELECT cust_id, cust_last_name ''Last Name''

FROM customers

WHERE country_id = 10

UNION

SELECT cust_id CUST_NO, cust_last_name

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

Options :

A : ORDER BY ''Last Name''

B : ORDER BY 2, 1

C : ORDER BY 2, cust_id

D : ORDER BY CUST_NO

E : ORDER BY ''CUST_NO''

Answer: B,C,D

Question 2

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

Options :

A : Duplicates are eliminated automatically by the UNION ALL operator

B : The number of columns selected in each SELECT statement must be identical

C : The names of columns selected in each SELECT statement must be identical

D : The output is sorted by the UNION ALL operator

E : NULLS are not ignored during duplicate checking

Answer: A,B

Question 3

Which two actions can you perform using DBCA for an existing database?

Options :

A : Create a template that can be used to clone the database.

B : Change the server mode from dedicated to shared, and vice versa.

C : Change the character set.

D : Create an additional listener.

E : Create nonstandard block size tablespaces.

Answer: B,C

Question 4

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

Options :

A : Oracle Managed Files (OMF)

B : Online table segment shrink

C : Online index segment shrink

D : Automatic data file extension (AUTOEXTEND)

E : Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Answer: A,D,E

Question 5

Examine the description of the BOOKS table:

Other-Image-23cf679d4-e595-43a2-9926-33e15cdf075b

The table has 100 rows.

Examine this sequence of statements issued in a new session:

INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL);

SAVEPOINT a;

DELETE FROM books;

ROLLBACK TO SAVEPOINT a;

ROLLBACK;

Which two statements are true? (Choose two.)

Options :

A : The second ROLLBACK command does nothing

B : The second ROLLBACK command replays the delete

C : The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

D : The second ROLLBACK command undoes the insert

E : The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Answer: C,D

Higher Test Marks with Free Online 1Z0-082 Exam Practice

Buying Options: