单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）A When the instance is started B When the database is mounted C When the database is opened D When the datab

第1题：

You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

• A、You must have started the database instance in restricted mode.
• B、You must have started the database instance inNORMALmode.
• C、You must have started the database instance with server parameter file.
• D、You must have started the database instance but must not have mounted.
• E、You must have started the database instance but must not have opened.

第2题：

You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

• A、The trace file
• B、The fixed views
• C、The data dictionary views
• D、The operating system log fields
• E、The dynamic performance views.

第3题：

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）

• A、 MMON
• B、 LGWR
• C、 ARCH
• D、 ARWR
• E、 COPY

第4题：

Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）  

• A、 Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.
• B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.
• C、 Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.
• D、 The database will open with the file in hot backup mode. You can restart the backup at any time.
• E、 The datafile in hot backup mode will be corrupted and you will have to recover it.

第5题：

In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

• A、Nothing happens
• B、Oracle will automatically switch redo logs when detected 
• C、Oracle eventually won't allow new records to be added to the database 
• D、The instance crashes

第6题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

• A、 when you change the name of a datafile
• B、 when you drop a table from the database
• C、 when you take an export of the database
• D、 when you back up the database using OS utilities
• E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
• F、 when you issue a BACKUP command from inside the RMAN run block

第7题：

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

• A、 The database writer writes to a trace file， indicating that the temporary file is not found.
• B、 The database prompts for a database recovery.
• C、 The database opens normally.
• D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.

第8题：

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）  

• A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
• B、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.
• C、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.
• D、 If you restart the database，the database will not be opened.

第9题：

In which situation would you use static database registration for a listener（）

• A、when multiple databases are to be registered with the listener
• B、when DBAs need to connect remotely to start up the database instance
• C、when users need to connect the database instance using the host naming method
• D、when the database instance that is to be registered with the listener is configured in shared server mode

第10题：

When you create a backup control file， where is the resulting file written to？（）  

• A、 The database user dump destination directory
• B、 The database diagnostic destination directory
• C、 To $ORACLE_HOME/rdbms
• D、 To $ORACLE_HOME/admin
• E、 To the directory and filename you specify in the command