多选题

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.

正确答案

来源:www.examk.com

答案解析

相似试题
  • You executed the following command in Recovery Manager (RMAN):  RMAN> RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()

    单选题查看答案

  • You executed the following commands to find the location of the alert log file: Where is the alert log file stored()

    多选题查看答案

  • You executed the following command in Recovery Manager (RMAN):  RMAN> RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?() 

    单选题查看答案

  • You execute this command in MOUNT mode: ALTER DATABASE ARCHIVELOG;  Where is the information that the database is now in ARCHIVELOG mode stored?()

    单选题查看答案

  • When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics.  Which two statements describe the implications of this?()

    多选题查看答案

  • Before a Flashback Table operation,you execute the following command:   ALTER TABLE employees ENABLE ROW MOVEMENT;   Why would you need this to be executed?()  

    单选题查看答案

  • You execute the following command to start an Automatic Storage Management (ASM) instance:   SQL>STARTUP;   In which of the following modes will the ASM instance start?()

    单选题查看答案

  • You executed the following code:   BACKUP VALIDATE DATABASE;   BLOCKRECOVER CORRUPTION LIST;  What will be the result of executing the above code?()  

    单选题查看答案

  • You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()

    单选题查看答案

  • You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement:   FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;   What will be the result of executing this statement?()

    单选题查看答案