网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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” 相关考题
考题
——() ? —— I want to buy a pair of shoes.
A. What are you doing?B. What can I do for you?C. How can I help you?D. How can I do for you?
考题
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 BACKUPSECTION 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
考题
“你们可以按我指定的时间把礼物送到吗?” 翻译错误的是( )。A.Can you deliver my present the time I want?B.Can you deliver my present at time I want?C.Can you deliver present at the time I want?D.Can you deliver my present at the time I want?
考题
You are analyzing the performance of a SQL Azure database. You need to recommend an approach for identifying the indexes that should be added to improve database performance. What should you recommend?()A、 Use SQL Server Profiler to identify missing indexes.B、 Use the Database Engine Tuning Advisor to identify missing indexes.C、 Use a Dynamic Management View to analyze query plans.D、 Use a DynamicManagement View to ascertain the number of pending I/O requests.
考题
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 are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
考题
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 have configured the flash recovery area to store online redo log files, control files, archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it?()A、 multiplexed control filesB、 RMAN obsolete backupsC、 multiplexed online redo log filesD、 archived redo logs that have not been copied to tape
考题
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 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
考题
单选题—Lily, what are you going to do after you graduate?—I’m thinking of becoming a computer programmer.—_____—Well, my parents want me to be a doctor, but I don’t want to do that.A
Do you know what I want to become?B
Why do you want to be a doctor?C
You said you would go to a medical school.D
Thanks for your advice.
考题
多选题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
考题
单选题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 are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()A
SQL Tuning AdvisorB
Undo AdvisorC
ADDMD
Memory Advisor
考题
多选题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?()AThe RMAN parallelizes the backup although the parallelism is not set for a channel.BThe backup piece size will be limited to 300 MB.CThe operation is accomplished using the default channel available.DThree channels for the tape drive must be configured by setting the parallelism to three.
考题
多选题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.)AThe backup piece size will be limited to 300 MBBThe RMAN uses multiplexing to perform backupCThe operation is accomplished using the default channel availableDThe RMAN parallelizes the backup although the parallelism is not set for a channel
考题
单选题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 have configured the flash recovery area to store online redo log files, control files, archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it?()A
multiplexed control filesB
RMAN obsolete backupsC
multiplexed online redo log filesD
archived redo logs that have not been copied to tape
考题
单选题()? -I am your agent. I want to see the captain.A
What are you?B
What can I do for you?C
Where are you from?D
What are you doing?
考题
单选题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
考题
单选题Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?()A
Database replayB
SQL Tuning AdvisorC
SQL Access AdvisorD
SQL Performance AnalyzerE
Automatic Workload Repository compare reports
考题
单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()A
use the external table populationB
use the Oracle Data Pump export and import utilityC
use the conventional path data load of SQL*Loader utilityD
use the direct path data load of Oracle export and import utility
考题
单选题You work as a database administrator for Supportcenter.cn. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective?()A
Save the baseline in the databaseB
Save the baseline in the Database Control Home PageC
Create a procedure to read and apply the baseline to disk I/O metricsD
Apply the baseline to the disk I/O metrics in the Mange Metrics pageE
Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd
考题
单选题You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance. What action must you take to achieve this?()A
Run Segment AdvisorB
Run the SQL Tuning Advisor (STA)C
Run the Automatic Workload Repository (AWR) reportD
Run the SQL Access Advisor with a hypothetical workload
热门标签
最新试卷