aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Oracle Database Backup Scheme
  • A transaction can lock a data item in which of the follow...
Multiple choice

A transaction can lock a data item in which of the following modes, only if it is not locked at all?

  1. Shared mode

  2. Shrinking phase

  3. Local agent

  4. Command file

  5. Exclusive mode

Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

A transaction can lock a data item in exclusive mode only if it is not locked at all.

Keep practicing — related questions

  • In which of the following modes does the transaction require only to read the data item?
  • Two transactions are in which of the following mode, if they want to lock the same data item with shared an...
  • In _____________ mode/phase, the transaction only wants to read the data item.
  • In which of the following does a transaction need to edit data item?
  • By which of following phases are the locks only released?
  • In which of the following transaction's properties are either all or none of the transaction's operations p...
  • In which of the following is it possible to lock individual tuples?
  • Which of the following modes in lock table command of SQL allows queries but prohibits updates to a table?
Play the full quiz 🎤 Practise this topic out loud

Practice this topic

  • Database Management Systems (5344 questions)
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy