What will be the result of using the SQL> DROP USER SCOTT CASCADE; command?()
A The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and the objects that are already in the Recycle Bin are dropped.
B The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and all the objects in the Recycle Bin, belonging to the user Scott, are not dropped.
C The user, Scott, is dropped, all the objects in the Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin, belonging to the user, Scott, are not dropped.
D The user, Scott, is dropped, all the objects in Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin are dropped.
正确答案
答案解析
相似试题
(单选题)
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?()
(单选题)
You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?()
(多选题)
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant?()
(单选题)
What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED; command?()
(单选题)
If a job references a schedule that has been disabled, what will be the result?()
(单选题)
What view might you use to try to determine how long a particular backup will take?()
(单选题)
What view might you use to try to determine how long a particular backup will take?()
(单选题)
You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file: DB_BLOCK_CHECKING = TRUE; What will be the result of setting this parameter?()
(单选题)
You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason?()