You&ensp;issued&ensp;the&ensp;followin...

单项选择题 You issued the following command to analyze the SCOTT.EMP table for block corruption：
ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error：
ORA-01578： ORACLE data block corrupted （file # %s， block # %s）
How will you resolve the block corruption problem？（）

A. by using the DBMS_REPAIR package
B. by using the DB_BLOCK_CHECKING parameter
C. by using the DBVERIFY utility
D. will not be completely resolved until the hardware fault is corrected

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题 You received the following error：
ORA-01578： ORACLE data block corrupted
（file # %s， block # %s）
Which file will you check to view additional information regarding the cause of this error？（）

A.the alert log file and the trace files
B. the redo log files
C. the control file
D. the change tracking file

点击查看答案

2.单项选择题You want to rebuild a free list in the free lists of the EMPLOYEE table in the Scott schema. Which package will you use to accomplish this？（）

A. DBMS_REPAIR
B. DBMS_SCHDULER
C. DBMS_STATS
D. DBMS_RESOURCE_MANAGER

点击查看答案

3.单项选择题 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

点击查看答案

4.单项选择题 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.

点击查看答案

5.单项选择题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.

点击查看答案

6.单项选择题You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

A. V$BACKUP_CORRUPTION
B. V$COPY_CORRUPTION
C. V$DATABASE_BLOCK_CORRUPTION
D. RC_BACKUP_CORRUPTION

点击查看答案

7.单项选择题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

A. VERSIONS_STARTSCN
B. VERSIONS_STARTTIME
C. VERSIONS_XID
D. VERSIONS_OPERATION

点击查看答案

8.单项选择题What will be the result of using the SQL> DROP USER SCOTT CASCADE； command？（）

A. The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are already in the Recycle Bin are dropped.
B. The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped.
C. The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped.
D. The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.

点击查看答案

9.单项选择题 You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：
SQL> FLASHBACK TABLE ORDERS TO SCN 771513；
What is the prerequisite to perform Flashback Table？（）

A. You must configure OMF in your database.
B. You must enable block change tracking feature in your database.
C. You must enable ROW MOVEMENT feature on the ORDERS table.
D. You must use the Flashback Version Query before using the Flashback Table feature.

点击查看答案

10.单项选择题 You are working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200.
The user， Scott， issued the following statement to modify the record of the employee， ’E0025’：
SQL>UPDATE EMPLOYEE SET SALARY = 2000
WHERE EMPNO = ’E0025’；
SQL>COMMIT；
On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’：
SQL>UPDATE EMPLOYEE SET SALARY = 2400
WHERE EMPNO = ’E0025’；
SQL>COMMIT；
On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’
SQL>UPDATE EMPLOYEE SET SALARY = 2900
WHERE EMPNO = ’E0025’；
SQL>COMMIT；
On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）

A. Flashback Drop
B. Flashback Table
C. Flashback Database
D.Flashback Version Query

点击查看答案