Note the points about data dictionary views and dynamic performance views： 
1.These are stored in the SYSTEM tablespace. 
2.These are the based on the virtual tables. 
3.These are owned by the SYSuser. 
4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE. 
5.V$FIXED_TABLE view can be queried to list the names of these views. 
Which statements listed describe the data dictionary views（）

多项选择题Identifythetwosituationsinwhichthealertlogfileisupdatedwithdetails.（）

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

多项选择题Identifythetwosituationsinwhichyouusethealertlogfileinyourdatabasetocheckthedetails.（）

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

单项选择题You used the IMMEDIATE option to shut down your database instance. Consider the steps that  mayoccur when a database instance is started and database is opened：  1：SGA is allocated.  2：Control file is read.  3：Redo log files are opened.  4：Instance recovery is started.  5：Background processes are started.  6：Data file headers are checked for consistency.  7：Server parameter file or the initialization parameter file is read.  Which option has the correct order in which these steps occur（）

A.7，1，5，2，3，6，4
B.1，5，7，2，3，6；step 4 is not required
C.7，1，5，2，3，6；step 4 is not required
D.1，2，3，5，6，4；step 7 is not required