image

Figure 7.4 WinterMenu and SpringMenu Tables

11. What would the following statement do, assuming that “Customer” is a table, that is not referenced by any FOREIGN KEY constraints?

 DELETE Customer

A. The statement will delete the table object from the database.

B. The statement will delete all data from the Customer table.

C. The statement will report an error, as no FROM keyword is specified.

D. The statement will delete no data from the Customer table, as no WHERE clause is specified.

Correct Answer & Explanation: B. This statement will delete all data from the Customer table.Incorrect Answers & Explanations: A, C, D. Answer A is incorrect, ...

Get The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.