You execute the following command to audit the database acti

第1题：

RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

• A、’SQL ALTER DATABASE OPEN’；
• B、SQL ALTER DATABASE ’OPEN’；
• C、OPEN DATABASE；
• D、DATABASE OPEN

第2题：

You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? （）

• A、SYS, SYSTEM
• B、SCOTT
• C、Only for successful executions
• D、Only for failed executions
• E、Both successful and failed executions

第3题：

第4题：

You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）

• A、 SYSDATE should not be used with TIMESTAMP.
• B、 The database must have multiplexed redo log files.
• C、 The database must be in the MOUNT state to execute the command.
• D、 The database must be opened with the RESETLOGS option after the flashback operation.
• E、 The entire database needs to be restored from the most recent backup before the flashback operation.

第5题：

You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）

• A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
• B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
• C、 The command will execute successfully and resumable space will be allocated at the session level.
• D、 The command will execute successfully and resumable space will be allocated at the instance level.

第6题：

You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

• A、 The database must have multiplexed redo log files
• B、 The database must be in the MOUNT state to execute the command
• C、 The database must be in the NOMOUNT state to execute the command
• D、 The database must be opened in RESTRICTED mode before this operation
• E、 The database must be opened with the RESETLOGS option after the flashback operation

第7题：

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

第8题：

You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）

• A、The database is in NOMOUNT state.
• B、The database is in ARCHIVELOG mode and the tablespace is online.
• C、The database is in ARCHIVELOG mode and the tablespace is offline.
• D、The database is in NOARCHIVELOG mode and the tablespace is online.
• E、The database is in NOARCHIVELOG mode and the tablespace is offline.

第9题：

our database is in the MOUNT state and you execute the following command to open it：  ALTER DATABASE OPEN  What two actions are performed as a result of this command？（）

• A、All control files are opened.
• B、All redo log files are opened
• C、The password file is opened.
• D、The parameter file is opened.
• E、All online data files are opened.

第10题：

You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

• A、 You will need to open the database with the resetlogs command.
• B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
• C、 You will use the resetlogs version of the create controlfile command.
• D、 You will use the noresetlogs version of the create controlfile command.
• E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command