126.Identify the two situations in which you use the alert log file in your database to check the 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.Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."
答案:AE
解析:
参考:http://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11242
我们首先应该了解什么样的错误会出现在alert中
The alert log is a chronological log of messages and errors, and includes the following items:
1.All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
2.Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
3.Messages and errors relating to the functions of shared server and dispatcher processes
4.Errors occurring during the automatic refresh of a materialized view
5.The values of all initialization parameters that had nondefault values at the time the database and instance start
(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.Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."
答案:AE
解析:
参考:http://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11242
我们首先应该了解什么样的错误会出现在alert中
The alert log is a chronological log of messages and errors, and includes the following items:
1.All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
2.Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
3.Messages and errors relating to the functions of shared server and dispatcher processes
4.Errors occurring during the automatic refresh of a materialized view
5.The values of all initialization parameters that had nondefault values at the time the database and instance start