Microsoft 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0
#81. You have a table with 10,000 rows, it grows by 10 % every year. There is a nightly batch that updates the table with data. The following morning, users are complaining the the queries they run are really slow the first time they run but they speed up the second time. What can you do to speed up the performance of queries?
#82. You have an application that captures real time stock market information and generates trending reports. In the past the reports were generated after the stock markets closed. The reports now need to be generated on demand during trading hours. What can you do so that the reports can be generated without affecting the rest of the application?
#83. Your database include a salesperson table that trace various data, including the sales goal and actual sales for individual salespeople. The sales manager want a report containing a list of the 5ys productive salespeople, along with their goal and their actual sales productive. You will use ascending sort to over the information in the report by actual sales production.
#84. You add new funtionality to an existing database application. After the upgrade user of the application report slower performance. The new functionality executes muliples stored procedure and dynamic sql statment. You have to identify the specific querries that are encountering excessively long execution time.What you should do?
#85. Evaluate this statement: USE sales SELECT manufacturer_id, SUM(unit_price) FROM inventory GROUP BY manufacturer_id If the inventory table contains 350 unit_price values and there are 125 different manufacturers, how many unit_price values will be displayed?
#86. Experiment table shows: CREATE TABLE Experiment ( ExperimentID char (32) Description Text, Status Integer, Results Text ) You write the following: SELECT * FROM Experiment WHERE CONTAINS (DESC,'angina') You received an empty result set. (Choose 2.)
#89. You have an inventory db with the log on a separate device. Want to increase log by 20MB. You have created device invlogdev2 of 40MB. Is the following correct? alter database inventory on invlogdev2=20 exec sp_logdevice inventory, invlogdev2
gen. 0.045
Forum
Master braindump