多选题The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）ABACKUP TABLESPACE SYSTEM SECTION SIZE 100M;BBACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;CBACKUP ARCHIVELOG ALL SECTION SIZE 25M;DBACKUP TABLESPACE TEMP SECTION SIZE 10M;EBACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;FBACKUP SPFILE SECTION SIZE 1M;GBACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
多选题
The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）
A
BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
B
BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
C
BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
D
BACKUP TABLESPACE TEMP SECTION SIZE 10M;
E
BACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
F
BACKUP SPFILE SECTION SIZE 1M;
G
BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
参考解析
解析：
暂无解析
相关考题：
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.() A. Backup retention policyB. Default backup device typeC. Default destinations for backupsD. Multiple backup device types for single backupE. Default section size for backups
Which option is best practice for creating a recovery catalog owner in the catalog database?() A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userC. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the userD. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
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
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.() (Choose all that apply.) A. Backup retention policyB. Default backup device typeC. Default destinations for backupsD. Multiple backup device types for single backupE. Default section size for backups
The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi－section backup.() A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;D. BACKUP TABLESPACE TEMP SECTION SIZE 10M;E. BACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;F. BACKUP SPFILE SECTION SIZE 1M;G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly. On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLS tablespace， you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting？（）A、configure a default device for RMAN backupsB、temporarily disable the retention policy for RMAN backupsC、configure automatic channel allocation for RMAN backupsD、use the CONFIGURE command to reconfigure the recovery window to 60 days
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）A、Backup retention policyB、Default backup device typeC、Default destinations for backupsD、Multiple backup device types for single backupE、Default section size for backups
Identify the three predefined server-generated alerts.（）A、Drop UserB、Tablespace Space UsageC、Resumable Session SuspendedD、Recovery Area Low On Free SpaceE、SYSTEM Tablespace Size Increment
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 ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）A、SYSDBAB、SYSOPERC、No system privileges are required for the RMAN user.D、Only SYS user can connect and execute RMAN commands on a target database.
The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）A、BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;B、BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;C、BACKUP ARCHIVELOG ALL SECTION SIZE 25M;D、BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;E、BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;F、BACKUP SPFILE SECTION SIZE 1M;G、BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
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 are creating a recovery catalog for use with RMAN. You have issued these commands： SQL CREATE TABLESPACE rman_ts DATAFILE ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts； Which command should you issue next？（）A、RESYNC CATALOG；B、REGISTER DATABASE；C、CREATE CATALOG TABLESPACE rman_ts；D、GRANT recovery_catalog_owner TO rman_db01；
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 MBC、 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.
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A、The tablespace TBS1 is full.B、The user is not the owner of the SYSTEM tablespace.C、The user does not have quota on the TBS1 tablespace.D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.E、The user does not have sufficient privileges to create table on the default permanent tablespace.
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（） (Choose all that apply.)A、Backup retention policyB、Default backup device typeC、Default destinations for backupsD、Multiple backup device types for single backupE、Default section size for backups
Which option is best practice for creating a recovery catalog owner in the catalog database？（） A、 Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB、 Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userC、 Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the userD、 Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）A、the CREATE TABLE .. commandB、sorting of the SYSTEM tablespace’s dataC、sorting of data required by recursive SQL statementsD、the CREATE TABLE .. ORGANIZATION EXTERNAL .. commandE、sorting of data if the users have not been allocated temporary tablespace explicitlyF、sorting of data if the users have been allocated temporary tablespace explicitly
You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）A、All the extents will be of the same size.B、Bitmap will be used to record free and allocated extents.C、Free extents will be managed by the data dictionary tables.D、The tablespace will be system managed and the users cannot specify the extent size.
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 specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）AAll the extents will be of the same size.BBitmap will be used to record free and allocated extents.CFree extents will be managed by the data dictionary tables.DThe tablespace will be system managed and the users cannot specify the extent size.
多选题Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）ABackup retention policyBDefault backup device typeCDefault destinations for backupsDMultiple backup device types for single backupEDefault section size for backups
多选题Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（） (Choose all that apply.)ABackup retention policyBDefault backup device typeCDefault destinations for backupsDMultiple backup device types for single backupEDefault section size for backups
单选题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
多选题The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）ABACKUP TABLESPACE SYSTEM SECTION SIZE 100M;BBACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;CBACKUP ARCHIVELOG ALL SECTION SIZE 25M;DBACKUP TABLESPACE TEMP SECTION SIZE 10M;EBACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;FBACKUP SPFILE SECTION SIZE 1M;GBACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
多选题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 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
单选题Which RMAN command is used to verify the status of a backup or copy， and also updates the repository when files have been deleted using operating system commands？（）ACHANGEBRESYNCCCATALOGDCROSSCHECK