You want to take the backup of the USERS tablespace. It has

题目
多选题
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

参考答案和解析
正确答案: B,A
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

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

To reference existing ASM files, you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A, the database name is DEV19, and the ASM file that you want to reference is a datafile for the USERS02 tablespace.  Which of the following is a valid ASM filename for this ASM file?()

  • A、 dev19/+DG2A/datafile/users02.701.2
  • B、 +DG2A/dev19/datafile/users02.701.2
  • C、 +DG2A/dev19/users02/datafile.701.2
  • D、 +DG2A·701.2
  • E、 +DG2A/datafile/dev19.users.02.701.2

正确答案:B

第3题:

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?()

A. Backup compression should be enabled

B. Parallelism for the channel should be set to 2

C. All the files must be backed up as backup sets

D. The backup may be stored either on disk or on media with media manager


参考答案:D, E

第4题:

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

正确答案:A,B

第5题:

You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.  Which method would accomplish the task quickly and efficiently?()  

  • A、 parallel image copy backup
  • B、 backup with MAXPIECESIZE configured for the channel
  • C、 parallel backup with MAXPIECESIZE configured for the channe
  • D、 intrafile parallel backup

正确答案:D

第6题:

You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation?() 

  • A、 Backup compression should be enabled
  • B、 Parallelism for the channel should be set to 2
  • C、 All the files must be backed up as backup sets
  • D、 The backup may be stored either on disk or on media with media manager

正确答案:C,D

第7题:

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

第8题:

You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:RMAN> BACKUPSECTION SIZE 300M TABLESPACE users;Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()

A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.

B. The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.

C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.

D. The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1


参考答案:B

第9题:

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.

正确答案:A,B

第10题:

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.

正确答案:C

更多相关问题