In which scenario will you create a sorted hash cluster？ （）

A、 if the application uses queries joining tables only occasionally

B、 if the full table scan is executed often on only one table of the clustered tables

C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks

D、 when you want the data to be returned automatically in the chronological order

相关问题推荐

• 与语句cout＜＜endl；不等价的是()。

  A．cout＜＜‘’；

  B．cout＜＜‘12’；

  C．cout＜＜‘xA’；

  D．cout＜＜‘’；

  查看答案

• You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）

  A、 RMAN would use the current operating system location to place the backup.

  B、 RMAN would use the control file of the target database to maintain the backup.

  C、 RMAN would use the recovery catalog of the target database to maintain the backup.

  D、 RMAN would use the control file of the target database to maintain the backup metadata.

  E、 RMAN would use the recovery catalog of the target database to maintain the backup metadata.

  查看答案

• Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

  A、mount the new disk group in the ASM instance

  B、restart the ASM instance and the production database instance

  C、register the new disk groups in the production database instance

  D、restart the ASM instance without restarting the production database instance

  E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

  查看答案

• Which statement correctly describes the change tracking writer （CTWR） background process？（）

  A、 It keeps track of changes in the background processes.

  B、 It records the system change number （SCN） in the control file.

  C、 It writes audit records for user changes to the change tracking file.

  D、 It records any changes to the listened configuration in the listener.ora file.

  E、 It records any changes to the database parameters in the change tracking file.

  F、 It records the physical location of all the changes that are made to the database in the change tracking file.

  查看答案

• View the Exhibit and examine the Flashback SCNs.  A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery， you chose 2004343 as the Flashback SCN.  Which two statements are correct in this scenario？（）

  A

  Only the row with DEPARTMENT_ID 290 would be flashed back.

  B

  The rows with DEPARTMENT_ID 290 and 300 would be flashed back.

  C

  The rows with DEPARTMENT_ID 290 and 280 would be flashed back.

  D

  You would have taken the USERS tablespace offline before starting the Flashback Table operation.

  E

  You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation.

  查看答案