You executed the following command to

You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

A All the objects of scott are moved to the Recycle Bin.
B Any objects in the Recycle Bin belonging to scott are purged.
C All the objects owned by scott are permanently dropped from the database.
D All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

参考答案

参考解析：

分类：OCP 11G认证考试题库

You executed the following commands in a database session:What could have caused the recycle bin to clean up?（）A There is demand for space f...

Examine the commands executed to monitor database operations:$> conn sys oracle/oracle@prod as sysdbaSQL > VAR eid NUMBERSQL > EXEC: eid := DBMS...

The following command is executed to create the baseline template:Which statement is true about the effect of the above command?（）A It creates...

You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDAT...

You execute the following commands to audit database activities:SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;SQL > AUDIT SELECT TA...

You executed the following command:RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';Which statement regarding the above...

编辑推荐