Database-MySQL [3i Infotech Placement]: Sample Questions 53 - 55 of 162

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 53

Edit

Write in Short

Short Answer▾

What are the primitive operations common to all record management systems?

Explanation

Addition, deletion and modification are the primitive operations common to all record management systems.

Question 54

Edit

Describe in Detail

Essay▾

What are the different phases of transaction?

Explanation

Understanding of 3 Phase of Transaction

Basically, 3 phase of transaction:

  • Analysis phase
  • Redo phase
  • Undo phase

Analysis phase:

  • Analysis phase is to find the best LSN starting from which rolling forward can be done during redo phase.

Redo:

  • Redo is the phase during which the changes caused by active transactions are hardened onto Data files.

Undo:

  • Undo is the phase where in, rolling back of the active transactions for consistency, takes place.

Question 55

Edit

Write in Short

Short Answer▾

What is meant by Proactive, Retroactive and Simultaneous Update.

Explanation

  • Proactive Update:
    • Applied to database before it becomes effective in real world.
  • Retroactive Update:
    • Applied to database after it becomes effective in real world.
  • Simultaneous Update:
    • Applied to database at the same time when it becomes effective in real world.

Developed by: