nerdexam
Oracle

1Z0-062 · Question #252

1Z0-062 Question #252: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #252. The question stem and answer options stay visible for context.

Managing Data and Concurrency

Question

The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction. Which two types of lock exist in this situation?

Options

  • Aexclusive lock on the EMPLOYEES table
  • Bnull lock on the row being updated
  • Cnull lock on the EMPLOYEES table
  • Drow level lock on the row being updated
  • Eshared lock on the EMPLOYEES table

Unlock 1Z0-062 to see the answer

You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 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.

Topics

#row locks#table locks#transaction locks#concurrency
Full 1Z0-062 Practice