Chapter 7 WORKING WITH VIEWS 441 APPLY YOUR
Chapter 7 WORKING WITH VIEWS 441 APPLY YOUR KNOWLEDGE D. Create it with the HIDDEN DEFINITION option. 10. You work with several developers who regularly CREATE, DROP, and ALTER views within your database. These actions have been causing many views to malfunction when dependent objects are altered. What option can you use to prevent some of your problems? A. CREATE INDEXED VIEW B. The WITH SCHEMABINDING option C. The WITH ENCRYPTION option D. The WITH CHECK option 11. Jeffery has just created a view to enforce data security on the Sales table. You are an assistant developer and are receiving complaints relating to the view Jeffery created some time ago. You assume that he made mistakes when creating the view and so in an attempt to do some cleanup, you try to access the view definition. When trying to access the definition of the view, you find that you are not able to. What is the most common reason to not be able to access a view definition? A. Jeffery specified the Encrypt On View option when he created the view. B. Jeffery specified SECURE DEFINITION when he created the view. C. Jeffery did not repair the view since the first time it was created three months ago. D. Jeffery used WITH ENCYPTION when he created the view. 12. You are troubleshooting an access problem with a view. Mary is having problems using Bob s new view, Bob.BobView1. Examine the following exhibits to figure out what is causing Mary s access problem. Exhibit 1 contains the tables that are in the database, Exhibit 2 contains the definitions of the views that are in the database, and Exhibit 3 are the permissions that were assigned to each object. After examining the exhibits, choose the best answer to explain Mary s access problem. Exhibit 1: Create Tables CREATE TABLE dbo.DBOTable1 ( id int, name varchar(20) ) CREATE TABLE bob.BobTable1 ( id int, description varchar(20) ) CREATE TABLE jane.JaneTable1 ( id int, address varchar(20) ) GO INSERT INTO dbo.DBOTable1 VALUES (1, Buddy ) INSERT INTO Jane.JaneTable1 VALUES (1, 123 .Some Street ) INSERT INTO Bob.BobTable1 VALUES (1, What .was his name? ) Exhibit 2: Create Views CREATE VIEW Jane.JaneView1 AS SELECT dbo.DBOTable1.id, name, address FROM dbo.DBOTable1 INNER JOIN Jane.JaneTable1 ON dbo.DBOTable1.id = Jane.JaneTable1.id GO CREATE VIEW Jane.JaneView2 WITH ENCRYPTION AS SELECT id, description FROM Bob.BobTable1 GO CREATE VIEW Bob.BobView1 AS
For high quality jboss hosting services please check jboss web hosting website.