Which statement is true regarding the execution of the above UPDATE statement?

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 = ’22-MAR-2007′
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_last_name = ‘Roberts’ AND
credit_limit = 600);
Which statement is true regarding the execution of the above UPDATE statement?

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 = ’22-MAR-2007′
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_last_name = ‘Roberts’ AND
credit_limit = 600);
Which statement is true regarding the execution of the above UPDATE statement?

A.
It would not execute because two tables cannot be used in a single UPDATE statement.

B.
It would not execute because the SELECT statement cannot be used in place of the table
name.

C.
It would execute and restrict modifications to only the columns specified in the SELECT
statement.

D.
It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE
statement.

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


url

url

I must thank you for the efforts you have put in penning this website. I’m hoping to view the same high-grade blog posts from you later on as well. In truth, your creative writing abilities has motivated me to get my very own site now ;)|