(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 3

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


John

John

the correct answers are C and D.
F is wrong. ORA-01578 error doesn’t contain “@” symbol. there is “#” before block number

Eamon

Eamon

D and F are the same. Some poor dude didnt realise he typed in the same answer twice. The difference is just a typo. Thanks to the dude who typed it in anyways.

Peace to all

satya

satya

not the D and F are the Same, C&F r the same