Oracle
1Z0-061 · Question #309
1Z0-061 Question #309: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #309. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables. Evaluate the following SQL command: SQL> SELECT o.order_id, c.cust_name, o.order_total, c.credit_limit FROM orders o JOIN customers c USING (customer_id) WHERE o.order_total > c.credit_limit FOR UPDATE ORDER BY o.order_id; Which two statements are true regarding the outcome of the above query? (Choose two.)
Exhibit
Options
- AIt locks all the rows that satisfy the condition in the statement.
- BIt locks only the columns that satisfy the condition in both the tables.
- CThe locks are released only when a COMMIT or ROLLBACK is issued.
- DThe locks are released after a DML statement is executed on the locked rows.
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.