CMS专题
单选题You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）
题目
create baseline metrics for today’s performance
write the current database metrics to a database table and create a trigger to compare with future database statistics
write the current database metrics to a flat file and create an operating script to compare with future database statistics
write the current database metrics to a database table and create a procedure to compare with future database statistics
write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
相似问题和答案
第1题：
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)
A. Reregistering the target database in recovery catalog
B. Transporting the new tablespaces to the recovery catalog database
C. Syncronizing the recovery catalog with the target database control file
D. Performing a fresh backup of the target database to include the new data files in the catalog database
第2题：
You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
- A、Memory Advisors
- B、Segment Advisors
- C、SQL Tuning and Access Advisors
- D、Automated Workload Repository （AWR）
- E、Automatic Database Diagnostic Monitor （ADDM）
正确答案:C
第3题：
At today's Holiday Inn, you'll be sure to find a convenient location offering many features to make your stay more enjoyable.()
第4题：
You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）
- A、Mount the database
- B、Open the database in NORMAL mode
- C、Open the database in RESTRICTED mode
- D、Open the database with the RESETLOGS option
正确答案:A
第5题：
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）
- A、 by using the RMAN utility
- B、 by using the export/import utility
- C、 by using the ALTER DATABASE command
- D、 by enabling the change tracking feature
正确答案:C
第6题：
A. Compare Period ADDM report
B. AWR Compare Period report
C. Active Session History (ASH) report
D. Taking a new snapshot and comparing it with a preserved snapshot
第7题：
In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server？（）
- A、increase the size of the redo log buffer
- B、increase the number of redo log groups
- C、increase the number of log writer processes
- D、increase the number of ARCn processes
- E、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
正确答案:B,E
第8题：
You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）
A. Mount the database
B. Open the database in NORMAL mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option
第9题：
You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）
- A、the value of the UNDO_RETENTION initialization parameter
- B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
- C、the online redo log files size
- D、the number of redo log members in a group
正确答案:C
第10题：
In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
- A、the V$LOG view
- B、the V$DBFILE view
- C、the V$LOGFILE view
- D、the V$INSTANCE_RECOVERY view
- E、Oracle Enterprise Manager Database Control
正确答案:D,E