Oracle
1Z0-054 · Question #198
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…
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.