442 Part I EXAM PREPARATION A PPLY YOUR
442 Part I EXAM PREPARATION A PPLY YOUR K NO WLEDGE SELECT Jane.JaneView1.id, name, address, .description FROM Jane.JaneView1 INNER JOIN Jane.JaneView2 ON Jane.JaneView1.id = Jane.JaneView2.id Exhibit 3: Assign Permissions REVOKE all ON dbo.DBOTable1 TO public REVOKE all ON Jane.JaneTable1 TO public REVOKE all ON Bob.BobTable1 TO public GRANT SELECT ON Bob.BobView1 TO Jane, Mary GRANT SELECT ON Jane.JaneView1 TO Mary, Bob, .dbo GRANT SELECT ON dbo.DBOTable1 TO Jane GRANT SELECT ON Bob.BobTable1 TO Mary, Jane GRANT SELECT ON Jane.JaneTable1 TO Bob, dbo GRANT SELECT ON Jane.JaneView2 TO Mary A. When you create a view using WITH ENCRYPTION, you must use GRANT WITH DECRYPTION. B. One GRANT is missing for Mary. C. Two GRANTs are missing for Mary. D. There is nothing wrong with the code in the exhibits; the problem is likely with Mary s network connection. 13. Mary has created a view that is going to be used to create an employee phone list. She would like to sort the new view by the employees last names. She has tried to create the view using the ORDER BY clause, but it always fails. What can Mary do to create her view? A. Order the base table using a clustered index, then the required data will already be in the correct order. B. Use the TOP clause rather than the ORDER BY clause. C. Use the TOP clause in addition to the ORDER BY clause. D. This clause cannot be used. Answers to Review Questions 1. A view refers to data that is found in a table. The view does not actually contain any data. Although it takes up some space in the sysobjects and syscomments tables, in relative terms, the storage requirements are very small. 2. The CHECK constraint is used to identify which portion of the data can be found in which table. This published division speeds up searches for data through the view. 3. If you base a view on an existing view, you can further restrict, filter, or merge data that is currently defined through the existing view or views. 4. Generally, you would want to use a partitioned view when you want to gather information from many tables and make them appear as a single table. You may need to do this if you have split your data across several servers. This is done in some circumstances to improve data access performance. 5. You should implement a view in your database when you would like to disallow redundant data, enforce security, or export data easily. 6. Defaults, triggers and rules are not allowed to be associated with a view. INSTEAD OF triggers may be defined on a view. Even though a view is defined by a SELECT statement, it is not allowed to use the COMPUTE BY or SELECT INTO clauses. The ORDER BY clause may only be used in conjunction with the TOP clause. Finally, views
For high quality jboss hosting services please check jboss web hosting website.