Which of the following methods can be used to detect block corruption？（）  

A、 ANALYZE operations

B、 dbv

C、 SQL queries that access the potentially corrupt block

D、 RMAN

E、 All of the above

相关问题推荐

• What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media？（）  

  A、 crosscheck

  B、 list backup

  C、 confirm

  D、 resync

  E、 backup validate

  查看答案

• You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）

  A

   The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.

  B

   RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.

  C

   The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

  D

   ASM compatibility controls which features for the ASM will be enabled.

  查看答案

• Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）

  A、 NLS_LANG

  B、 NLS_COMP

  C、 NLS_SORT

  D、 None of the above

  查看答案

• 下图所示是一种(13)调制方式。

  

  A．ASK

  B．FSK

  C．PSK

  D．DPSK

  查看答案

• Which three statements about performance analysis by SQL Performance Analyzer are true？（）

  A

   It detects changes in SQL execution plans.

  B

   It produces results that can be used to create the SQL plan baseline.

  C

   The importance of SQL statements is based on the size of the objects accessed.

  D

   It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

  E

   It shows only the overall impact on workload and not the net SQL impact on workload.

  查看答案