单选题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
参考解析
解析：
暂无解析
相关考题：
—____________________?—I want to be a scientist and it ‟s also my childhood dream. A. What ‟s your jobB. What ‟re you doingC. Are you a scientistD. What ‟s your dream for the future
－ ()－ Today’s rate is listed on the board here. A、What’s the exchange rate todayB、What kind of currency do you want to exchange forC、What’s the amount you’d like to exchange
You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）A、The baseline， once created， cannot be removed.B、Disable the baseline metrics in the Database Control Manage Metrics page.C、The baseline will be automatically removed once the database performance has been optimized.D、Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
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 performanceB、write the current database metrics to a database table and create a trigger to compare with future database statisticsC、write the current database metrics to a flat file and create an operating script to compare with future database statisticsD、write the current database metrics to a database table and create a procedure to compare with future database statisticsE、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A、The database performance would be enhanced.B、The redo log files would be get filled more frequently.C、The overall database performance would be degraded.D、The mean time to recover （MTTR） would be increased.
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 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 work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）A、It degrades the run time and compiler performance.B、It provides better run time and compiler performance.C、It provides better optimization of the statement during parse time.D、It forces the rule based optimizer to be used for statement optimization.E、It provides better run time performance but slightly degraded compiler performance. F、It provides better run time performance but slightly degraded run time performance.
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
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 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
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 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？（）A、run Segment AdvisorB、run SQL Tuning Advisor on top SQL statementsC、run the Automatic Workload Repository （AWR） reportD、run 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
单选题In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）Aexport and import the mapping tableBdrop and re-create the mapping tableCtruncate the mapping table and reinsert the valuesDuse the ALTER TABLE···REBUILD command to defragment the mapping table
单选题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
单选题You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）AUse the CREATE DATABASE .. command to create the database with Oracle-managed files. BUse the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. CUse Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. DUse Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. EUse the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
单选题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 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
单选题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?（）ADatabase replayBSQL Tuning AdvisorCSQL Access AdvisorDSQL Performance AnalyzerEAutomatic 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？（）Ause the external table populationBuse the Oracle Data Pump export and import utilityCuse the conventional path data load of SQL*Loader utilityDuse 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？（）ASave the baseline in the databaseBSave the baseline in the Database Control Home PageCCreate a procedure to read and apply the baseline to disk I/O metricsDApply the baseline to the disk I/O metrics in the Mange Metrics pageEAlter 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
单选题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 Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）AIt degrades the run time and compiler performance.BIt provides better run time and compiler performance.CIt provides better optimization of the statement during parse time.DIt forces the rule based optimizer to be used for statement optimization.EIt provides better run time performance but slightly degraded compiler performance. FIt provides better run time performance but slightly degraded run time performance.
单选题You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）AThe baseline， once created， cannot be removed.BDisable the baseline metrics in the Database Control Manage Metrics page.CThe baseline will be automatically removed once the database performance has been optimized.DDrop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
单选题You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）AThe database performance would be enhanced.BThe redo log files would be get filled more frequently.CThe overall database performance would be degraded.DThe mean time to recover （MTTR） would be increased.