Identify the two situations in which the alert log file is updated with details. (Choose two.)
A.
Inserting a value in a table returns “ORA-00001: unique constraint
(SYS.PK_TECHP) violated.”
B.
Creating a table returns “ORA-00955: name is already used by an existing object’
C.
Rebuilding an index using ALTER INDEX …. REBUILD fails with an error
“ORA-01578: ORACLE data block corrupted (file #14, block #50).”
D.
Running a query on a table returns “ORA-600: Internal Error”
E.
Inserting a value in a table returns “ORA-01722: Invalid Number”
F.
Rebuilding an index using ALTER INDEX…REBUILD fails with an error
“ORA-01578: ORACLE data block corrupted (file # 14, block @ 50).”
F is not the correct answer. The answer is C & D
“ORA-01578:ORACLE data block corrupted(file#,block#50).”
Which is the difference between C and F ? they look the same question ?
F does not complaint exactly the sintaxis of the error (@ NO, # YES)
yeah the correct answer is C and D
if we look at the answer C it is the same as the answer F. In this case we can say that if anyone chooses F it is also correct otherwise, f should not exit.
Recovering Individual Blocks
Typically, block corruption is reported in the following locations:
Results of the LIST FAILURE, VALIDATE, or BACKUP … VALIDATE command
The V$DATABASE_BLOCK_CORRUPTION view
Error messages in standard output
The alert log
User trace files
Results of the SQL commands ANALYZE TABLE and ANALYZE INDEX
Results of the DBVERIFY utility
Third-party media management output
For example, you may discover the following messages in a user trace file:
ORA-01578: ORACLE data block corrupted (file # 7, block # 3)
ORA-01110: data file 7: ‘/oracle/oradata/trgt/tools01.dbf’
ORA-01578: ORACLE data block corrupted (file # 2, block # 235)
ORA-01110: data file 2: ‘/oracle/oradata/trgt/undotbs01.dbf’
See Oracle Database Backup and Recovery Guide – 19 Performing Block Media Recovery. C is correct. F is incorrect.