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 inst

第1题：

Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

• A、 redo logs
• B、 control file
• C、 temporary files of temporary tablespace
• D、 the latest backup of only the damaged data file
• E、 the latest backup of all the data files In the USERS tablespace

第2题：

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

第3题：

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 the RMAN. To accomplish the backup， you issued the following RMAN command：   RMAN> BACKUP SECTION SIZE 300M TABLESPACE users；   Which two statements are true regarding the execution of the above command？（）

• A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.
• B、 The backup piece size will be limited to 300 MB.
• C、 The operation is accomplished using the default channel available.
• D、 Three channels for the tape drive must be configured by setting the parallelism to three.

第4题：

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.

第5题：

The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task, you issued the following command: SQL> ALTER TABLESPACE hi_data BEGIN BACKUP; Which two statements are true in this scenario? （）

• A、No transaction on the tablespace is allowed but you can perform queries.
• B、The tablespace will automatically come out of backup mode when the file copy is complete.
• C、The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
• D、The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.

第6题：

In which of the following scenarios is a tablespace recovery required？（）

• A、 when recovering a lost read-only tablespace from a read-only tablespace backup
• B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode
• C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
• D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

第7题：

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.

第8题：

第9题：

第10题：

第11题：

第12题：

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.

第13题：

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

第14题：

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

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

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.

第17题：

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

第18题：

第19题：

第20题：

第21题：

第22题：