网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）
A
Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
B
Increase the database buffer cache size.
C
Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
D
Configure Automata Shared Memory Management.
E
Configure Automatic Memory Management
参考答案
参考解析
解析：
暂无解析
更多 “单选题An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）A Configure the KEEP buffer pool and alter the table with the corresponding storage clause.B Increase the database buffer cache size.C Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.D Configure Automata Shared Memory Management.E Configure Automatic Memory Management” 相关考题
考题
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor SQL
考题
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）A、Configure the KEEP buffer pool and alter the table with the corresponding storage clause.B、Increase the database buffer cache size.C、Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.D、Configure Automata Shared Memory Management.E、Configure Automatic Memory Management
考题
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor
考题
You are migrating a solution to Windows Azure. The solution includes a web application and a business logic layer. The web application runs on three dual-core servers. The business logic layer runs on two quad-core servers. The Windows Azure application must match or exceed the current hardware specifications. You need to recommend role instance sizes that minimize cost. What should you recommend？（）A、 Small for the web application and Medium for the business logic layerB、 Small for the web application and Large for the business logic layerC、 Medium for the web application and Large for the business logic layerD、 Large for the web application and Extra Large for the business logic layer
考题
In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）A、heap tableB、object tableC、external tableD、clustered tableE、global temporary tableF、indexorganized table （IOT）
考题
A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（） A、 Initiate an incomplete recovery operation using RMAN.B、 Copy the table from a development database.C、 Advise the user to rekey the data.D、 Perform a Flashback Drop operation.E、 Perform a Flashback Recovery operation.
考题
In which scenario will you create a hash cluster？（）A、 when you want the data to be returned automatically in chronological orderB、 if the application uses queries joining tables only occasionallyC、 if the queries against the clustered table use the equality operator （=） to retrieve the desired rowD、 if the full table scan is executed often on only one of the clustered tables
考题
You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（） A、SQL Access AdvisorB、 Memory AdvisorC、SQL Tuning AdvisorD、 Segment Advisor
考题
An application uses Windows Azure Table storage. The application uses five tables. One table used by the application is approaching the limit for storage requests per second. You need to recommend an approach for avoiding data access throttling. What should you recommend？（）A、 Use a single partition key for the table.B、 Compress data before storing it in the table.C、 Create additional partition keys for the table.D、 Continually remove unnecessary data from the table.
考题
You are creating a Windows Communication Foundation (WCF) service. The service endpoints change frequently. On the service, you add a new ServiceDiscoveryBehavior to the Behaviors collection of the ServiceHost Description property. You need to ensure that client applications can communicate with the service and discover changes to the service endpoints. What should you do?（）A、Add a new ServiceDiscoveryBehavior to the Behaviors collection in the client application.B、Add a new AnnouncementClient to the Behaviors collection in the client application.C、Use the FindCriteria class and the UdpDiscoveryEndpoint class to set up the binding in the client application.D、Use the DiscoveryProxy class and the EndpointDiscoveryMetadata class to set up the binding in the client application.
考题
You are a desktop administrator for your company. You need to deploy a new application. The application is packaged in an .msi file. The application will be used by only a small number of users. You plan to install the application by using the Msiexec.exe program. You need to ensure that the installation process does not display a user interface. What should you do?（）A、Manually perform a passive installation of the application.B、Manually perform a quiet installation of the application.C、Use a logon script to run the Msiexec.exe program.D、Use the Runas utility to run the Msiexec.exe program.
考题
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Framework (WPF) application. You have a company logo that must appear on multiple forms in the application. The logo design changes frequently. You need to ensure that when the logo image is changed, you only need to update a single location. What should you do?（）A、Define the image as a page resource.B、Define the image as an application resource.C、Save the image on a network drive.D、Include the image as an embedded resource.
考题
You work with a database named DB1， which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1， col2 FROM table1 WHERE col3 = You need to provide maximum query performance. Table1 must remain available to users. What should you do？（）A、Update all statistics on Table1 in DB1.B、Use the CREATE STATISTICS statement in DB1 to create missing statistics on col3of Table1.C、Set the priority boost server option to 1.D、Execute the following statement.USE DB1GOCREATE INDEX index1 ON table1（col3）INCLUDE（col1， col2） WITH （ONLINE = ON）GO
考题
You are designing an application that will use Windows Azure Table storage to store millions of data points each day. The application must retain each day’s data for only one week. You need to recommend an approach for minimizing storage transactions. What should you recommend？（）A、 Use a separate table for each date. Delete eachtable when it is one week old.B、 Use a separate table for each week. Delete each table when it is one week old.C、 Use a single table， partitioned by date. Use Entity Group Transactions to delete data when it is one week old.D、 Use a single table， partitioned by week. Use Entity Group Transactions to delete data when it is one week old.
考题
单选题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）A
The Automatic Memory Manager （AMM）B
The SQL Tuning AdvisorC
The Segment AdvisorD
The SQL Access Advisor
考题
单选题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A
The Automatic Memory Manager (AMM)B
The SQL Tuning AdvisorC
The Segment AdvisorD
The SQL Access Advisor SQL
考题
单选题An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）A
Configure the KEEP buffer pool and alter the table with the corresponding storage clause.B
Increase the database buffer cache size.C
Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.D
Configure Automata Shared Memory Management.E
Configure Automatic Memory Management
考题
单选题You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）A
MERGEB
SELECT …CROSS JOINC
INSERT ALL …SELECTD
CREATE VIEW …CONSTRAINT
考题
单选题In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）A
hash clustersB
index clustersC
partitioned tablesD
indexorganized table （IOT）
考题
单选题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A
The Automatic Memory Manager (AMM)B
The SQL Tuning AdvisorC
The Segment AdvisorD
The SQL Access Advisor
考题
单选题You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）A
table B
transactional trigger C
stored procedure D
FROM clause query
考题
单选题Have you ever seen a_______bag on the table?A
plastic small blackB
black small plasticC
plastic black smallD
small black plastic
考题
单选题You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）A
SQL Access AdvisorB
Memory AdvisorC
SQL Tuning AdvisorD
Segment Advisor
考题
单选题You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）A
The index can be changed from NOLOGGING to LOGGINGB
The index cannot be recovered even in the ARCHIVELOG mode.C
The index can only be created if the base table is created with the NOLOGGING option.D
The index can be recovered if you perform a backup after the CREATE INDEX statement.
考题
单选题Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）A
Join the two servers by using the four-part syntax of server.database.schema.table.B
Reference SQL2 by using an alias.C
Add SQL2 as a remote server to SQL1.D
Add SQL2 as a linked server to SQL1.
考题
单选题You are migrating a solution to Windows Azure. The solution includes a web application and a business logic layer. The web application runs on three dual-core servers. The business logic layer runs on two quad-core servers. The Windows Azure application must match or exceed the current hardware specifications. You need to recommend role instance sizes that minimize cost. What should you recommend？（）A
Small for the web application and Medium for the business logic layerB
Small for the web application and Large for the business logic layerC
Medium for the web application and Large for the business logic layerD
Large for the web application and Extra Large for the business logic layer
考题
单选题You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to design a control for the application.You need to ensure that the control meets the following requirements： （1）Contains the DataGridView， BindingSource， and BindingNavigator controls. （2）Exposes the properties of the BindingSource control. （3）Protects the properties of the DataGridView and BindingNavigator controls. What sholud you do？（）A
Extend the Control class.B
Extend the ContainerControl class.C
Create protected accesses for each control property.D
Create public accesses for the properties of the BindingSource control.
考题
单选题In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）A
heap tableB
object tableC
external tableD
clustered tableE
global temporary tableF
indexorganized table （IOT）
热门标签
最新试卷
