Oracle Locks   «Prev  Next»

Oracle Lock Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which is true about database deadlocks? (Please select all that apply.)
Please select all the correct answers.
  A. Oracle deadlocks must be manually cleaned-up with the KILL SESSION command.
  B. Oracle deadlocks are detected by Oracle.
  C. Oracle deadlocks can be created by a single session.
  D. Oracle will terminate the task that creates the deadlock.

2. Which Oracle view will allow you to see Oracle sessions that are waiting for locks to release?
Please select the best answer.
  A. The V$SYSSTAT view
  B. The DBA_WAITERS view
  C. The DBA_HOLDERS view

3. Which locking mechanism will be invoked when an SQL UPDATE is issued?
Please select the best answer.
  A. Row share locks
  B. Row exclusive locks
  C. Table share locks
  D. Table exclusive locks

4. You have decided to give all of your employees a five percent raise. What Oracle mechanism will result in the fewest lock resources being used?
Please select the best answer.
  A. Select all rows in the table with the FOR UPDATE clause.
  B. Issue the LOCK TABLE command before the update.
  C. Just issue the update and let Oracle handle the locks.
  D. Place the update in a PL/SQL cursor and commit after every 50 updates.