单选题You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message：   SQL startup ORA-01078： failure in processing system parameters LRM-00109：  could not open parameter file ，  C:///ORACLE/PRO

第1题：

When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）

• A、audit trail
• B、alert log file
• C、user trace file
• D、online trace file
• E、background trace file
• F、operating system event viewer

第2题：

You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

• A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
• B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
• C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
• D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

第3题：

第4题：

You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message：   SQL> startup ORA-01078： failure in processing system parameters LRM-00109：  could not open parameter file ，  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN，   how would you respond to this error？（）  

• A、 Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
• B、 Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
• C、 Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
• D、 Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
• E、 Issue the restore spfile from autobackup command from the RMAN prompt.

第5题：

You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）

• A、PMON coordinates media recovery.
• B、SMON coordinates instance recovery.
• C、PMON coordinates instance recovery.
• D、Undo Advisor would roll back all uncommitted transactions.
• E、SQL*PLUS reports an error with the message asking you to perform instance recovery. 

第6题：

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

• A、to enable operating system authentication for a remote client
• B、to restrict the scope of administration to identical operating systems
• C、to allow the start up and shut down of the database from a remote client
• D、to enable the administration of the operating system from a remote client
• E、to disable the administration of the operating system from a remote client

第7题：

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.

第8题：

You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

• A、 The log sequence is reset to 0.
• B、 All the online redo logs are deleted.
• C、 All the archived redo logs from a previous incarnation become useless.
• D、 The full database backup taken from a previous incarnation can be used in future.
• E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

第9题：

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）

• A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
• B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
• C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

第10题：

You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

• A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
• B、 Before the instance starts， you receive an error about the missing redo log files of a group.
• C、 The instance starts and the database opens with an error message written to the alert log file.
• D、 The instance starts and the database opens because two redo log groups still exist.
• E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.