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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
