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?
A.
It would execute and restrict modifications to only the column specified in the SELECT
statement
B.
It would not execute because two tables cannot be used in a single UPDATE statement
C.
It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE
statement
D.
It would not execute because the SELECT statement cannot be used in place of the table name
If there are two Roberts and both have credit limit 600 than there will be more than one Cust_id. In that case the query will fail.
Anybody have different opinion, please post.
I agree with Bina.
As I understand from https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/update_statement.htm you can not use sub query inside where of update query.
I did it in database. It’s work. B is correct.
sorry, A