Chapter 7 WORKING WITH VIEWS 439 APPLY YOUR
Chapter 7 WORKING WITH VIEWS 439 APPLY YOUR KNOWLEDGE based on a view, rather than on a table? 4. When would you want to use a partitioned view? 5. Generally speaking, when would you want to implement a view into your database? 6. Which objects are not allowed to be associated with a view? 7. When modifying data through a view, what are you actually modifying? Exam Questions 1. Which of the following statements best describes a view? A. A table stored on physical memory whose contents are derived from a query B. A definition of what data should be extracted from a table or tables C. A normal table except that it can be partitioned D. The way a table is shown is SQL Server 2. Tom is interested in examining ways to improve his data access performance through view implementations. He is currently managing a database that is replicated between five servers (for load balancing) and contains customer information for six sales divisions. The Customer table currently contains a consolidated list of 100,000 customer records. What could Tom try to implement to improve server performance? A. Aggregated views B. Partitioned views C. Complex views D. Full outer views 3. Which of the following is a benefit provided by a view? Choose all that apply. A. Minimize unneeded data. B. Security is enforced using views. C. Data is easily transformable. D. Data can be easily exported using tools, such as BCP. 4. Henry is the system administrator of the databases at his company. Users who access the database often query the Sales table, which has more than 50,000 rows and 15 columns. Most of the columns retrieved by users are unnecessarily retrieved. Henry needs to disallow the retrieval of the unnecessary columns and allow users to retrieve only the data that is needed. He decides to use a view. Which of the following tools can Henry use to create views? Choose all that apply. A. Query Analyzer B. SQL Server Enterprise Manager C. View Edit Wizard (VEW) D. None of the above 5. John works in a major telecom company. Each table in his central database has numerous columns and he wants to create a view by joining data from four tables. He does this, so that he can enable users to retrieve data efficiently from a view rather than retrieving the different columns manually by using JOIN statements. What is the
If you looking for unlimited one inclusive web hosting plan please check cheap web hosting website.