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？（）

You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）

A . DBMS_WORKLOAD_REPOSITORY B . DBMS_RESOURCE_MANAGER C . DBMS_SQLTUNE D . DBMS_ADVISOR

查看最佳答案

When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）

A . RMAN keeps a list of archive logs in a text file. B . The DBA must manually tell RMAN which archive logs to backup. C . RMAN has access to target control file and/or catalog information. D . RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

查看最佳答案

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 channel

查看最佳答案

You issued the following RMAN command to back up the database: https://assets.asklib.com/images/image2/2018080209472183076.jpg Which two statements are true regarding the backup performed?（）

A . Archived redo log files are backed up along with data files. B . Only data files are backed up and a restore point named FY06Q4 is created. C . Archived log files are backed up along with data files, and the archived log files are deleted. D . The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

查看最佳答案

What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?（）

A . CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA B . CONFIGURE DEFAULT DEVICE TYPE TO TAPE C . CONFIGURE DEFAULT DEVICE TYPE TO SBT D . CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE

查看最佳答案

You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

A . Every SQL statement in the STS is considered only once for execution. B . The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics. C . The execution plan and execution statistics are computed for each SQL statement in the STS. D . The effects of DDL and DML are considered to produce the execution plan and execution statistics.

查看最佳答案

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

A . To store the backup information of multiple database B . To restrict the amount of space that is used by the backups C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter. D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

查看最佳答案

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）

A . Database Datafiles B . Database Control Files C . Online redo logs D . Archived redo logs E . The database SPFILE F . None of the above，all these files are backed u

查看最佳答案

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

A . online redo log files B . alert log files C . control file D . datafiles associated with the SYSTEM tablespace

查看最佳答案

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

A . Database Datafiles B . Database Control Files C . Online redo logs D . Archived redo logs E . The database SPFILE F . None of the above, all these files are backed up.&e

查看最佳答案

You are managing an Oracle Database 11g database. The database is open， and you plan to performRecovery Manager （RMAN） backups. Which three statements are true about these backups（）

A . The backups would be consistent. B . The backups would be inconsistent. C . The backups would be possible only if the database is running in ARCHIVELOG mode. D . The backups would be possible only if the database is running in NOARCHIVELOG mode. E . The backups need to be restored and the database has to be recovered in case of a media failure.

查看最佳答案

You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）

A . The backups would be consistent. B . The backups would be inconsistent. C . The backups would be possible only if the database is running in ARCHIVELOG mode. D . The backups would be possible only if the database is running in NOARCHIVELOG mode. E . The backups need to be restored and the database has to be recovered in case of a media failure

查看最佳答案

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)

A . To store the backup information of multiple database B . To restrict the amount of space that is used by the backups C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter. D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

查看最佳答案

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

查看最佳答案

You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）

A . You are backing up to tape and your tape device performs its own compression. B . You are making image copies, and you have not enabled tablespace compression. C . You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited. D . You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage. E . You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.

查看最佳答案

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）

A . A backup of the target database when it is mounted B . A backup of online redo log files when the database is open C . A backup of only used data blocks in the file beingbeingbackup up D . A backup of online， read/write data files when the database is open E . A backup of only those data blocks that have changed since a previous backup F . A backup of online， read/write data files when the database is in the NOMOUNT state.

查看最佳答案

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.

查看最佳答案

View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS； Which three types of files are backed up？（）

A . all the data files belonging to the USERS tablespace B . password file C . online redo log files D . the current control file E . archived redo log files F . the current server parameter file G . data files belonging to the USERS tablespace and all the default tablespace

查看最佳答案

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation？（）

A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

查看最佳答案

What are the three steps you should take to tune a JDBC Connection pool in WebLogic from the initial settings in a production environment?（）

A . Ensure the maximum size is increased to an appropriate setting. B . Set the minimum and maximum size of the connection pool to the same value. C . Increase the statement cache size. D . Add more heap to the JVM. E . Add more nodes to the cluster.

查看最佳答案

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

查看最佳答案

You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2； Which components are included in the backup？（）

A . Only the data files. B . Only the data files and the online logs. C . The data files， control files， and the online logs. D . The data files and control files， but not the online logs.

查看最佳答案

You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

A . UNTIL CANCEL B . UNTIL SCN C . UNTIL SEQUENCE D . UNTIL TIME

查看最佳答案

You are using Recovery Manager （RMAN) with a recovery catalog to back up your production d

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis.Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:1) Restore an autobackup of the server parameter file.2) Restore the control file3) Start the target database instance4) Mount the database5) Restore the data files6) Open the database with RESETLOGS option7) Recover the data files8) Set DBID for the target databaseWhich option illustrates the correct sequence that you must use？（） A.8，1，3，2，4，5，7，6 B.1，8，3，4，2，5，7，6 C.1，3，4，2，8，5，6，7 D.1，3，2，4，6，5，7，8

查看最佳答案

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？（）

相似题目

推荐题目