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

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

相似考题

1.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 enabledB. Parallelism for the channel should be set to 2C. All the files must be backed up as backup setsD. The backup may be stored either on disk or on media with media manager

2. 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

3.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 enabledB、 Parallelism for the channel should be set to 2C、 All the files must be backed up as backup setsD、 The backup may be stored either on disk or on media with media manager

4.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

更多“You want to take the backup of the USERS tablespace. It has ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  

    • A、 Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.
    • B、 Just back up the database datafiles without shutting down the database.
    • C、 You will have to wait until you can shut down the database to perform the backup.
    • D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
    • E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

    正确答案:C

  • 第5题：

    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（） 

    • A、the DBNEWID utility
    • B、the ANALYZE command
    • C、the RMAN LIST command
    • D、the RMAN REPORT command
    • E、the RMAN CROSSCHECK command
    • F、the RMAN BLOCKRECOVER command

    正确答案:B

  • 第6题：

    You are the administrator of a Windows 2000 Professional computer. A user named Maria assists you in performing some administrative tasks. Maria is a member of local Administrators group. Users report that Maria has been viewing and changing their files.  You want Maria to be able to install programs, perform backups and manage printers, but not to view, change or read other users’ files for which permission has not been granted. You want to set up Maria’s account to have minimal rights and permission. You want to accomplish this with least amount of administrative effort.  What should you do?  （）

    • A、 Leave Maria in the local Administrators group.  Limit her rights by using Local Policies.
    • B、 Leave Maria in the local Administrators group. Change the NTFS provision on other users’ files to deny Maria’s request.
    • C、 Remove Maria from the local Administrators group. Add her to both the Power Users group and Backup Operators group.
    • D、 Remove Maria from local Administrators group.  Add her to Power User group.  Then grant her NTFS Read permission on the files to be backed up.

    正确答案:C

  • 第7题：

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


    正确答案： A,D
    解析： 暂无解析

  • 第8题：

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

  • 第9题：

    单选题
    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
    A

    the DBNEWID utility

    B

    the ANALYZE command

    C

    the RMAN LIST command

    D

    the RMAN REPORT command

    E

    the RMAN CROSSCHECK command

    F

    the RMAN BLOCKRECOVER command


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

  • 第10题：

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

  • 第11题：

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


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

  • 第12题：

    单选题
    Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）
    A

     Restore all the datafiles from the backup.

    B

     Restore only the lost datafile from the backup.

    C

     Restore all the datafiles for the lost tablespace from the backup.

    D

     Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.


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

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

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    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

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


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

  • 第19题：

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


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

  • 第20题：

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


    正确答案： C,A
    解析： 暂无解析

  • 第21题：

    单选题
    You are the administrator of a Windows 2000 Professional computer. A user named Maria assists you in performing some administrative tasks. Maria is a member of local Administrators group. Users report that Maria has been viewing and changing their files.  You want Maria to be able to install programs, perform backups and manage printers, but not to view, change or read other users’ files for which permission has not been granted. You want to set up Maria’s account to have minimal rights and permission. You want to accomplish this with least amount of administrative effort.  What should you do?  （）
    A

     Leave Maria in the local Administrators group.  Limit her rights by using Local Policies.

    B

     Leave Maria in the local Administrators group. Change the NTFS provision on other users’ files to deny Maria’s request.

    C

     Remove Maria from the local Administrators group. Add her to both the Power Users group and Backup Operators group.

    D

     Remove Maria from local Administrators group.  Add her to Power User group.  Then grant her NTFS Read permission on the files to be backed up.


    正确答案： C
    解析： By adding Maria’s user account to the Power Users group Maria will inherit the ability to share resources and install programs that is conferred on members of the Power Users group. To grant Maria the ability to backup files she must be added to the Backup Operators group， which has the permissions to backup files. As a member of this group Maria will be able to backup files as she will inherit those rights by virtue of  being a member of that group. Maria will not have permissions to read the users’ files as she has been removed from the local administrators group and as neither the Power Users group nor the Backup Operators group has the permissions to read other users’ files.

  • 第22题：

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

  • 第23题：

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

相关内容