网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）
A
The Query Cache is pruning queries due to an increased number of requests
B
Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups
C
Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded nature
D
The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution
参考答案
参考解析
解析：
暂无解析
更多 “单选题A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）A The Query Cache is pruning queries due to an increased number of requestsB Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookupsC Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded natureD The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution” 相关考题
考题
A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend？（）A、 Use the SQL Server Profiler to capture all SQL activities.B、 Use a Dynamic Management View to analyze performance.C、 Use the Database Engine Tuning Advisor to analyze the workload.D、 Use Microsoft SQL Server Management Studio to analyze the SQL logs.
考题
A technical specialist has a requirement to implement a 4-way POWER5 server with a small Web server partition and a high performance database server partition. The Web server provides a client front-end to the database server. The most important concerns are speed of communication between the Web server and the database and I/O speed of the database. Which of the following virtualization features would be most appropriate？（）A、Virtual SCSIB、Virtual EthernetC、Virtual I/O ServerD、Micro-Partitioning
考题
The staff is not able to access a database server. The server has an ’Operating System not found’error and is set to boot from a fiber channel SAN. All other database servers are set to boot from the SAN and access the same switch and data as this database server. Which of the following is the MOST likely cause of the problem？（）A、The SAN is offlineB、Fiber channel switchC、Multiple failed drives in the SAND、HBA
考题
Which of the following servers would execute SQL？（）A、 Database ServerB、 DNS ServerC、 NAS ServerD、 Web Server
考题
When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）A、The database has a subset of the tables in the production server database.B、The database has a copy of selected data from the production databaseC、The database logs changes for later propagation.D、The database is accessed as read-only to prevent data corruption.E、The database includes all user and order data for offline processing.
考题
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.
考题
A specialist is monitoring performance on a server. The data is on another partition within the same array as the OS. The following information is available： （1）The average record written to disk is 16KB （2）The I/O block size is 2KB （3）The stripe size on the RAID array is 16KB Which of the following will improve performance without rebuilding the operating system？（）A、Change the I/O block size to match the RAID Stripe size.B、Change the RAID stripe size to match the I/O block size.C、Change the record size of the database to match the RAID stripe size.D、Change the record size of the database to match the I/O transfer rate.
考题
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
考题
You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
考题
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
考题
You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（） A、 The operating system local time zone will be set for a user session using the operating system environment variable.B、 The database local time zone will be set for a user session using the operating system environment variable.C、 The operating system local time zone will be set for the database using the operating system environmentD、 The database local time zone will be set for the database using the operating system environment variable.
考题
A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）A、The Query Cache is pruning queries due to an increased number of requestsB、Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookupsC、Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded natureD、The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution
考题
You are planning the migration of a Microsoft SQL Server 2008 database to SQL Azure. You need to recommend an approach for ensuring that database connectivity does not degrade. Which two actions should you recommend？（）A、 Implement transactions for database queries.B、 Close database connections in the application.C、 Use Microsoft ADO.NET in the data access layer.D、 Implement a retry policy in the data access layer.
考题
In a two-tier configuration， it is recommended to put which of the following components on different nodes？（）A、Database client and database serverB、WebSphere Application Server and Database ServerC、WebSphere Commerce Server and WebSphere Application ServerD、Web server and WebSphere Application Server
考题
单选题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 administrator is planning a cluster running applications in 3 separate resource groups. RGA - Database 1 RGB - Web Server RGC - Database 2 Database 1 and Database 2 must be online before the Web Server. All resource groups have a Startup Policyof Online on Home Node Only. Which of the following will ensure that the resource groups are processed in the correct order？（）A
Set the Serial Acquisition OrderB
Set the Parallel Acquisition OrderC
Configure Online on the Same Node DependencyD
Configure Online on Different Nodes Dependency
考题
单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A
Configure Java Pool to cache the java objects.B
Configure Streams Pool to enable parallel processing.C
Increase Shared Pool size to cache more PL/SQL objects.D
Increase Database Buffer Cache size to increase cache hits.E
Configure Large Pool to be used by RMAN and shared server.F
Increase the total System Global Area （SGA） size to increase memory hits.
考题
单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A
to enable operating system authentication for a remote clientB
to restrict the scope of administration to identical operating systemsC
to allow the start up and shut down of the database from a remote clientD
to enable the administration of the operating system from a remote clientE
to disable the administration of the operating system from a remote client
考题
单选题Which of the following servers would execute SQL？（）A
Database ServerB
DNS ServerC
NAS ServerD
Web Server
考题
单选题The staff is not able to access a database server. The server has an ’Operating System not found’error and is set to boot from a fiber channel SAN. All other database servers are set to boot from the SAN and access the same switch and data as this database server. Which of the following is the MOST likely cause of the problem？（）A
The SAN is offlineB
Fiber channel switchC
Multiple failed drives in the SAND
HBA
考题
多选题When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）AThe database has a subset of the tables in the production server database.BThe database has a copy of selected data from the production databaseCThe database logs changes for later propagation.DThe database is accessed as read-only to prevent data corruption.EThe database includes all user and order data for offline processing.
考题
单选题You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（）A
The operating system local time zone will be set for a user session using the operating system environment variable.B
The database local time zone will be set for a user session using the operating system environment variable.C
The operating system local time zone will be set for the database using the operating system environmentD
The database local time zone will be set for the database using the operating system environment variable.
考题
单选题You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A
Configure Java Pool to cache the java objects.B
Configure Streams Pool to enable parallel processing.C
Increase Shared Pool size to cache more PL/SQL objects.D
Increase Database Buffer Cache size to increase cache hits.E
Configure Large Pool to be used by RMAN and shared server.F
Increase the total System Global Area （SGA） size to increase memory hits.
考题
单选题A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend？（）A
Use the SQL Server Profiler to capture all SQL activities.B
Use a Dynamic Management View to analyze performance.C
Use the Database Engine Tuning Advisor to analyze the workload.D
Use Microsoft SQL Server Management Studio to analyze the SQL logs.
考题
单选题A technical specialist has a requirement to implement a 4-way POWER5 server with a small Web server partition and a high performance database server partition. The Web server provides a client front-end to the database server. The most important concerns are speed of communication between the Web server and the database and I/O speed of the database. Which of the following virtualization features would be most appropriate？（）A
Virtual SCSIB
Virtual EthernetC
Virtual I/O ServerD
Micro-Partitioning
考题
单选题A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）A
The Query Cache is pruning queries due to an increased number of requestsB
Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookupsC
Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded natureD
The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution
考题
单选题A specialist is monitoring performance on a server. The data is on another partition within the same array as the OS. The following information is available： （1）The average record written to disk is 16KB （2）The I/O block size is 2KB （3）The stripe size on the RAID array is 16KB Which of the following will improve performance without rebuilding the operating system？（）A
Change the I/O block size to match the RAID Stripe size.B
Change the RAID stripe size to match the I/O block size.C
Change the record size of the database to match the RAID stripe size.D
Change the record size of the database to match the I/O transfer rate.
热门标签
最新试卷
