网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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 channels
参考答案
更多 “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 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 fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery
考题
You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）A、 LogMinerB、 The DBNEWID utilityC、 The DBVERIFY utilityD、 The ANALYZE commandE、 The RMAN REPORT commandF、 The RMAN CROSSCHECK command.G、 The RMAN BLOCKRECOVER command.
考题
Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
考题
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 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 fileB、You must have first level 1 backups for RMAN to restore blocksC、You must ensure that the SALES database is mounted or openD、You must have full or level 0 backups for RMAN to restore blocksE、You must take the tools01.dbf data file offline before you start a block media recovery
考题
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block
考题
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
考题
You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）A、 rman TARGET / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
考题
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_REPOSITORYB、 DBMS_RESOURCE_MANAGERC、 DBMS_SQLTUNED、 DBMS_ADVISOR
考题
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database
考题
You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？ （）A、Top SQLB、snapshotsC、SQL Tuning setsD、index access pathE、optimizer statisticsF、materialized view logs
考题
单选题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_REPOSITORYB
DBMS_RESOURCE_MANAGERC
DBMS_SQLTUNED
DBMS_ADVISOR
考题
单选题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 use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？ （）ATop SQLBsnapshotsCSQL Tuning setsDindex access pathEoptimizer statisticsFmaterialized view logs
考题
单选题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
考题
单选题You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）A
rman TARGET / NOCATALOGB
rman TARGET sys/passwordC
rman TARGET sys/password AS SYSDBAD
rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
考题
单选题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
考题
单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）A
Segment AdvisorB
SQL Access AdvisorC
Undo AdvisorD
SQL Tuning Advisor
考题
单选题You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）A
LogMinerB
The DBNEWID utilityC
The DBVERIFY utilityD
The ANALYZE commandE
The RMAN REPORT commandF
The RMAN CROSSCHECK command.G
The RMAN BLOCKRECOVER command.
考题
单选题Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A
You need to perform the restore and recover operations manually, because the backup was made manually. B
First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C
First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D
You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
考题
单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A
back up the control file to traceB
bring database to the MOUNT stateC
open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD
set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
考题
单选题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 TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.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 TOOLStablespace， you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace 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
考题
单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）A
Segment AdvisorB
SQL Access AdvisorC
Undo AdvisorD
SQL Tuning Advisor
考题
单选题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；
考题
多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block
考题
单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）A
target databaseB
auxiliary databaseC
third-party databaseD
recovery catalog database
热门标签
最新试卷
