【单选题】On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Whic...
A.
You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
B.
You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
C.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
D.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
【单选题】Evaluate the following SQL statements in the given order: DROP TABLE dept? CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10))? DROP TABLE dept? FLASHBACK TABLE dept TO BEFORE DROP...
A.
It recovers only the first DEPT table.
B.
It recovers only the second DEPT table.
C.
It does not recover any of the tables because FLASHBACK is not possible in this case.
D.
It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN.