Database Fundamentals — Question 91

This question requires that you evaluate the underlined text to determine if it is correct.
Create a query that returns a set of table data by using the UPDATE statement.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

Answer options

• A. No change is needed
• B. INSERT
• C. REPLACE
• D. SELECT

Correct answer: D

Explanation

The statement is incorrect because the UPDATE statement is used for modifying existing records, not for retrieving data. The correct command to retrieve a set of table data is the SELECT statement, making option D the right choice. The other options do not apply to returning table data.