You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here：   Put the tablespaces in backup mode.  Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs. 

第1题：

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

• A、backup of offline tablespaces
• B、backup of read­only tablespaces
• C、backup of system­critical tablespaces
• D、backup of online， locally managed tablespaces
• E、backup of read/write dictionary­managed tablespaces

第2题：

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）

• A、Take the USERS tablespace offline and re-create the lost data file.
• B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
• C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
• D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.

第3题：

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）

• A、Take the USERS tablespace offline and re-create the lost data file.
• B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
• C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
• D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

第4题：

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.

第5题：

Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

• A、 The target database must be in NOARCHIVELOG mode.
• B、 No backup is required of the database before you perform a TSPITR.
• C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
• D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
• E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

第6题：

You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

• A、You can perform consistent backups only.
• B、You can perform a complete database backup without shutting down the database instance.
• C、You can back up data files only when all data files have the same SCN recorded in the control file.
• D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

第7题：

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

第8题：

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

• A、 Backup of offline tablespaces.
• B、 Backup of read-only tablespaces.
• C、 Backup of system-critical tablespaces.
• D、 Backup of online， locally managed tablespaces.
• E、 Backup of read/write dictionary-managed tablespaces.

第9题：

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. 

第10题：

Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）  

• A、 backup database
• B、 backup database and archivelogs
• C、 backup database plus archivelogs
• D、 backup database plus archivelog delete input
• E、 backup database and archivelog delete input