单选题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?（）AThe Query Cache is pruning queries due to an increased number of requestsBQuery_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookupsCMutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded natureDThe 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 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
参考解析
解析：
暂无解析
相关考题：
下列连接字符实现与SQL Server数据库的连接，( )是不正确的。A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;C.Data Source=.\\SQLEXPRESS; Database=SchoolDB; Uid=abc; Pwd=;D.Driver={SQL Server 2000}; Server=localhost; Database=stuDB; Uid=abc; Pwd=123;
You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.You want to enable the server in Sydney to connect to the mainframe. database. What should you do?A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.B．Modify the workflow in the DTS package so that the server in Sydney is included.C．On the server in Sydney, install an OLE DB provider for the mainframe. database.D．On the server in Sydney, delete and then re-create the DTS package.
Which correctly describes the tiers of the Oracle Workflow architecture?() A. Oracle Database tier and Application server tier onlyB. Oracle Database tier, Application server tier, and End-user client tier onlyC. Oracle Database tier, Application server tier, and Development client tier onlyD. Oracle Database tier, Application server tier, Development client tier, and End-user client tier
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 the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?A．Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.B．Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.C．Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.D．Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.
You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.How should you configure the database?A．Configure the database on the two servers as a SQL Server 2000 cluster.B．Configure the database on one server, and then configure a standby database on the second server.C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.D．Configure the database as a federated database, and then partition half the data on each server.
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.However, the existing SQL server computers in your office are configured to use theSQL_Latin1_General_CP1_CI_AS collation.You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.What should you do?A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.
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
用T2000DM工具备份的MO存放的目录可以任意选择，而用网管界面上的“数据库备份”备份后的MO只能存放在（）A、/T2000/server/scriptB、/T2000/server/database/MOC、/T2000/server/database/dbbackupD、/T2000/server/database
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 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
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database（）A、ClusterB、Database linkC、Mapping tableD、Materialized view
You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification. Which schema object enables the user to access the information from the remote database（）A、ClusterB、Database linkC、Mapping tableD、Materialized view
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.
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB01 in the instance. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1， and they can perform this by using SQL Server Profiler. But they have to be given as little permission as possible. The company CIO assigns this task to you. So what action should you perform to achieve this goal？（） A、All the SQL Server logins of the application developers have to be added to a fixed server role. B、All the database users of the application developers have to be added to a fixed database role C、All SQL Server logins of the application developers should be given the appropriate server-level permissions. D、All database users of the application developers should be given the appropriate database-level permissions.
You have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases. What should you include in your naming convention（）？ A、For each mailbox database， provide a database name that is unique within the organization.B、For each mailbox database， provide a database name that is unique within the Mailbox server.C、For each mailbox database file， provide a file name that is unique within the organization.D、For each mailbox database file， provide a file name that is unique within the Mailbox server.
You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）A、 Use SQLAzure Data Sync Service.B、 Use SQL Server replication.C、 Use SQL Server backup and restore.D、 Use SQL Server database snapshots.
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
多选题In a two-tier configuration， it is recommended to put which of the following components on different nodes？（）ADatabase client and database serverBWebSphere Application Server and Database ServerCWebSphere Commerce Server and WebSphere Application ServerDWeb server and WebSphere Application Server
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）AFor the database, you should turn on the TRUSTWORTHY database optionBFor the database, the PAGE_VERIFY database option should be set to CHECKSUMCFor the database, the database compatibility level option should be set to 10DFor the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.
单选题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）？（）AWebSphere Commerce Server， WebSphere Application Server and Web server pluginBWebSphere Application Server， Database Client and Web server pluginCWebSphere Commerce Server， Database Server and WebSphere Application ServerDWebSphere Commerce Server， WebSphere Application Server and Database ClientEWeb server， WebSphere Commerce Server and WebSphere Application 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？（）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.
单选题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 have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database（）AClusterBDatabase linkCMapping tableDMaterialized view
单选题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 are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do？（）AUse the SQL Server 2005 Management Studio to review the permissions of the default database objects.BQuery the sys.server_permissions table on Server1.CExecute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.DQuery the sys.database_permissions and sys.database_principals tables in the MedDB database.
单选题Which correctly describes the tiers of the Oracle Workflow architecture?（）AOracle Database tier and Application server tier onlyBOracle Database tier, Application server tier, and End-user client tier onlyCOracle Database tier, Application server tier, and Development client tier onlyDOracle Database tier, Application server tier, Development client tier, and End-user client tier