Which two cases about using the flashback table and drop features are true?

Exhibit:
View the Exhibit and examine each case.
Which two cases about using the flashback table and drop features are true? (Choose two.)


View the Exhibit and examine each case.
Which two cases about using the flashback table and drop features are true? (Choose two.)

A.
CASE 1

B.
CASE 2

C.
CASE 3

D.
CASE 4

Explanation:

B : is impossible, you cannot drop any datafile.
/u02/ORACLE/TST12/praidx01.dbf
/u03/ORACLE/TST12/telecom01.dbf
/u02/ORACLE/TST12/tools01.dbf
/u02/ORACLE/TST12/aud_01.dbf
/u02/ORACLE/TST12/undo2.dbf
21 rows selected.
SQL> drop datafile ‘/u02/ORACLE/TST12/praidx01.dbf’ ; drop datafile’/u02/ORACLE/TST12/praidx01.dbf’
*
ERROR at line 1:
ORA-00950: invalid DROP option



Leave a Reply 0

Your email address will not be published. Required fields are marked *