Oracle
1Z0-061 · Question #198
1Z0-061 Question #198: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #198. The question stem and answer options stay visible for context.
Question
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?
Options
- AIt would not execute because two tables cannot be used in a single UPDATE statement.
- BIt would not execute because the SELECT statement cannot be used in place of the table name.
- CIt would execute and restrict modifications to only the columns specified in the SELECT statement.
- DIt would not execute because a subquery cannot be used in the WHERE clause of an UPDATE
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.