440 Part I EXAM PREPARATION APPLY YOUR KNOWLEDGE
440 Part I EXAM PREPARATION APPLY YOUR KNOWLEDGE maximum number of columns that can be joined by the view John is creating? A. 250 B. 1024 C. It depends on the number of tables being referenced D. An unlimited amount 6. Jauna works for a trading company and has a massive amount of data held in databases that are found on multiple servers. This was done because they thought that putting the tables on multiple servers would ensure more efficient data access. Which of the following would you use to gather all this data into a single unit? A. Indexed view B. Replication view C. Distributed partitioned view D. Extended partitioned view 7. Your company keeps track of all sales on a monthly basis. The company requires that the sales manager enter all sales that are greater than $20,000 into a database. They do not want the sales manager to be able to enter values that are less than $20,000 in the database. You are in charge of creating a view for the Sales table that includes the following columns: amount, date, and sales_person. You would like this view to enable the sales manager to enter the valid sales figures. Which of the following describes the view needed? A. CREATE VIEW ApprovedSales AS SELECT date, Sales_Person, Amount FROM Sales WHERE Amount<=20000 B. CREATE VIEW ApprovedSales AS SELECT Number, SalesPerson, Amount FROM Sales HAVING Amount<=20000 C. CREATE VIEW ApprovedSales AS SELECT date, SalesPerson, Amount FROM Sales WHERE Amount<=20000 WITH CHECK OPTION D. CREATE VIEW ApprovedSales AS SELECT Number, SalesPerson, Amount FROM Sales HAVING Amount<=20000 WITH CHECK OPTION 8. Chris works as a SQL Server database developer in the technical department of a nationwide blogstore. Chris needs to create a view by filtering data for the 50 customers having greatest payments due from the Customers table. Which strategy would be the best for him to use? A. Retrieve slices of the Customers table horizontally B. Retrieve slices of the Customers table vertically C. Both A and B D. Use the filtered view, new to SQL Server 2000 9. You are working on your new view called SummaryData, which uses complex aggregates and joins for a company database. The view SummaryData you have just created took you a good amount of time and effort. You don t want other users to see how you created your view. What is the best and easiest way to implement this type of security? A. Create it with the WITH ENCRYPTION option. B. Create it with the WITH CHECK option. C. Create it in Enterprise Manager and select Hidden Definition
For reliable and cheap web hosting services please check tomcat web hosting website.