Microsoft 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0
#101. You want to prevent any data entered from violating your business rules. The rules should be implemented on the database and may be fairly complex. What is the best way of doing this?
#102. File1, which contains Lucy's Products database, crashes. Lucy wants to recover all transaction records stored on the transaction log, including those recorded since the last time the transaction log was dumped. The log is stored on File2. What step must she take to ensure all records are retrieved from the log?
#103. You create and open a cursor using the following code: DECLARE TitlesCursor CURSOR FOR SELECT * FROM Titles OPEN TitlesCursor You want to move the cursor to the first row in the result set. SOLUTION: You execute the following code: FETCH FIRST FROM TitlesCursor Which of the following statements is true about this solution?
#104. You want to limit access to specific columns within a table, but you still want users to be able to access and modify the other columns in the table. How can you accomplish this?
#105. You want to ensure that SQL Server uses indexes efficiently when processing a query. Which of the following statements can you use to help accomplish this goal?
#106. The member table has a high volume of transactions executed against it each day. Users are complaining that updates to the member table takes a long time compared to other tables. Currently the member table has five indexes applied against it excluding the indexes created when the PRIMARY KEY and FOREIGN KEYS were defined. What can be done to improve the speed of updates against the member table?
#107. Angela wants to retrieve the average price for all books that have sold at least 100 copies, and she wants the results grouped by book type. She also wants all book types to be listed - even those that contain no titles that have sold more than 100 copies. Solution: Angela executes the following code: SELECT Type, AVG(Price) FROM Sales WHERE NumberSold >= 100 GROUP BY Type Which of the following statements is true about this solution?
gen. 0.067
Forum
Master braindump