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 purg

题目
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.

相似考题

1.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

2.在oracle数据库下,在启用审计的数据库上执行下面的命令SQL>AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL;有关此命令的影响描述正确的是?()A.每一个会话drop属于scott用户的表成功就会产生一条审计记录B.凡是每一个scott用户会话成功droptable操作，就会存在一条审计记录C.同一个scott会话中，drop一张或多张表成功就会产生一条审计记录D.scott用户授权给其它用户droptable权限时就会生成一条审计记录

3.You want to test a configured screen value prior to deploying.Which statement will allow you to accomplish this?()A. [edit security screen] user@host# show ids-option untrust-screen { alarm-test-only; }B. [edit security screen] user@host# show ids-option untrust-screen { alarm-without-drop; }C. [edit security screen] user@host# show ids-option untrust-screen { alarm-no-drop; }D. [edit security screen] user@host# show ids-option untrust-screen { test-without-drop; }

4.WhatwillbetheresultofusingtheSQL>DROPUSERSCOTTCASCADE;command?()A.Theuser，Scott，isdropped，alltheobjectsinScott’sschemaareplacedintheRecycleBin，andtheobjectsthatarealreadyintheRecycleBinaredropped.B.Theuser，Scott，isdropped，alltheobjectsinScott’sschemaareplacedintheRecycleBin，andalltheobjectsintheRecycleBin，belongingtotheuserScott，arenotdropped.C.Theuser，Scott，isdropped，alltheobjectsintheScott’sschemaarenotplacedintheRecycleBin，andtheobjectsintheRecycleBin，belongingtotheuser，Scott，arenotdropped.D.Theuser，Scott，isdropped，alltheobjectsinScott’sschemaarenotplacedintheRecycleBin，andtheobjectsintheRecycleBinaredropped.

更多“You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct?() ”相关问题

  • 第1题：

    A盘为启动盘，其目录结构为：  根目录下有COMMAND.COM文件 和DOS 子目录，该子目录下又有 AUTOEXEC.BAT和 USER。其中AUTOEXEC.BAT的内容为：MD /XYZ CD/DOS/USER  则由A盘启动成功后，A盘的当前目录为（）。

    AA：/DOS/USER>

    BA：/XYZ

    CA：/>

    DA：/DOS


    C
    略

  • 第2题：

    下列哪组SQL命令全部属于数据定义语句的命令？（）

    A．CREATE，DROP，ALTER

    B．CREATE，DROP，SELECT

    C．CREATE，DROP，GRANT

    D．CREATE，DROP，UPDATE


    CREATE，DROP，ALTER

  • 第3题：

    4、在JSP中要使用user包中的User类，则以下写法正确的是（）。

    A．＜jsp:useBeam id=”user” class=”user” import=”user.*”/＞

    B．＜jsp:useBean id=”user” class=”user.User” scope=”page”/＞

    C．＜jsp:useBean class=”user.Use.class”/＞

    D．＜jsp:useBean name=”user” class=”user.User”/＞


    “user”class=“user.User” scope=“page”/＞

  • 第4题：

    下列四组SQL命令，全部属于数据定义语句的命令是（）

    A．CREATE，DROP，UPDATE

    B．CREATE，DROP，ALTER

    C．CREATE，DROP，GRANT

    D．CREATE，DROP，SELECT


    CREATE ， DROP ， ALTER

  • 第5题：

    J2EE中在JSP中要使用user包中的User类，则以写法正确的是（）。

    A．＜jsp:useBeam id="user" class="user" import="user.*"/＞

    B．＜jsp:useBean id="user" class="user.User" scope="page"/＞

    C．＜jsp:useBean class="user.Use.class"/＞

    D．＜jsp:useBean name="user" class="user.User"/＞


    B

  • 第6题：

    下列四组SQL命令，全部属于数据定义语句的命令是（）。

    A．CREATE，DROP，ALTER

    B．CREATE，DROP，UPDATE

    C．CREATE，DROP，GRANT

    D．CREATE，DROP，SELECT


    CREATE ， DROP ， ALTER

相关内容