Question 1

View the Exhibit and examine the structure of the BOOKS table.

The BOOKS table contains details of 100 books.

Examine the commands executed and their outcome:

Which statement is true?

Options :

A : Both ROLLBACK commands restore the 101 rows that were deleted.

B : Both ROLLBACK commands restore the 100 rows that were deleted.

C : The first rollback restores the 101 rows that were deleted and the second rollback causes the row was inserted to be deleted and commits the changes.

D : The first rollback restores the 100 rows that were deleted and the second rollback commits only the changes.

Answer: C

Question 2

Examine the types and examples of relationships that follow:

Which option indicates correctly matched relationships? (Choose the best answer.)

Options :

A : 1-d, 2-b, 3-a, and 4-c

B : 1-c, 2-d, 3-a, and 4-b

C : 1-a, 2-b, 3-c, and 4-d

D : 1-c, 2-a, 3-b, and 4-d

Answer: C

Question 3

.No user-defined locks are used in your database.

Which three are true about Transaction Control Language (TCL)?

Options :

A : COMMIT erases all the transaction-s savepoints and releases its locks.

B : COMMIT ends the transaction and makes all its changes permanent.

C : ROLLBACK without the TO SAVEPOINT clause undoes all the transaction-s changes but does not release its locks.

D :

ROLLBACK to SAVEPOTNT undoes the transaction-s changes made since the named savepoint and then ends the transaction.

E : ROLLBACK without the TO SAVEPOINT clause undoes alt the transaction-s changes, releases its locks, and erases all its savepoints.

F : ROLLBACK without the TO SAVEPOINT clause undoes all the transaction-s changes but does not erase its savepoints.

Answer: A,B,E

Question 4

Which statement is true regarding the default behavior of the ORDER BY clause?

Options :

A : In a character sort, the values are case-sensitive.

B : NULLs are not included in the sort operation.

C : Only columns that are specified in the SELECT list can be used in the ORDER BY clause.

D : Numeric values are displayed in descending order if they have decimal positions.

Answer: A

Question 5

Which three statements are true about the DESCRIBE command? (Choose three.)

Options :

A :

It can be used from SQL Developer.

B :

It can be used to display the structure of an existing view.

C :

It can be used only from SQL*Plus.

D :

It displays the NOT NULL constraint for any columns that have that constraint.

E :

It displays all constraints that are defined for each column.

F :

It displays the PRIMARY KEY constraint for any column or columns that have that constraint.

Answer: A,D,F

Confidently Practice Online with Free 1Z0-071 Exam Cram

Buying Options: