The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P135: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 652 Chapter 14 Implementing Objects A. TRUNCATE TABLE EmployeePhoto B. DELETE EmployeePhoto C. DELETE FROM EmployeePhoto D. DROP TABLE EmployeePhoto 8. The HR manager has asked you to create a table that will store candidate resumes. These files are created using Microsoft Word 2003 or Microsoft Word 2007 and the HR manager wishes that they are stored in this format. It is a requirement that the HR representatives are able to query the table using search engine style syntax. How should you create the table A. CREATE TABLE Resumes ResumelD int PRIMARY KEY NULL ResumeFile varbinary max FileType varchar 10 B. CREATE TABLE Resumes ResumeID int PRIMARY KEY ResumeFile varbinary max C. CREATE TABLE Resumes ResumeID int PRIMARY KEY ResumeFile varbinary max FileType varchar 10 D. CREATE TABLE Resumes ResumelD int UNIQUE NULL ResumeFile varbinary max FileType varchar 10 9. You have a table named TeamMembers containing the data shown in Table . Table TeamMembers Table MemberName varchar 50 PRIMARY KEY Valentine Hayden Matthew Implementing Objects Chapter 14 653 MemberName is the PRIMARY KEY for the table. You execute the following statement INSERT TeamMembers Values Phil Valentine Peter Which team members will be present in the TeamMembers table after the statement executes A. Valentine Hayden Matthew Phil B. Valentine Hayden Matthew Phil Peter C. Valentine Hayden Matthew Phil Valentine Peter D. Valentine Hayden Matthew 10. You have created a Customers table and an NZCustomers view using the following definitions. CREATE TABLE Customers CustomerID int IDENTITY PRIMARY KEY CompanyName varchar 50 Country varchar 50 Notes varchar max GO CREATE VIEW NZCustomers AS SELECT FROM Customers WHERE Country New Zealand GO CREATE TRIGGER Trig_NZCustomers ON INSTEAD OF INSERT AS BEGIN SELECT CustomerID FROM INSERTED END GO You notice that when you insert data into the NZCustomers view no error occurs but the data does not appear in the table. What is the cause of .
