单选题If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）A V_CONTROLFILE_RECORD_SECTION B V_CONTROLFILE C V$PARAMETER D init.ora file

第1题：

In your Certkiller .com production database， you find that the database users are able to create and read files with unstructured data， available in any location on the host machine from an application.  You want to restrict the database users to access files in a specific location on the host machine.  What could do to achieve this？（）

• A、Modify the value for the UTL_FILE_DIR parameter in the parameter file
• B、Grant read and write privilege on the operating system path to the database users
• C、Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file
• D、Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file
• E、Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users

第2题：

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？（）

• A、 backup pieces
• B、 copies of all the parameter files
• C、 trace file generated using BACKUP CONTROLFILE TO TRACE
• D、 control file autobackups

第3题：

In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

• A、the alert log file
• B、the core dump files
• C、the change tracking file
• D、the user session trace files
• E、the database audit trail files
• F、the background process trace files

第4题：

The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five/x7fdigit number starting with 0.  What could be the possible reason？（）

• A、These are the data files that are corrupted.
• B、There is no SYSAUX tablespace in your database
• C、There is a read­only tablespace in your database.
• D、These are the data files that cannot be recovered.

第5题：

You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）.  In which two sources would you find the DBID？ （）

• A、the trace file
• B、the alert log file
• C、an RMAN session log file
• D、the server parameter file
• E、the formatted name of a control file autobackup

第6题：

You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？ （）

• A、 the alert log file
• B、 the server parameter file
• C、 the formatted name of a control file autobackup
• D、 an RMAN session log file
• E、 the trace file

第7题：

You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）

• A、to enable the ASM instance to identify the alert log file
• B、to enable the ASM instance to identify the server parameter file
• C、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
• D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

第8题：

You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

• A、Image of the control file
• B、Location of the control file
• C、Contents of the control file in text format
• D、SQL command to re-create the database
• E、SQL command to re-create the control file
• F、Contents of the control file in binary format

第9题：

You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process.  Which action will enable you to disable the trace files generated by the ARCn background process？（）  

• A、 Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.
• B、 Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.
• C、 Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.
• D、 Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.

第10题：

In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

• A、the V$LOG view
• B、the V$DBFILE view
• C、the V$LOGFILE view
• D、the V$INSTANCE_RECOVERY view
• E、Oracle Enterprise Manager Database Control