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 appl

题目

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
相似考题

1.Which components are installed on the middle tier in a WebSphere Commerce V 5.6 three-tier configuration （i.e. in a three-node topology）？（）A、WebSphere Commerce Server， WebSphere Application Server and Web server pluginB、WebSphere Application Server， Database Client and Web server pluginC、WebSphere Commerce Server， Database Server and WebSphere Application ServerD、WebSphere Commerce Server， WebSphere Application Server and Database ClientE、Web server， WebSphere Commerce Server and WebSphere Application Server

2. 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

3.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

4. 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.

参考答案和解析
正确答案:C
更多“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 appli”相关问题

  • 第1题：

    Which of the following servers would execute SQL？（）

    • A、 Database Server
    • B、 DNS Server
    • C、 NAS Server
    • D、 Web Server

    正确答案:A

  • 第2题：

    A database application is installed on a server. The AIX default filesystem cache is not being re-used by the database. Which of the following should be used to fix this problem?（）

    • A、vmo to adjust the maxperm value
    • B、schedo to adjust the mempool size
    • C、ioo to modify the maxpgahead value
    • D、bosboot to reassign the memory cache size

    正确答案:A

  • 第3题：

    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.

    正确答案:A

  • 第4题：

    Which two prerequisites are needed for performing workload capture and replay？（）

    • A、Close all sessions performing queries using database links
    • B、running the database in shared server mode
    • C、The database on which the workload is replayed has to be a restore of the original database to a specific SCN
    • D、setting up the directory to capture the workload

    正确答案:C,D

  • 第5题：

    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.

    正确答案:E

  • 第6题：

    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 environment
    • D、 The database local time zone will be set for the database using the operating system environment variable.

    正确答案:B

  • 第7题：

    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.

    正确答案:B,D

  • 第8题：

    单选题
    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 Order

    B

    Set the Parallel Acquisition Order

    C

    Configure Online on the Same Node Dependency

    D

    Configure Online on Different Nodes Dependency


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    Which of the following servers would execute SQL？（）
    A

     Database Server

    B

     DNS Server

    C

     NAS Server

    D

     Web Server


    正确答案： B
    解析： 暂无解析

  • 第10题：

    多选题
    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 database

    C

    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.


    正确答案： A,C
    解析： 暂无解析

  • 第11题：

    多选题
    Which two prerequisites are needed for performing workload capture and replay？（）
    A

    Close all sessions performing queries using database links

    B

    running the database in shared server mode

    C

    The database on which the workload is replayed has to be a restore of the original database to a specific SCN

    D

    setting up the directory to capture the workload


    正确答案： C,D
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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 database
    • C、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.

    正确答案:B,C

  • 第14题：

    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.

    正确答案:D

  • 第15题：

    Automatic Shared Memory Management （ASMM） has been enabled for your database instance.  Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M；  Which statement is true in this scenario（）

    • A、The minimum memory size for the database buffer cache is set to 100 mb.
    • B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
    • C、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
    • D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb

    正确答案:A

  • 第16题：

    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 client
    • B、to restrict the scope of administration to identical operating systems
    • C、to allow the start up and shut down of the database from a remote client
    • D、to enable the administration of the operating system from a remote client
    • E、to disable the administration of the operating system from a remote client

    正确答案:A

  • 第17题：

    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.

    正确答案:E

  • 第18题：

    You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1，000 simultaneous users. This application must quickly display the results of calculation-intensive operations， such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do？（）

    • A、Implement parameterized Transact-SQL queries in the application.
    • B、Implement Transact-SQL stored procedures in the database.
    • C、Implement CLR stored procedures in the database.
    • D、Implement distributed Web services.

    正确答案:C

  • 第19题：

    In a two-tier configuration， it is recommended to put which of the following components on different nodes？（）

    • A、Database client and database server
    • B、WebSphere Application Server and Database Server
    • C、WebSphere Commerce Server and WebSphere Application Server
    • D、Web server and WebSphere Application Server

    正确答案:A,B

  • 第20题：

    单选题
    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 client

    B

    to restrict the scope of administration to identical operating systems

    C

    to allow the start up and shut down of the database from a remote client

    D

    to enable the administration of the operating system from a remote client

    E

    to disable the administration of the operating system from a remote client


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?（）
    A

     Implement parameterized Transact-SQL queries in the application. 

    B

     Implement Transact-SQL stored procedures in the database. 

    C

     Implement CLR stored procedures in the database. 

    D

     Implement distributed Web services.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    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 environment

    D

     The database local time zone will be set for the database using the operating system environment variable.


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

相关内容