IBM SPSS Statistics Level 1 v2 — Question 26

When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

Answer options

• A. Predicates cannot refine what rows are updated
• B. Table(s) referenced must have table definitions imported previously
• C. Column values can be job parameters or input columns but not expressions
• D. Columns to update must be selected individually from the column selection grid

Correct answer: D

Explanation

The correct answer is D because in SQL Query builder, each column that is to be updated must be individually selected from the grid. Option A is incorrect as predicates can indeed specify which rows are updated. Option B is also wrong since table definitions must be imported, but this isn't the main focus of an UPDATE statement. Lastly, option C is incorrect because column values can be expressions, not just job parameters or input columns.