O'Reilly logo

The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit by Mark Horninger

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required