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.

相关问题推荐

• 男性，58岁，因右肺中央型肺癌行右肺切除术。术后留置胸管，目前处于钳闭状态。全肺切除患者术后输液滴速一般每分钟不超过（）

  A、20滴

  B、30滴

  C、40滴

  D、60滴

  E、80滴

  查看答案

• What is the result？（）

  A、 2

  B、 24

  C、 234

  D、 246

  E、 2346

  F、 Compilation fails.

  查看答案

• An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）

  A、TEST_TBS is a small file tablespace.

  B、TEST_TBS is a bigfile tablespace (BFT).

  C、TEST_TBS is the default temporary tablespace.

  D、TEST_TBS is a dictionary-managed tablespace.

  查看答案

• 阅读以下程序，输出结果为（）。

  查看答案

• Which statement about recovering from the loss of a redo log group is true?（）

  A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.

  B、If the lost redo log group is CURRENT, you must clear the log file.

  C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

  D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

  查看答案