View the Exhibit and examine the structure of CUSTOMERS and SALES tables. Evaluate the following SQL statement: UPDATE (SELECT prod_id, cust_id, quantity_sold, time_id FROM sales) SET time_id =…

Question

Options

• AIt would not execute because two tables cannot be used in a single UPDATE statement.
• BIt would not execute because the SELECT statement cannot be used in place of the table name.
• CIt would execute and restrict modifications to only the columns specified in the SELECT statement.
• DIt would not execute because a subquery cannot be used in the WHERE clause of an UPDATE

• B
  11% (2)
• C
  84% (16)
• D
  5% (1)

Explanation

One UPDATE statement can change rows in only one table, but it can change any number of rows in that table.

No community discussion yet for this question.