网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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” 相关考题
考题
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
A. The tape I/O performed is asynchronousB. The tape buffer is allocated from the System Global Area (SGA)C. The tape buffer is allocated from the Program Global Area (PGA)D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
考题
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 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
考题
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（） A、 The tape I/O performed is asynchronousB、 The tape buffer is allocated from the System Global Area （SGA）C、 The tape buffer is allocated from the Program Global Area （PGA）D、 Oracle I/O uses an interrupt mechanism to determine when each I/O completes
考题
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 work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A、The advisory memory has been turned off.B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
考题
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）A、Set the UNDO_RETENTION parameter to AUTO.B、Create an initial undo segment in undotablespace.C、Set the UNDO_RETENTION parameter to 900 or moreD、Set the initialization parameter UNDO_MANAGEMENT to AUTOE、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
考题
You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A、The advisory memory has been turned off.B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
考题
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 work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）A、Set the UNDO_RETENTION parameter to AUTO.B、Create an initial undo segment in undotablespace.C、Set the UNDO_RETENTION parameter to 900 or moreD、Set the initialization parameter UNDO_MANAGEMENT to AUTOE、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
考题
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）A、Set MEMORY_TARGET to zeroB、Set the STATISTICS_LEVEL parameter to BASICC、Set the WORKAREA_SIZE_POLICY parameter to MANUALD、Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
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; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）A、The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.B、The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.C、The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.D、The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
考题
You work as a database administrator for Certkiller .com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？ （）A、Assign the DEFAULT profile to the usersB、Set the RESOURCE_LIMIT parameter to TRUE in the parameter fileC、Create a new profile with CPU restrictions and assign it to the usersD、Specify the users as members of the DEFAULT_CONSUMER_GROUPE、Revoke the DBA role and grant CONNECT and RESOURCE role to the users
考题
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 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 check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）A、 Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUEB、 Use the ANALYZE utility.C、 Use the DBVERIFY utility.D、 Use the DBMS_REPAIR package.
考题
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）A、Use the Database Resource Manager.B、Set the limits in the profiles used by users.C、Modify the SESSIONS initialization parameter.D、Set the warning threshold for the Current Logons Count metric.
考题
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 want to perform a backup of your database to tape. Which backup format can you use？（）A、backup set onlyB、image copy onlyC、only user-managed backupD、both image copy and backup setE、only incremental image copy backup
考题
单选题You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A
The advisory memory has been turned off.B
The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C
The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D
The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E
The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
考题
单选题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 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 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 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 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; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）A
The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.B
The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.C
The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.D
The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
考题
单选题You want to perform a backup of your database to tape. Which backup format can you use？（）A
backup set onlyB
image copy onlyC
only user-managed backupD
both image copy and backup setE
only incremental image copy backup
考题
单选题You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）A
Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUEB
Use the ANALYZE utility.C
Use the DBVERIFY utility.D
Use the DBMS_REPAIR package.
热门标签
最新试卷
