多项选择题

Identify the two situations in which the alert log file is updated with details. （）

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）.

点击查看答案

上一题目录下一题

相关考题

多项选择题

Identify the two situations in which you use the alert log file in your database to check the details.（）

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.Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource."

单项选择题

You want to check the details of few errors that users have reported. You search for the alert log fileand execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file（）

A.ORACLE_HOME/dbs
B.ORACLE_HOME/rdbms
C./u01/app/oracle/admin/orcl/adump
D./u01/app/oracle/flash_recovery_area
E.ORACLE_BASE/diag/rdbms/orcl/orcl/alert
F.ORACLE_BASE/diag/rdbms/orcl/orcl/trace

多项选择题

You executed the following commands to find the location of the alert log file：

Where is the alert log file stored（）

A.in the BACKGROUND_DUMP_DEST location； in text format
B.in the BACKGROUND_DUMP_DEST location； in XML format
C.in the BACKGROUND_DUMP_DEST location； in both text and XML format
D.in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory； in text format
E.in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory； in XML format
F.in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory； in both text and XML format