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

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


Lucas DBA

Lucas DBA

Guys, the correct answers was : C and D

sphinx

sphinx

correct answer is D and F

Leloush

Leloush

Не вводи людей в заблуждение !!

Leloush

Leloush

Не вводи людей в заблуждение !! Correct answers: C & D

dev

dev

F has the invalid character @
instead of #

Tran Van Binh

Tran Van Binh

C and D

Sergio Sathler

Sergio Sathler

There’s an extra character “.” on “C”. That’s why “F” is the correct answer.

jg

jg

F is not correct because @ is used at address of block. It should be #, like
ORA-01578: ORACLE data block corrupted (file # 2, block # 88580)

ct

ct

correct answer is D and F

chu

chu

The answer is:
D.
Running a query on a table returns “ORA-600: Internal Error”

F.
Rebuilding an index using ALTER INDEX…REBUILD fails with an error “ORA-01578:
ORACLE data block corrupted (file # 14, block @ 50).”