You&ensp;executed&ensp;the&ensp;follow...

多项选择题X 纠错

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

点击查看答案进入题库练习

单项选择题

View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instanceis already running. You used the following steps to start the database instance and open the database：

Which file is used to start the instance in this case（）

A.init.ora
B.spfile.ora
C.initorcl.ora
D.spfile+ASM.ora

点击查看答案进入题库练习

多项选择题

After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；
Which two statements are true（）

A.The online redo log files and online data files are opened.
B.All the online data file headers are checked for consistency.
C.Instance recovery is performed before opening the database.
D.The path and existence of all the log file members are checked

点击查看答案进入题库练习

单项选择题

For which database operation would you need the database to be in the MOUNT state（）

A.renaming the control files
B.re-creating the control files
C.dropping a user in your database
D.dropping a tablespace in your database
E.configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

点击查看答案进入题库练习

单项选择题

View the Exhibit and examine the output of the query.

What do you infer from this（）

A.The SGA_TARGET is a static parameter.
B.The instance is started， but the database is not yet open.
C.The server parameter file （SPFILE） was used to start the instance.
D.The SGA_TARGET parameter does not have any effect onthe databaseinstance untiltheSGA_MAX_SIZE parameter is specified.

点击查看答案进入题库练习