首页计算机考试Oracle认证
(单选题)

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.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    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?()

    答案解析

快考试在线搜题