违法和不良信息举报 联系客服
免费注册 登录

单选题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 instanc

题目
单选题
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.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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

正确答案:C

第2题：

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

正确答案:A,B,D

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


参考答案：A, C

第4题：

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.

正确答案:B,C

第5题：

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

正确答案:A,C

第6题：

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 te minate 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.

正确答案:C

第7题：

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.

正确答案:D

第8题：

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 be the reason for this error（）

  • A、The MTTR Advisor is disabled.
  • B、The database is in NOARCHIVELOG mode.
  • C、The tablespace is already in backup mode.
  • D、The Flash Recovery Area is not configured.

正确答案:B

第9题：

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

正确答案:C

第10题：

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

正确答案:C

更多相关问题
相关内容