单选题Which statement about using RMAN stored scripts is true?()A To create and execute an RMAN stored script,you must use a recovery catalog.B When executing a stored script and a command fails,the remainder of the script is executed,and a message is written to the alert log file.C RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D When you execute a stored script,it always executes using the persistent channel settings previously set with the CONFIGURE command.

单选题
Which statement about using RMAN stored scripts is true?()
A

 To create and execute an RMAN stored script,you must use a recovery catalog.

B

 When executing a stored script and a command fails,the remainder of the script is executed,and a message is written to the alert log file.

C

 RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.

D

 When you execute a stored script,it always executes using the persistent channel settings previously set with the CONFIGURE command.


参考解析

解析: 暂无解析

相关考题:

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

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?() A. Stored scripts in the recovery catalogB. Backups that can be deleted from diskC. Backup sets and images copies that are obsoleteD. Backups that do not have the AVAILABLE status in the RMAN repository

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?() A. stored scripts in the recovery catalogB. backups that can be deleted from diskC. backup sets and image copies are obsoleteD. backups that do not have the AVAILABLE status in the RMAN repository RMAN

Which two statements about the SQL Management Base (SMB) are true?() A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It is part of the data dictionary and stored in the SYSTEM tablespace.E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

Which statement is true regarding virtual private catalogs?() A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.B. The virtual private catalog owner cannot create and modify the stored scripts.C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?() (Choose two.) A. stored scripts in the recovery catalog.B. backups that can be deleted from disk.C. backup sets and image copies are obsolete.D. backups that do not have the AVAILABLE status in the RMAN repository.

Which statement is true about the routing table?()A、The routing table exists in the control plane onlyB、The routing table exists in the control plane and the forwarding planeC、The routing table contains both active and inactive routesD、The routing table is stored on compact flash

Which statement is true about the forwarding table?()A、The forwarding table is stored in the control plane only.B、The forwarding table is stored in the control plane and in the forwarding plane.C、The forwarding table contains both active and inactive routes.D、The forwarding table can contain only a single next hop per destination.

Which statement is true about the forwarding table?()A、The forwarding table is stored in the control plane onlyB、The forwarding table is stored in the control plane and in the forewarding planeC、The forwarding table contains both active and inactive routesD、The forwarding table can contain only sigle next hop per destination

Which statement is true regarding RMAN components?()A、Each target database requires its own recover catalog. B、RMAN scripts can be stored in the recovery catalog or the target control file. C、A channel is a stream of data to a device type and corresponds to one server session. D、The RMAN executable interprets sever session commands and establishes connections to the target database.

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?()A、stored scripts in the recovery catalogB、backups that can be deleted from diskC、backup sets and image copies are obsoleteD、backups that do not have the AVAILABLE status in the RMAN repository RMAN

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed?()A、Stored scripts in the recovery catalogB、Backups that can be deleted from diskC、Backup sets and images copies that are obsoleteD、Backups that do not have the AVAILABLE status in the RMAN repository

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system (OS) file.D、It is a Recovery Manager (RMAN) script

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?()A、Stored scripts in the recovery catalogB、Backups that can be deleted from diskC、Backup sets and images copies that are obsoleteD、Backups that do not have the AVAILABLE status in the RMAN repository

You perform a backup using the following BACKUP command:   RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE;   Which statement is true of this command?()  A、 A different procedure is required to restore a database from compressed backupsB、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.C、 Using this command to create backups minimizes the bandwidth consumedD、 Using this command to create backups improves the performance of the backup process

Which statement about using RMAN stored scripts is true?()A、To create and execute an RMAN stored script, you must use a recovery catalog.B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

多选题Which two statements about the SQL Management Base (SMB) are true?()AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.

单选题Which statement is true regarding RMAN components?()AEach target database requires its own recover catalog. BRMAN scripts can be stored in the recovery catalog or the target control file. CA channel is a stream of data to a device type and corresponds to one server session. DThe RMAN executable interprets sever session commands and establishes connections to the target database.

单选题Which statement is true about the forwarding table?()AThe forwarding table is stored in the control plane onlyBThe forwarding table is stored in the control plane and in the forewarding planeCThe forwarding table contains both active and inactive routesDThe forwarding table can contain only sigle next hop per destination

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

多选题Which two statements about the SQL Management Base (SMB) are true? ()(Choose two.)AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.

单选题Which of the following files cannot be cataloged using the CATALOG command?()AData filesBControl filesCArchived log filesDFiles storing RMAN scripts

单选题You perform a backup using the following BACKUP command:   RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE;   Which statement is true of this command?()A A different procedure is required to restore a database from compressed backupsB The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.C Using this command to create backups minimizes the bandwidth consumedD Using this command to create backups improves the performance of the backup process

单选题Which statement about using RMAN stored scripts is true?()ATo create and execute an RMAN stored script, you must use a recovery catalog.BWhen executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.CRMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.DWhen you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

单选题Which script must you to query to display the code associated with RMAN stored scripts?()ARC_STORED_SCRIPTBRC_STORED_SCRIPT_LINECRC_SCRIPTSDRC_STORED_LINE_SCRIPTENone of the other alternatives apply

单选题You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()AIt is a SQL script.BIt is a PL/SQL file.CIt is an operating system (OS) file.DIt is a Recovery Manager (RMAN) script

单选题Which statement is true regarding virtual private catalogs?()A A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.B The virtual private catalog owner cannot create and modify the stored scripts.C The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.D To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.