You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.  You can use Segment Advisor to （）

A、 identify the segments that you should shrink

B、 modify the storage parameters for the tablespace

C、 automatically shrink the segments with unused space

D、 check the alerts generated for the tablespace that is running low on space

相关问题推荐

• Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）

  A、The shrink operation touches every block in the BOOKING table

  B、The high-water mark (HWM) for the BOOKING table is shifted from its original position

  C、The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

  D、The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

  查看答案

• If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）  

  A、 Recover the online redo log from backup.

  B、 Delete and re-create the log file.

  C、 Use the alter database clear logfile command to clear the log file.

  D、 Shut down the database and restart it.

  E、 Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.

  查看答案

• If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）

  A

   The next time you back up the database when you are also connected to the recovery catalog and the target database

  B

   The next time you are connected to the target database and the recovery catalog database and issue the resync command

  C

   The next time you connect RMAN to just the recovery catalog

  D

   The next time you connect to the recovery catalog and the target database with RMAN

  E

   Connecting to the recovery catalog and issuing the resync all databases command

  查看答案

• Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?（）

  A、SQL Access Advisor recommendations are automatically implemented.

  B、Individual SQL Access Advisor recommendations can be scheduled for implementation.

  C、All SQL Access Advisor recommendations for a specific task must be implemented at the same time.

  D、SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.

  E、None of the above.

  查看答案

• You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.  Which parameter should you specify to control the speed of the rebalancing activity？（）

  A、 ASM_POWER_LIMIT

  B、 ASM_DISKSTRING

  C、 ASM_DISKGROUPS

  D、 INSTANCE_TYPE

  查看答案