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

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


RAJALAKSHMI

RAJALAKSHMI

Correct answer is A and F..

Ishti

Ishti

E & F are the same. 🙂

randeep singh

randeep singh

yes they diff, ‘@’ ~~ ‘#’

jean

jean

The alert log is a chronological log of messages and errors, and includes the following items:

All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60)

Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements

Google

Google

Here are several of the web-sites we suggest for our visitors.