关闭

053第85题

标签: ocp
499人阅读 评论(0) 收藏 举报
分类:

85.You executed the following command to drop a user:
DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.)
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.
Answer: BC



When you issue the DROP USER ... CASCADE command, the user and all the objects owned by the
user are permanently dropped from the database. Any objects in the recycle bin belonging to the
dropped user are purged.



0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:19360次
    • 积分:613
    • 等级:
    • 排名:千里之外
    • 原创:39篇
    • 转载:7篇
    • 译文:4篇
    • 评论:2条
    文章分类
    最新评论