When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）

A、 INCLUDING DEPENDENCIES

B、 INCLUDING DEPENDENCIES CASCADE

C、 COMPACT

D、 CASCADE

E、 None of the above

相关问题推荐

• Which operation requires that you create an auxiliary instance manually before executing the operation？（）

  A

   Backup-based database duplication.

  B

   Active database duplication.

  C

   Tablespace point-in-time recovery.

  D

   No operation requires the creation of an auxiliary instance.

  查看答案

• Which two statements are true about the duplexing of the backups taken by RMAN？（）  

  A

   It’s only supported for the backups performed on the tape

  B

   It is not supported for backup operations that produce image copies

  C

   Duplex backups need a parallelism for the device to be equal to number of copies

  D

   Duplex backups can be performed to either disk or tape， but cannot be performed on tape and disk simultaneously

  查看答案

• If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string， what happens to disks that are already a part of the same or another disk group？（）  

  A、 The command fails unless you specify the FORCE option.

  B、 The command fails unless you specify the REUSE option.

  C、 The command must be reissued with a more specific discovery string.

  D、 The other disks， already part of the disk group，are ignored.

  查看答案

• Consider the following code snippet：   BEGIN  DBMS_SCHEDULER.SET_ATTRIBUTE （ name => ，，lne_job1， attribute => ，，job_priority， value => 1）；  END；  /   If this code were executed， which of the following statements would be true？（）

  A、 The priority of the lne_job1 job would be set to 1.

  B、 The lne_job1 job would be executed synchronously.

  C、 The lne_job1 job would run immediately in the users current session.

  D、 The lne_job1 job would retain its current priority.

  E、 The job will immediately take priority over all running jobs.

  查看答案

• Which of the following is not an advantage of block media recovery （BMR）？（）

  A、 Reduced MTTR.

  B、 Datafiles remain offline while corrupt blocks are repaired.

  C、 Datafiles remain online while corrupt blocks are repaired.

  D、 A and C

  查看答案