多选题You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are

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

2. At the request of a user， you issue the following command to restore a dropped table： flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop； Later， the user notifies you that the data in the table seems to be very old and out of date.  What might be the problem？（）  A、 Because a proper range of SCNs was not specified， the wrong data was restored.B、 A proper range of timestamps was not specified， so the wrong data was restored.C、 A previous Flashback Drop operation had been performed， resulting in multiple versions of the table being stored in the Recycle Bin.D、 Either option A or B could be correct. Not enough information was provided to determine which.E、 None of the above.

3.You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued

4.授予删除任何表的系统权限（DROP ANY TABLE）给user1，并使其能继续授该权限给其他用户，以下正确的SQL语句是（）A、Grant drop any table to user1B、Grant drop any table to user1 with admin optionC、Grant drop table to user1D、Grant drop any table to user1 with check potion

参考答案和解析
正确答案： C,D
解析： 暂无解析
更多“You executed the following command to drop a user：   DROP US”相关问题

  • 第1题：

    You issued the following command：        SQL> DROP TABLE MYTABLE；        SQL> SHOW RECYCLEBIN  The following output is returned：        ORIGINAL NAME RECYCLEBIN NAME               OBJECT TYPE      DROP TIME        ------------- ------------------------------ --------------- --------------------        MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0     TABLE           2005-01-13：20：11：31  You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）

    • A、 DROP TABLE MYTABLE PURGE；
    • B、 PURGE RECYCLEBIN；
    • C、 PURGE TABLE MYTABLE；
    • D、 PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；

    正确答案:C,D

  • 第2题：

    In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）

    • A、 This command would result in an error because the disk group is not empty.
    • B、 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
    • C、 The command would result in the contents being moved to the parent disk group and dropping of the disk group.
    • D、 The command would result in the disk group being marked as INVALID because it cannot be dropped.
    • E、 The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.

    正确答案:A

  • 第3题：

    You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；  Which statement describes the result（）

    • A、The command produces an error.
    • B、The profile is dropped and current user sessions use the DEFAULT profile immediately.
    • C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
    • D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.

    正确答案:A

  • 第4题：

    多选题
    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.


    正确答案： C,D
    解析： 暂无解析

  • 第5题：

    单选题
    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?（）
    A

    Issue the ALTER DISKGROUP ... ADD DISK command.

    B

    Issue the ALTER DISKGROUP ... UNDROP DISKS command.

    C

    Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

    D

    Retrieve the disk from the Recycle Bin after the operation completes


    正确答案： B
    解析： 暂无解析

  • 第6题：

    单选题
    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yetcompleted?（）
    A

    Issue the ALTER DISKGROUP ... ADD DISK command.

    B

    Issue the ALTER DISKGROUP ... UNDROP DISKS command.

    C

    Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

    D

    Retrieve the disk from the Recycle Bin after the operation completes.


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）
    A

    Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.

    B

    Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.

    C

    One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.

    D

    One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.

    E

    One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;  What is the effect of this command？（）
    A

    One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.

    B

    One audit record is created for every session when any user successfully drops a table owned by SCOTT.

    C

    One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.

    D

    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.

    E

    One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    多选题
    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
    A

    All data along with the table structure is deleted

    B

    The pending transaction in the session is committed

    C

    All indexes on the table will remain but they are invalidated

    D

    All views and synonyms will remain but they are invalidated

    E

    All data in the table are deleted but the table structure will remain


    正确答案： B,C
    解析： 暂无解析

  • 第10题：

    单选题
    You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；  Which statement describes the result（）
    A

    The command produces an error.

    B

    The profile is dropped and current user sessions use the DEFAULT profile immediately.

    C

    The profile is dropped and only the subsequent user sessions use the DEFAULT profile.

    D

    The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    What is the net effect of the following command？（）   alter diskgroup dgroup1 drop disk abc；
    A

     The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.

    B

     The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.

    C

     The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.

    D

     This command will fail because you cannot drop a specific disk in an ASM disk group.

    E

     The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

    • A、All data along with the table structure is deleted 
    • B、The pending transaction in the session is committed 
    • C、All indexes on the table will remain but they are invalidated 
    • D、All views and synonyms will remain but they are invalidated 
    • E、All data in the table are deleted but the table structure will remain

    正确答案:A,B,D

  • 第13题：

    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

    • A、The table is moved to the SYSAUX tablespace.
    • B、The table is moved to the SYSTEM tablespace.
    • C、The table is removed from the database permanently.
    • D、The table is renamed and remains in the TBSFD tablespace.

    正确答案:D

  • 第14题：

    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）

    • A、It fails to delete the records because the records are locked in SHARE mode.
    • B、It deletes the rows successfully because the table is locked in SHARE mode
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第15题：

    单选题
    You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）
    A

    Use the DROP DATAFILE command.

    B

    Use the DROP TABLESPACE command.

    C

    Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.

    D

    Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.


    正确答案： D
    解析： 暂无解析

  • 第16题：

    单选题
    At the request of a user， you issue the following command to restore a dropped table： flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop； Later， the user notifies you that the data in the table seems to be very old and out of date.  What might be the problem？（）
    A

     Because a proper range of SCNs was not specified， the wrong data was restored.

    B

     A proper range of timestamps was not specified， so the wrong data was restored.

    C

     A previous Flashback Drop operation had been performed， resulting in multiple versions of the table being stored in the Recycle Bin.

    D

     Either option A or B could be correct. Not enough information was provided to determine which.

    E

     None of the above.


    正确答案： C
    解析： 暂无解析

  • 第17题：

    多选题
    You issued the following command：        SQL> DROP TABLE MYTABLE；        SQL> SHOW RECYCLEBIN  The following output is returned：        ORIGINAL NAME RECYCLEBIN NAME               OBJECT TYPE      DROP TIME        ------------- ------------------------------ --------------- --------------------        MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0     TABLE           2005-01-13：20：11：31  You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）
    A

    DROP TABLE MYTABLE PURGE；

    B

    PURGE RECYCLEBIN；

    C

    PURGE TABLE MYTABLE；

    D

    PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；


    正确答案： A,B
    解析： 暂无解析

  • 第18题：

    单选题
    After executing the command alter diskgroup disk group2 drop disk dg2a； you issue the following command from the ASM instance：   Select group_number， count（*） from v$asm_operation；   What is the implication if the query against V$ASM_OPERATION returns zero rows？（）
    A

     The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.

    B

     The drop disk operation is complete and you can run the undrop disks command if needed.

    C

     The drop disk operation is complete and you cannot run the undrop disk command.

    D

     The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. 

    E

     None of the above is true.


    正确答案： E
    解析： 暂无解析

  • 第19题：

    单选题
    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）
    A

    It fails to delete the records because the records are locked in SHARE mode.

    B

    It deletes the rows successfully because the table is locked in SHARE mode

    C

    It fails to delete the records because the table is locked in EXCLUSIVE mode.

    D

    It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）
    A

     This command would result in an error because the disk group is not empty.

    B

     The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.

    C

     The command would result in the contents being moved to the parent disk group and dropping of the disk group.

    D

     The command would result in the disk group being marked as INVALID because it cannot be dropped.

    E

     The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）
    A

    The table is moved to the SYSAUX tablespace.

    B

    The table is moved to the SYSTEM tablespace.

    C

    The table is removed from the database permanently.

    D

    The table is renamed and remains in the TBSFD tablespace.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


    正确答案： C,B
    解析： 暂无解析

相关内容