View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. (Choose the best answer.) You executed this UPDATE statement: Which statement is true regarding the execution?

Question

Exhibit

Options

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

• A
  3% (1)
• B
  8% (3)
• C
  78% (31)
• D
  13% (5)

No community discussion yet for this question.