单选题Which statement is true regarding the VALIDATE DATABASE command?（）A It checks the database for intrablock corruptions only.B It checks for block corruption in the valid backups of the database.C It checks the database for both intrablock and interblock

题目
单选题
Which statement is true regarding the VALIDATE DATABASE command?（）
A

It checks the database for intrablock corruptions only.

B

It checks for block corruption in the valid backups of the database.

C

It checks the database for both intrablock and interblock corruptions.

D

It checks for only those corrupted blocks that are associated with data files.

相似考题

1.You have the following requirements in relation to the detection of block corruption for your database instance:1. Check for logical self-consistency of data blocks when modified in memory.2. Checksums are calculated before and after the block change.3. Checks are performed for the lost writes to the physical standby database.Which method would help you perform the above checks automatically? （）A. Set the DB_SECUREFILE parameter to PERMITTEDB. Set the DB_ULTRA_SAFE parameter to DATA_ONLYC. Set the DB_LOCK_CHECKSUM parameter to TYPICALD. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL

2.Which statement is true regarding the VALIDATE DATABASE command?()A. It checks the database for intrablock corruptions only.B. It checks for block corruption in the valid backups of the database.C. It checks the database for both intrablock and interblock corruptions.D. It checks for only those corrupted blocks that are associated with data files.

3.Which two statements are true about the RMAN validate database command?()A. It checks the database for intrablock corruptions.B. It can detect corrupt pfiles.C. It can detect corrupt spfiles.D. It checks the database for interblock corruptions.E. It can detect corrupt block change tracking files.

4.Examine the section of the Health Check report given below:Which two statements are true regarding the Health Check report?()A. Health Check was performed manually.B. Health Check was performed to check the disk image block corruptions.C. Health Check was performed to check interblock and intersegment corruption.D. Health Check was performed to verify the integrity of database files and report failures.E. Health Check was performed by the Health Monitor automatically in response to a critical error.

