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

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

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

3.Which of the following servers would execute SQL？（）A、 Database ServerB、 DNS ServerC、 NAS ServerD、 Web Server

4. 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 ap”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    单选题
    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
    解析： 暂无解析

  • 第7题：

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


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

  • 第8题：

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

     Database Server

    B

     DNS Server

    C

     NAS Server

    D

     Web Server


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

  • 第9题：

    多选题
    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
    解析： 暂无解析

  • 第10题：

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


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

  • 第11题：

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

    B

    Virtual Ethernet

    C

    Virtual I/O Server

    D

    Micro-Partitioning


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

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

    正确答案:C

  • 第17题：

    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

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

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

    B

    Fiber channel switch

    C

    Multiple failed drives in the SAN

    D

    HBA


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    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
    解析： 暂无解析

相关内容