单选题You executed the following command to perform a backup of the USERS tablespace：SQL> ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could b

第1题：

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）  

• A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
• B、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.
• C、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.
• D、 If you restart the database，the database will not be opened.

第2题：

Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）  

• A、 alter tablespace DAVE_TBS backup mode
• B、 alter tablespace DAVE_TBS start backup
• C、 alter tablespace DAVE_TBS begin backup
• D、 alter tablespace DAVE_TBS backup begin
• E、 alter tablespace DAVE_TBS backup

第3题：

You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）

• A、 The command generates an error.
• B、 The command backs up the tablespace and creates a backup set of size 200 MB
• C、 The command backs up the tablespace and creates two backup sets of size 100 MB each.
• D、 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

第4题：

Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）

• A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.
• B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
• C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
• D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

第5题：

View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

• A、 all the data files belonging to the USERS tablespace
• B、 password file
• C、 online redo log files
• D、 the current control file
• E、 archived redo log files
• F、 the current server parameter file
• G、 data files belonging to the USERS tablespace and all the default tablespaces

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)

• A、The backup piece size will be limited to 300 MB
• B、The RMAN uses multiplexing to perform backup
• C、The operation is accomplished using the default channel available
• D、The RMAN parallelizes the backup although the parallelism is not set for a channel

第14题：

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 NOARCHIVELOG mode and the tablespace is online.
• C、 The database is in NOARCHIVELOG mode and the tablespace is offline.
• D、 The database is in ARCHIVELOG mode and the tablespace is offline.
• E、 The database is in ARCHIVELOG mode and the tablespace is online.

第15题：

Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）

• A、alter tablespace DAVE_TBS backup mode
• B、alter tablespace DAVE_TBS start backup 
• C、alter tablespace DAVE_TBS begin backup 
• D、alter tablespace DAVE_TBS backup begin 
• E、alter tablespace DAVE_TBS backup

第16题：

You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）  

• A、 alter tablespace MY_DATA begin backup
• B、 alter tablespace MY_DATA start backup
• C、 alter tablespace MY_DATA backup begin
• D、 alter MY_DATA begin backup
• E、 You cannot back up individual tablespaces

第17题：

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

• A、The database will open, and the tablespace automatically comes out of the backup mode
• B、The database will be mounted, and recovery must be performed on the USERS tablespace.
• C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
• D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：