Chapter 7 WORKING WITH VIEWS 443 A PPLY
Chapter 7 WORKING WITH VIEWS 443 A PPLY YOUR K NO WLEDGE cannot be based on temporary tables. 7. When data is being modified, deleted, and updated through a view, the data definition in the view does not change; the data modification is aimed at the underlying referenced tables associated with the view. Answers to Exam Questions 1. B. A view does not contain data as a table does. It is often accessed with methods that are similar to those you use with a table, but the view is a definition or description of data that should be retrieved from a table or tables. For more information about view basics, see the section Understanding Views. 2. B. Partitioned views, and specifically distributed partitioned views, may improve the data access for Tom s database. Because a large number of rows could be separated by sales division per server (with one server maintaining information for two divisions), his database tables may be ideal candidates for distributed partitioned views. For more information about partitioned views, see the section Creating Partitioned Views. 3. A, B, D. The main benefits of views are that they disallow unneeded data, improve security enforcement, ease data exporting and generally make querying easier. For more information about the benefits for views, see the section View Benefits. 4. A, B. Both the Query Analyzer and the SQL Server Enterprise Manager can create views. For more information about creating views, see the section Creating Views. 5. B. A total of 1024 columns can be referenced in Suggested Readings and Resources a view definition. For more information about what a view is and some of its restrictions, see the section Understanding Views. 6. C. A distributed partitioned view collects data from two or more instances of SQL Server, hence the name distributed. Essentially, distributed partitioned views are used when you want to spread processing out over a group of servers, but want the data to be treated as a single unit. For more information about partitioned views, see the section Alter Database Objects to Support Partitioned Views. 7. C. The WITH CHECK OPTION forces all data modification statements executed against the view to adhere to the criteria set within the view definition. When a row is modified through a view, the WITH CHECK OPTION guarantees that the data remains visible through the view after the modification has been committed. For more information about restrictions on data modifications, see the section Updating Rows Through Views. 8. A. Horizontally filtering the table will work
If you looking for unlimited one inclusive web hosting plan please check cheap web hosting website.