更多“单选题Which statement is true regarding the VALIDATE DATABASE command?（）A It checks the database for intrablock corruptions only.B It checks for block corruption in the valid backups of the database.C It checks the database for both intrablock and interblock”相关问题

  • 第1题：

    You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN >BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

    A. Corrupted blocks, if any, are repaired.

    B. Checks are performed for physical corruptions.

    C. Checks are performed for logical corruptions.

    D. Checks are performed to confirm whether all database files exist in correct locations

    E. Backup sets containing both data files and archive logs are created.


    参考答案：B, D

  • 第2题：

    You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

    • A、Corrupted blocks, if any, are repaired.
    • B、Checks are performed for physical corruptions.
    • C、Checks are performed for logical corruptions.
    • D、Checks are performed to confirm whether all database files exist in correct locations
    • E、Backup sets containing both data files and archive logs are created.

    正确答案:B,D

  • 第3题：

    Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）

    • A、You can perform online whole database backups.
    • B、You can performofflinewhole database backups.
    • C、You cannot perform schema-level export/import operations.
    • D、You can perform the backup of only the SYSTEM tablespace when the database is open.

    正确答案:B

  • 第4题：

    Which of the following are correct about block media recovery？（）

    • A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
    • B、 Logical corruptions are repairable by BMR
    • C、 Physical corruptions are repairable by BMR
    • D、 RMAN can use any backup for a BMR restore
    • E、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore

    正确答案:A,C

  • 第5题：

    Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（）  

    • A、 Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
    • B、 Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent.
    • C、 Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
    • D、 Health Monitor checks are always initiated manually when there is some critical error.

    正确答案:A,B

  • 第6题：

    You have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change.  Checks are performed for the lost writes to the physical standby database.   Which method would help you perform the above checks automatically？（）

    • A、 Set the DB_SECUREFILE parameter to PERMITTED
    • B、 Set the DB_ULTRA_SAFE parameter to DATA_ONLY
    • C、 Set the DB_LOCK_CHECKSUM parameter to TYPICAL
    • D、 Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL

    正确答案:B

  • 第7题：

    多选题
    You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）
    A

    Corrupted blocks, if any, are repaired.

    B

    Checks are performed for physical corruptions.

    C

    Checks are performed for logical corruptions.

    D

    Checks are performed to confirm whether all database files exist in correct locations

    E

    Backup sets containing both data files and archive logs are created.


    正确答案： C,A
    解析： 暂无解析

  • 第8题：

    单选题
    Which statement is true regarding the VALIDATE DATABASE command？（）
    A

     It checks the database for intrablock corruptions only.

    B

     It checks for block corruption in the valid backups of the database.

    C

     It checks the database for both intrablock and interblock corruptions.

    D

     It checks for only those corrupted blocks that are associated with data files.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）
    A

    A different procedure is required to restore a database from compressed backups 

    B

    The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. 

    C

    Using this command to create backups minimizes the bandwidth consumed.

    D

    Using this command to create backups improves the performance of the backup process 


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    Which statement is true regarding the VALIDATE DATABASE command?（）
    A

    It checks the database for intrablock corruptions only.

    B

    It checks for block corruption in the valid backups of the database.

    C

    It checks the database for both intrablock and interblock corruptions.

    D

    It checks for only those corrupted blocks that are associated with data files.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?（）
    A

    A different procedure is required to restore a database from compressed backups

    B

    The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.

    C

    Using this command to create backups minimizes the bandwidth consumed

    D

    Using this command to create backups improves the performance of the backup process


    正确答案： C
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements are true regarding the database in ARCHIVELOG mode？（）
    A

    You have to shut down the database to perform the backups.

    B

    Archiving information is written to the data files and redo log files.

    C

    You can perform complete database backups without closing the database.

    D

    Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

    E

    All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.


    正确答案： E,C
    解析： 暂无解析

  • 第13题：

    Which two statements are true about the RMAN validate database command?（）

    • A、It checks the database for intrablock corruptions.
    • B、It can detect corrupt pfiles.
    • C、It can detect corrupt spfiles.
    • D、It checks the database for interblock corruptions.
    • E、It can detect corrupt block change tracking files.

    正确答案:A,C

  • 第14题：

    You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

    • A、You must shut down the database instance to perform the backups.
    • B、You must configure the Flash Recovery Area （FRA） for the database.
    • C、You can perform complete database backups without closing the database.
    • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

    正确答案:C,D

  • 第15题：

    You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）

    • A、A different procedure is required to restore a database from compressed backups 
    • B、The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. 
    • C、Using this command to create backups minimizes the bandwidth consumed.
    • D、Using this command to create backups improves the performance of the backup process 

    正确答案:C

  • 第16题：

    Which statement is true regarding the VALIDATE DATABASE command?（）

    • A、It checks the database for intrablock corruptions only.
    • B、It checks for block corruption in the valid backups of the database.
    • C、It checks the database for both intrablock and interblock corruptions.
    • D、It checks for only those corrupted blocks that are associated with data files.

    正确答案:A

  • 第17题：

    You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

    • A、 Create a backup of the database and recover all corrupted blocks found in the backup.
    • B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
    • C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.
    • D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.
    • E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

    正确答案:D

  • 第18题：

    单选题
    You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）
    A

     Create a backup of the database and recover all corrupted blocks found in the backup.

    B

     Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.

    C

     Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.

    D

     Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.

    E

     Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
    A

    You can perform online whole database backups.

    B

    You can performofflinewhole database backups.

    C

    You cannot perform schema-level export/import operations.

    D

    You can perform the backup of only the SYSTEM tablespace when the database is open.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    多选题
    Which two statements are true about the RMAN validate database command?（）
    A

    It checks the database for intrablock corruptions.

    B

    It can detect corrupt pfiles.

    C

    It can detect corrupt spfiles.

    D

    It checks the database for interblock corruptions.

    E

    It can detect corrupt block change tracking files.


    正确答案： E,C
    解析： 暂无解析

  • 第21题：

    单选题
    You have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change.  Checks are performed for the lost writes to the physical standby database.   Which method would help you perform the above checks automatically？（）
    A

     Set the DB_SECUREFILE parameter to PERMITTED

    B

     Set the DB_ULTRA_SAFE parameter to DATA_ONLY

    C

     Set the DB_LOCK_CHECKSUM parameter to TYPICAL

    D

     Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）
    A

    DBCC DBREINDEX

    B

    SELECT * FROM sys.dm_db_index_physical_stats

    C

    DBCC INDEXDEFRAG

    D

    SELECT * FROM sys.indexes


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You enable block change tracking. You issue the following command：   BACKUP INCREMENTAL LEVEL 0 DATABASE；   The next day，you issue the following command：   BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which statement about the use of the change tracking file is true？（）
    A

     RMAN reads the block change tracking file only when it performs the incremental level 0 backup.

    B

     RMAN reads the block change tracking file when it performs both incremental backups.

    C

     RMAN reads the block change tracking file only when it performs the incremental level 1 backup.

    D

     RMAN does not read the block change tracking file when it performs either incremental backup.


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    You have the following requirements in relation to the detection of block corruption for your database instance: 1. Check for logical self-consistency of data blocks when modified in memory. 2. Checksums are calculated before and after the block change. 3. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically? （）
    A

    Set the DB_SECUREFILE parameter to PERMITTED

    B

    Set the DB_ULTRA_SAFE parameter to DATA_ONLY

    C

    Set the DB_LOCK_CHECKSUM parameter to TYPICAL

    D

    Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL


    正确答案： C
    解析： 暂无解析

相关内容