单选题Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to

第1题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

• A、Hot backup
• B、Online backup
• C、consistent backup
• D、incremental backup
• E、inconsistent backup

第2题：

Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  

• A、 Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.
• B、 Just back up the database datafiles without shutting down the database.
• C、 You will have to wait until you can shut down the database to perform the backup.
• D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
• E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

第3题：

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.

第4题：

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

• A、Database Datafiles 
• B、Database Control Files 
• C、Online redo logs
• D、Archived redo logs 
• E、The database SPFILE 
• F、None of the above, all these files are backed up. 

第5题：

Which two are characteristics of user-managed backup and recovery operations？（）

• A、Recovery is initiated using SQL*Plus.
• B、Database files are backed up using SQL commands.
• C、Database files are backed up with Recovery Manager.
• D、Database files are restored using Recovery Manager.
• E、Database files are backed up using operating system commands.

第6题：

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

• A、 Database datafiles
• B、 Control files
• C、 Archived redo logs
• D、 Online redo logs
• E、 Flashback logs

第7题：

Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）

• A、adding a new user to the database
• B、dropping a user from the database
• C、dropping a table from the database
• D、dropping a data file from a tablespace
• E、adding a new tablespace to the database

第8题：

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

第9题：

you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

• A、 True
• B、 False

第10题：

Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

• A、only the control file, the current SPFILE, and data files
• B、only the current SPFILE and data files if autobackup is disabled
• C、only the data files and the archived redo logs
• D、the control file, current SPFILE file, data files, and archived redo logs