aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Database Management System
  • What are the preventive measures to be taken if we have b...
Multiple choice

What are the preventive measures to be taken if we have begun an update operation to avoid dead lock?

  1. Lock the database

  2. Change the password

  3. Lock all the rows or tables

  4. Lock one row

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

By locking the database it makes it unsharable and nobody can share it.

Keep practicing — related questions

  • One common approach of preventing deadlocks, before beginning an update is ________.
  • In a multi-user database, if two users wish to update the same record at the same time, they are prevented by
  • In a multi-user database, if two users wish to update the same record at the same time, they are prevented by
  • The transaction control that prevents more than one user from updating data in a table is which of the foll...
  • For which of the following database objects can locks NOT be obtained?
  • Which of the following commands or statements is used to recover from dead lock situation?
  • In which of the following locks in DBMS is only one user permitted to update a specific part of data?
  • When is a lock in database used?
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