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

第1题：

第2题：

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）

• A、Backup retention policy
• B、Default backup device type
• C、Default destinations for backups
• D、Multiple backup device types for single backup
• E、Default section size for backups

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

第4题：

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;

第5题：

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；

第6题：

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.

第7题：

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 owner
• B、 Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
• C、 Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the user
• D、 Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

第8题：

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.

第9题：

第10题：

第11题：

第12题：

第13题：

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 backups
• B、temporarily disable the retention policy for RMAN backups
• C、configure automatic channel allocation for RMAN backups
• D、use the CONFIGURE command to reconfigure the recovery window to 60 days

第14题：

Identify the three predefined server-generated alerts.（）

• A、Drop User
• B、Tablespace Space Usage
• C、Resumable Session Suspended
• D、Recovery Area Low On Free Space
• E、SYSTEM Tablespace Size Increment

第15题：

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、SYSDBA
• B、SYSOPER
• C、No system privileges are required for the RMAN user.
• D、Only SYS user can connect and execute RMAN commands on a target database.

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

第17题：

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.

第18题：

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 policy
• B、Default backup device type
• C、Default destinations for backups
• D、Multiple backup device types for single backup
• E、Default section size for backups

第19题：

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 .. command
• B、sorting of the SYSTEM tablespace’s data
• C、sorting of data required by recursive SQL statements
• D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
• E、sorting of data if the users have not been allocated temporary tablespace explicitly
• F、sorting of data if the users have been allocated temporary tablespace explicitly

第20题：

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

第21题：

第22题：

第23题：

第24题：