Oracle
1Z0-054 · Question #198
1Z0-054 Question #198: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #198. The question stem and answer options stay visible for context.
Question
You have the following requirements: - Your transaction only queries the table, and requires a consistent set of the table's data for the duration of the transaction. - You can hold up other transactions that try to update the locked table, until all transactions that hold SHARE locks on the table either commit or roll back. - Other transactions may acquire concurrent SHARE table locks on the same table, also allowing them the option of transaction-level read consistency. Which type of locking strategy would you select to achieve this?
Options
- ASHARE
- BEXCLUSIVE
- CROW SHARE
- DROW EXCLUSIVE
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.