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

题目
单选题
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> BACKUP SECTION 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
解析: 暂无解析
更多“单选题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 comma”相关问题
  • 第1题:

    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

  • 第2题:

    You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()

    • A、 Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
    • B、 Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
    • C、 Use compression when performing tape backups
    • D、 Configure multiple SBT channels

    正确答案:B

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

    正确答案:B,C

  • 第4题:

    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.

    正确答案:A

  • 第5题:

    ou 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 channel 
    • D、intrafile parallel backup

    正确答案:D

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

    正确答案:C

  • 第7题:

    单选题
    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
    解析: 暂无解析

  • 第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>BACKUP SECTION SIZE 300M TABLESPACE users;   What configuration should be effected to accomplish faster and optimized backups by using the above command?()
    A

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

    B

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

    C

     The SBT channel must be configured, with the parallelism setting for the SBT device set to 3

    D

     The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB


    正确答案: C
    解析: 暂无解析

  • 第9题:

    单选题
    You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?()
    A

    The backup will terminate because the FORMAT clause was not configured for the channel

    B

    It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

    C

    It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

    D

    It backs up the data files and archived log files to tape, making two copies of each data file and archived log file


    正确答案: D
    解析: 暂无解析

  • 第10题:

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


    正确答案: B
    解析: 暂无解析

  • 第11题:

    多选题
    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,D
    解析: 暂无解析

  • 第12题:

    单选题
    You issued the following commands to configure setting in RMAN; RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?()
    A

    The backup will terminate because the FORMAT clause was not configured for the channel

    B

    It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

    C

    It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

    D

    It backs up the data files and archived log files to tape, making two copies of each data file and archived log file


    正确答案: A
    解析: 暂无解析

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

    正确答案:A,C

  • 第14题:

    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

  • 第15题:

    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

  • 第16题:

    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> BACKUP SECTION 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

  • 第17题:

    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>BACKUP SECTION SIZE 300M TABLESPACE users;   What configuration should be effected to accomplish faster and optimized backups by using the above command?()

    • A、 The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1
    • B、 The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0
    • C、 The SBT channel must be configured, with the parallelism setting for the SBT device set to 3
    • D、 The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB

    正确答案:D

  • 第18题:

    单选题
    You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()
    A

     Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE

    B

     Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE

    C

     Use compression when performing tape backups

    D

     Configure multiple SBT channels


    正确答案: C
    解析: 暂无解析

  • 第19题:

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


    正确答案: B
    解析: 暂无解析

  • 第20题:

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


    正确答案: A
    解析: 暂无解析

  • 第21题:

    单选题
    You are tuning RMAN to optimize performance.You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()
    A

    Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE

    B

    Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE

    C

    Use compression when performing tape backups

    D

    Configure multiple SBT channels


    正确答案: D
    解析: 暂无解析

  • 第22题:

    单选题
    ou 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 channel 

    D

    intrafile parallel backup


    正确答案: A
    解析: 暂无解析

  • 第23题:

    单选题
    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> BACKUP SECTION 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
    解析: 暂无解析

  • 第24题:

    单选题
    You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace 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 channel

    D

    intrafile parallel backup


    正确答案: D
    解析: 暂无解析