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.
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?()
单选题查看答案