- The database owner owns a table called Customer. She wants to give access to the CustomerID, FirstName, LastName, and TelephoneNumber columns for all users with customer IDs between 1 and 500 in that table to Larry, who is using an application to update the records. Which of the following scripts would best accomplish this goal?
   create view CustomerView as select CustomerID, LastName, FirstName, TelephoneNumber from Customer where CustomerID between 1 and 500

- The graphical execution plan presented by SQL Server Query Analyzer uses different icons to represent which of the following?
   Physical operators

- To use full-text searching and find all rows containing forms of the verb "swim," you should use which CONTAINS predicate?
   CONTAINS(columname, FORMSOF(INFLECTIONAL, 'Swim'))

- Two new developers at your company come to you looking for help on a problem they’re having. Its seems that one of them has created several new tables in the database that she has populated. The other developer cannot access the tables, however. She is getting an “Invalid Object Name” error instead. What most likely happened?
   The tables created are owned by the first developer, not by the DBO (database owner). Unless the second developer references them with the owner's name she will not find them.