You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

A、 The index tablespace contains bitmap indexes.

B、 The index tablespace contains more than one data file.

C、 The index tablespace supports only complete recovery.

D、 The index tablespace is not a dictionary-managed tablespace.

E、 There is a dependency relationship between a table and its indexes.

相关问题推荐

• 下列程序的运行结果为 #include＜iostream.h＞ template＜class TT＞ class FF {TT a1，a2，a3； public： FF(TT b1，TT b2，TT b3){a1＝b1；a2=b2；a3＝b3；} TT Sum(){return a1+a2+a3；}}； void main() { FF＜int＞x(int(1.1)，2，3)，y(int(4.2)，5，6)； cout＜＜x.Sum()＜＜‘‘＜

  A．6.1 15.2

  B．6 15

  C．6 15.2

  D．6.1 15

  查看答案

• Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）

  A、 The user must have been granted the DBA role.

  B、 The user must have been granted the switch privilege as a part of a role.

  C、 The user must have been granted the Resource Manager administrator privilege.

  D、 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

  查看答案

• In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

  A、 when all the online redo log groups are multiplexed and one of the members of a group is missing

  B、 when all the online redo log groups are not multiplexed and one log group is missing

  C、 when all the control files are missing

  D、 when some important tables are deleted from the database and purged from the Recycle Bin

  查看答案

• You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

  A、 Memory Advisor

  B、 Segment Advisor

  C、 SQL Access Advisor

  D、 Automatic Workload Repository （AWR）

  E、 Automatic Database Diagnostic Monitor （ADDM）

  查看答案

• You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

  A

  You must ensure that the SALES database is mounted or open.

  B

  You must restore a backup control file to perform a block media recovery.

  C

  You must take the tools01.dbf data file offline before you start a block media recovery.

  D

  You must put the database in NOARCHIVELOG mode to perform a block media recovery.

  E

  You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

  查看答案