Oracle
1Z0-061 · Question #136
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…
The correct answer is B. It would execute and restrict modifications to only the column specified in the SELECT statement. See the full explanation below for the reasoning.
Question
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 regarding the execution of the above UPDATE statement?
Exhibits
Options
- AIt would not execute because the SELECT statement cannot be used in place of the table name
- BIt would execute and restrict modifications to only the column specified in the SELECT statement
- CIt would not execute because a sub query cannot be used in the WHERE clause of an UPDATE
- DIt would not execute because two tables cannot be used in a single UPDATE statement
How the community answered
(68 responses)- A10% (7)
- B72% (49)
- C13% (9)
- D4% (3)
Community Discussion
No community discussion yet for this question.