多选题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?()AThe RMAN parallelizes the backup although the parallelism is not set for a channel.BThe backup piece size will be limited to 300 MB.CThe operation is accomplished using the default channel available.DThree channels for the tape drive must be configured by setting the parallelism to three.
多选题
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.
参考解析
解析:
暂无解析
相关考题:
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
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
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
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
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.2B、 +DG2A/dev19/datafile/users02.701.2C、 +DG2A/dev19/users02/datafile.701.2D、 +DG2A·701.2E、 +DG2A/datafile/dev19.users.02.701.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 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel
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 backupB、 backup with MAXPIECESIZE configured for the channelC、 parallel backup with MAXPIECESIZE configured for the channeD、 intrafile parallel backup
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.
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 tablespacesB、backup of readonly tablespacesC、backup of systemcritical tablespacesD、backup of online, locally managed tablespacesE、backup of read/write dictionarymanaged tablespaces
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.
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
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.
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 utilityB、the ANALYZE commandC、the RMAN LIST commandD、the RMAN REPORT commandE、the RMAN CROSSCHECK commandF、the RMAN BLOCKRECOVER command
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
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.
单选题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 FALSEB Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC Use compression when performing tape backupsD Configure multiple SBT channels
多选题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?()ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager
单选题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?()Aparallel image copy backupBbackup with MAXPIECESIZE configured for the channelCparallel backup with MAXPIECESIZE configured for the channelDintrafile parallel backup
单选题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 backupB backup with MAXPIECESIZE configured for the channelC parallel backup with MAXPIECESIZE configured for the channeD intrafile parallel backup
多选题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.)AThe backup piece size will be limited to 300 MBBThe RMAN uses multiplexing to perform backupCThe operation is accomplished using the default channel availableDThe RMAN parallelizes the backup although the parallelism is not set for a channel
单选题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?()Athe DBNEWID utilityBthe ANALYZE commandCthe RMAN LIST commandDthe RMAN REPORT commandEthe RMAN CROSSCHECK commandFthe RMAN BLOCKRECOVER command
单选题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.
单选题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: RMANBACKUP 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 1B The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0C The SBT channel must be configured, with the parallelism setting for the SBT device set to 3D The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB
单选题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?()ASet the BACKUP_TAPE_IO_SLAVES parameter to FALSEBSet the BACKUP_TAPE_IO_SLAVES parameter to TRUECUse compression when performing tape backupsDConfigure multiple SBT channels
单选题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.2B +DG2A/dev19/datafile/users02.701.2C +DG2A/dev19/users02/datafile.701.2D +DG2A·701.2E +DG2A/datafile/dev19.users.02.701.2
单选题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?()Aparallel image copy backup Bbackup with MAXPIECESIZE configured for the channel Cparallel backup with MAXPIECESIZE configured for the channel Dintrafile parallel backup
单选题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.