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