Your database has a backup that was taken yesterday （Tuesday

第1题：

第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题：

第4题：

You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

• A、 incomplete recovery
• B、 complete recovery
• C、 recovery using the Flashback Database feature
• D、 recovery using the export/import utility

第5题：

You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?（） (Choose two).

• A、The backup as copy can only be taken to disk
• B、The backup as copy can only be taken to tape
• C、Backup can be performed only when the instance is shutdown
• D、Backup will constitute all used and unused blocks in the database

第6题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

• A、 control file
• B、 all datafiles
• C、 password file
• D、 online redo log file
• E、 archive redo log file
• F、 server parameter file
• G、 only the SYSTEM datafile

第7题：

You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）

• A、 The backup will not be performed at all.
• B、 three times
• C、 four times
• D、 six times

第8题：

第9题：

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）  

• A、 Yes， if the database is in ARCHIVELOG mode
• B、 Yes， if the database is in NOARCHIVELOG mode
• C、 No， the backup is not usable in any way
• D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

第10题：

A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

• A、 backup database all
• B、 backup compressed database
• C、 backup as compressed backupset database
• D、 backup as compressed backup database plus archivelog all
• E、 backup as compressed backupset database plus compress archivelog all