(Choose two.)

Identify the two situations in which the alert log file is updated with details. (Choose two.)

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).”



Leave a Reply 7

Your email address will not be published. Required fields are marked *


heyu

heyu

F is not the correct answer. The answer is C & D
“ORA-01578:ORACLE data block corrupted(file#,block#50).”

oraclepat65

oraclepat65

Which is the difference between C and F ? they look the same question ?

guaose

guaose

F does not complaint exactly the sintaxis of the error (@ NO, # YES)

maddy

maddy

yeah the correct answer is C and D

YAWO FAUSTIN AZIAKPO

YAWO FAUSTIN AZIAKPO

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.

Scott

Scott

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’

Ed

Ed

See Oracle Database Backup and Recovery Guide – 19 Performing Block Media Recovery. C is correct. F is incorrect.