(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.
Running a query on a table returns “ORA-600: Internal Error”

B.
Inserting a value in a table returns “ORA-01722: Invalid Number”

C.
Creating a table returns “ORA-00955: name is already used by an existing object’

D.
Inserting a value in a table returns “ORA-00001: unique constraint (SYS.PK_TECHP) violated.”

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

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 *


Reid

Reid

Please remove option F from this question..E & F are same !

Oracle DBA

Oracle DBA

Please remove option F from this question..E & F are same !

Helcio

Helcio

I think that E is wrong… F is correct:

data block corrupted (file #14, block #50).”

Put attention on # signal.

Example:

ORA-01578: ORACLE data block corrupted (file # 9, block # 25759)

Aramaism Statius

Aramaism Statius

As already noted F is correct and E is essentially F with a typo.

Ed

Ed

A and F are correct in my opinion

ELIJAH

ELIJAH

they are not the same another one has @ symbol another one has # symbol

Alex

Alex

ORA-01578: ORACLE data block corrupted (file # , block # )
ORA-01578: ORACLE data block corrupted (file # 2, block # 88580)

This error message is represented using # instead @. Letter F is correct, not E.