What is the purpose of a transaction in a database?

Practice Questions

Q1
What is the purpose of a transaction in a database?
  1. To store data permanently
  2. To ensure data integrity
  3. To create backups
  4. To optimize queries

Questions & Step-by-Step Solutions

What is the purpose of a transaction in a database?
Correct Answer: Data integrity ko maintain karna.
  • Step 1: Understand that a database is like a digital filing cabinet where data is stored.
  • Step 2: Know that a transaction is a set of actions or operations that you want to perform on the data.
  • Step 3: Realize that the purpose of a transaction is to keep the data accurate and reliable.
  • Step 4: Learn that a transaction must either complete all its actions successfully or none at all.
  • Step 5: If one part of the transaction fails, the whole transaction is canceled to prevent errors.
  • Step 6: This process helps maintain data integrity, meaning the data remains correct and consistent.
No concepts available.
Soulshift Feedback ×

On a scale of 0–10, how likely are you to recommend The Soulshift Academy?

Not likely Very likely