You work as a database administrator at ABC.com. You study the exhibit carefully and examine the structure of CUSTOMRS AND SALES tables. Evaluate the following SQL statement: Which statement is true…

Question

Exhibit

Options

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

• A
  75% (27)
• B
  8% (3)
• C
  3% (1)
• D
  14% (5)

No community discussion yet for this question.