單項(xiàng)選擇題

You issue the following statement：
SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；
You receive the following error：
01578： ORACLE data block corrupted （file# 6， block # 54）
ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’
How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

A. by using the DBMS_REPAIR package
B. by using the DBVERIFY utility
C. by using Block Media Recovery
D. by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

你可能感興趣的試題

單項(xiàng)選擇題

The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.
What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）

A. The block change tracking feature must be enabled.
B. OMF must be configured on your database.
C. The database must be in ARCHIVELOG mode.
D. A USERID must be supplied.

單項(xiàng)選擇題

You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）

A. Only data blocks of the SYSTEM tablespace will be checked.
B. Only data blocks of the SYSAUX tablespace will be checked.
C. A checksum will occur only on the checkpoint.
D. A checksum will occur every time a block is modified.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）

You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.
What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）

You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）