单选题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？（）Acreate baseline metrics for today’s performanceBwrite the current database metrics to a database table and create a trigger to compare with future database statisticsCwrite the current database metrics to a flat file and create an operating script to compare with future database statisticsDwrite the current database metrics to a database table and create a procedure to compare with future database statisticsEwrite the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
单选题
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？（）
A
create baseline metrics for today’s performance
B
write the current database metrics to a database table and create a trigger to compare with future database statistics
C
write the current database metrics to a flat file and create an operating script to compare with future database statistics
D
write the current database metrics to a database table and create a procedure to compare with future database statistics
E
write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
参考解析
解析：
暂无解析
相关考题：
At today's Holiday Inn, you'll be sure to find a convenient location offering many features to make your stay more enjoyable.()
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 databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option
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 catalogB. Transporting the new tablespaces to the recovery catalog databaseC. Syncronizing the recovery catalog with the target database control fileD. Performing a fresh backup of the target database to include the new data files in the catalog database
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?() A. Compare Period ADDM reportB. AWR Compare Period reportC. Active Session History (ASH) reportD. Taking a new snapshot and comparing it with a preserved snapshot
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 AdvisorsB、Segment AdvisorsC、SQL Tuning and Access AdvisorsD、Automated Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）
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 bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
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 utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature
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 parameterB、the value of the optimal redo log file size provided by the Redo Logfile Size AdvisorC、the online redo log files sizeD、the number of redo log members in a group
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 databaseB、Open the database in NORMAL modeC、Open the database in RESTRICTED modeD、Open the database with the RESETLOGS option
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 viewB、the V$DBFILE viewC、the V$LOGFILE viewD、the V$INSTANCE_RECOVERY viewE、Oracle Enterprise Manager Database Control
You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（） A、Memory AdvisorB、Segment AdvisorC、SQL Access AdvisorD、Automatic Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）
You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）A、It detects any configuration change that caused a performance difference in both time periods.B、It identifies any workload change that caused a performance difference in both time periods.C、It detects the top wait events causing performance degradation.D、It shows the resource usage for CPU, memory, and I/O in both time periods.E、It shows the difference in the size of memory pools in both time periods.F、It gives information about statistics collection in both time periods.
单选题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？（）Athe value of the UNDO_RETENTION initialization parameterBthe value of the optimal redo log file size provided by the Redo Logfile Size AdvisorCthe online redo log files sizeDthe number of redo log members in a group
单选题You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）ACompare Period ADDM reportBAWR Compare Period reportCActive Session History (ASH) reportDTaking a new snapshot and comparing it with a preserved snapshot
单选题You work as a database administrator for Certkiller .com. 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？（）AMemory AdvisorsBSegment AdvisorsCSQL Tuning and Access AdvisorsDAutomated Workload Repository （AWR）EAutomatic Database Diagnostic Monitor （ADDM）
多选题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.)AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database
单选题You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）Arun Segment AdvisorBrun SQL Tuning Advisor on top SQL statementsCrun the Automatic Workload Repository （AWR） reportDrun the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
多选题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？（）Aincrease the size of the redo log bufferBincrease the number of redo log groupsCincrease the number of log writer processesDincrease the number of ARCn processesEchange the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
单选题You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）AEnable Memory Access Mode, which reads performance data from SGA.BUse emergency monitoring to fetch data directly from SGA analysis.CRun Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.DUse Active Session History (ASH) data and hang analysis in regular performance monitoring.ERun ADDM in diagnostic mode.
单选题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 utilityB by using the export/import utilityC by using the ALTER DATABASE commandD by enabling the change tracking feature
单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）AOpen the database in NORMAL modeBOpen the database in read-only modeCOpen the database in RESTRICTED modeDOpen the database with the RESETLOGS option
单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）AMemory AdvisorBSegment AdvisorCSQL Access AdvisorDAutomatic Workload Repository （AWR）EAutomatic Database Diagnostic Monitor （ADDM）
多选题You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）AIt detects any configuration change that caused a performance difference in both time periods.BIt identifies any workload change that caused a performance difference in both time periods.CIt detects the top wait events causing performance degradation.DIt shows the resource usage for CPU, memory, and I/O in both time periods.EIt shows the difference in the size of memory pools in both time periods.FIt gives information about statistics collection in both time periods.
单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）A Memory AdvisorB Segment AdvisorC SQL Access AdvisorD Automatic Workload Repository （AWR）E Automatic Database Diagnostic Monitor （ADDM）
多选题You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production 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 you want them to be included in backups. Identify two options for completing this task.（）AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database
多选题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？（）Athe V$LOG viewBthe V$DBFILE viewCthe V$LOGFILE viewDthe V$INSTANCE_RECOVERY viewEOracle Enterprise Manager Database Control