单选题The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）Aby using the SQL access advisorBby using the Automatic Workload Repository reportCby running the Automatic Database Diagnostic Monitor （ADDM）Dby using the Automatic Workload Repository Compare Period reportEby analyzing the output of the V$ACTIVE_SESSION_HISTORY view
单选题
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）
A
by using the SQL access advisor
B
by using the Automatic Workload Repository report
C
by running the Automatic Database Diagnostic Monitor （ADDM）
D
by using the Automatic Workload Repository Compare Period report
E
by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
参考解析
解析：
暂无解析
相关考题：
Which two statements about workload capture and replay operations are true?() A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
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
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.B. Run the Automatic Workload Repository Monitor (ADDM).C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
What is the purpose of configuring Workload Manager on a server used for development and QA？（） A、To experiment with shared processor poolsB、To isolate physical hardware between workloadsC、To control resource utilization on an application-by-application basisD、To leverage Workload Partition Manager for performance trending and analysis
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）A、by using the SQL access advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor （ADDM）D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent
Company.com has a database application and a Web server application running on the same p5-570 server in a single partition. Recently there have been a number of instances where the increased load on the database server has impacted the performance of the Web server. What can the technical specialist recommend to keep the database application from impacting the performance of the Web server？（）A、Create a VLAN between the web server and database server.B、Purchase APV and install the VIOS.C、Increase the priority of the Web server.D、Create separate LPARs for Web and database workloads.
An enterprise has three nodes： -Node ’A’ is a production database， -Node ’B’ is a production Application server， and -Node ’C’ is a test and development node. Node ’C’ is used by six programmers to develop and the production application as business critical and would like to make it highly available with HACMP. Application development and testing is not business critical. Which of the following describes the best solution？（） A、 There is not an adequate solution because HACMP should not be configured in this environment without a dedicated standby node.B、 Nodes ’A’ and ’B’ should be configured in a cluster with mutual fallover of two cascading resource groups to provide both nodes will deliver acceptable response time with both resource groups.C、 Nodes ’A’ and ’C’ should be configured in one cluster， and Nodes ’B’ and ’C’ in another cluster to prevent both the database and application server from falling over to Node ’C’ at the same time.D、 Nodes ’A’， ’B’， and ’C’ should be configured in a cluster with Node ’C’ the hot standby for both the database and application server resource groups. Workload Manager （WLM） must be configured on database and application developers from over utilizing the CPU resources.
A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）A、The application server，firewall，and database server on the same VLANB、The application server and firewall on one VLAN，and the database server on a second VLANC、The application server on one VLAN，and the database server and firewall on a second VLAND、The application server and firewall on one VLAN，and the firewall and database server on a second VLAN
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 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 a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.
单选题Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）AMaterialized views BIndexes CIndex-organized tables DHash clusters
单选题What is the purpose of configuring Workload Manager on a server used for development and QA?（）ATo experiment with shared processor poolsBTo isolate physical hardware between workloadsCTo control resource utilization on an application-by-application basisDTo leverage Workload Partition Manager for performance trending and analysis
多选题Which of these recommendations should be followed before capturing a workload？（）AMake sure your replay database has the same structure as the capture database， except without data.BMake sure the replay and capture databases are similar in data content.CPerform a clean shutdown and restart of the capture database before beginning a workload capture.DStart the capture database in UNRESTRICTED mode， then start the capture.EDefine inclusion and exclusion filters.
单选题A customer is running system management software on one of their Windows xSeries servers， and the software seems to slow down their database application over time. The customer is running IBM Director in their environment. Which IBM Director tool can they utilize to guarantee processor time for the different applications and optimize the server performance？（）ASoftware RejuvenationBCapacity ManagerCCapacity Workload ManagerDAurema Application Workload Manager
单选题A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）AThe application server，firewall，and database server on the same VLANBThe application server and firewall on one VLAN，and the database server on a second VLANCThe application server on one VLAN，and the database server and firewall on a second VLANDThe application server and firewall on one VLAN，and the firewall and database server on a second VLAN
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal？（）ATo achieve the goal， a Linked Server connection should be configured to the application database.BTo achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.CTo achieve the goal， a Remote Server connection to the application database should be configured.DTo achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.
单选题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）
单选题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
单选题A customer needs to ensure that the number of threads servicing an application does not exceed the number of database connections available to the application. What step must you take to address this situation?（）AConfigure a Max Threads Constraint and add your application to the list of applications for the Constraint.BConfigure a Work Manager with a Maximum Threads Constraint tied to the Connection Pool and configuration your application to use the Work Manager.CConfigure a Work Manager with a Minimum Threads Constraint tied to the Connection Pool and configure your application to use the Work Manager.DConfigure a global MaxThreads constraint and target it to the server or clusters where your application is deployed.EConfigure the startup parameter -Dwls-maxThreads to be the same as the number of database connections configured.
多选题Which two statements about workload capture and replay operations are true?（）AThe clients must be created manually on the test machines to perform more realistic testing.BRestart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.CRestart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.DThe application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
单选题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）