Home » MCQs » DBMS MCQs

DBMS Transaction MCQs

DBMS Transaction MCQs: This section contains multiple-choice questions and answers on Transaction in DBMS.
Submitted by Anushree Goswami, on April 06, 2022

1. An operation is part of a transaction if it is ___ related.

1. Logically
2. Analytically
3. Reasonably
4. None

Answer: A) Logically

Explanation:

An operation is part of a transaction if it is logically related.

Discuss this Question

---

2. To access the contents of the database, ___ user performs transactions.

1. Single
2. Two
3. Three
4. Multiple

Answer: A) Single

Explanation:

To access the contents of the database, a single user performs transactions.

Discuss this Question

---

3. How many operations of transactions are there?

1. 3
2. 4
3. 5
4. 6

Answer: B) 4

Explanation:

There are 4 operations of transactions.

Discuss this Question

---

4. Which of the following is an operation of transactions?

1. Read
2. Write
3. Commit
4. All of the above

Answer: D) All of the above

Explanation:

The operations of transactions are -

1. Read
2. Write
3. Commit
4. Rollback

Discuss this Question

---

5. X is read from a database and stored in a buffer in main memory with the ___ operation.

1. Read
2. Write
3. Commit
4. Rollback

Answer: A) Read

Explanation:

X is read from a database and stored in a buffer in main memory with the read operation.

Discuss this Question

---

6. Writing the data from the buffer back to the database is accomplished by using the _____ operation.

1. Read
2. Write
3. Commit
4. Rollback

Answer: B) Write

Explanation:

Writing the data from the buffer back to the database is accomplished by using the write operation.

Discuss this Question

---

7. ___ is used to permanently save the work.

1. Read
2. Write
3. Commit
4. Rollback

Answer: C) Commit

Explanation:

Commit is a tool used to permanently save the work.

Discuss this Question

---

8. An undo operation is called a ___.

1. Rollback
2. Commit
3. Write
4. Read

Answer: A) Rollback

Explanation:

An undo operation is called a rollback.

Discuss this Question

---

9. How many properties of transactions are there?

1. 4
2. 5
3. 6
4. 7

Answer: A) 4

Explanation:

There are 4 properties of transactions.

Discuss this Question

---

10. In a database, prior to and after a transaction, properties are used to ensure ___.

1. Consistency
2. Redundancy
3. Latency
4. Anonymity

Answer: A) Consistency

Explanation:

In a database, prior to and after a transaction, properties are used to ensure consistency.

Discuss this Question

---

11. Which of the following is a property of transaction?

1. Atomicity
2. Consistency
3. Durability
4. All of the above

Answer: D) All of the above

Explanation:

The following are the properties of transactions -

1. Atomicity
2. Consistency
3. Isolation
4. Durability

Discuss this Question

---

12. ___ states that all operations of a transaction must occur simultaneously; otherwise, the transaction will be aborted.

1. Atomicity
2. Consistency
3. Isolation
4. Durability

Answer: A) Atomicity

Explanation:

Atomicity states that all operations of a transaction must occur simultaneously; otherwise, the transaction will be aborted.

Discuss this Question

---

13. What is TRUE about atomicity?

1. The transaction cannot be partially completed, since there is no midway.
2. In each transaction, either the entire transaction is executed or it is not.
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

In case of atomicity -

1. The transaction cannot be partially completed, since there is no midway.
2. In each transaction, either the entire transaction is executed or it is not.

Discuss this Question

---

14. How many operations does atomicity involve?

1. 1
2. 2
3. 3
4. 4

Answer: B) 2

Explanation:

Atomicity involves 2 operations.

Discuss this Question

---

15. Which of the following is an operation in atomicity?

1. Abort
2. Commit
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

The operations in the atomicity are -

1. Abort
2. Commit

Discuss this Question

---

16. Transactions that are ___ do not expose all changes.

1. Committed
2. Rollbacked
3. Aborted
4. None of the above

Answer: C) Aborted

Explanation:

Transactions that are aborted do not expose all changes.

Discuss this Question

---

17. All changes made in a transaction are ___ once it commits.

1. Visible
2. Not Visible
3. Broken
4. Not Broken

Answer: A) Visible

Explanation:

All changes made in a transaction are visible once it commits.

Discuss this Question

---

18. What is TRUE about Consistency?

1. As a result of integrity constraints, the database remains consistent before and after the transaction.
2. In most cases, a database remains either in its previous stable state or in a new stable state following the execution of a transaction.
3. Every transaction undergoes a consistent database instance, which is the consistent property of databases.
4. All of the above

Answer: D) All of the above

Explanation:

In case of consistency -

1. As a result of integrity constraints, the database remains consistent before and after the transaction.
2. In most cases, a database remains either in its previous stable state or in a new stable state following the execution of a transaction.
3. Every transaction undergoes a consistent database instance, which is the consistent property of databases.

Discuss this Question

---

19. Transactions allow the database to be transformed from ___.

1. One consistent state to another consistent state
2. One inconsistent state to another consistent state
3. One inconsistent state to another inconsistent state
4. One consistent state to another inconsistent state

Answer: A) One consistent state to another consistent state

Explanation:

Transactions allow the database to be transformed from one consistent state to another.consistent state.

Discuss this Question

---

20. What is TRUE about Isolation?

1. By using the data used during a transaction, the second transaction will not be able to use it until the first has been executed.
2. The data item X cannot be accessed by any other transaction T2 until the transaction T1 is completed and the data item X is used by the transaction T1.
3. It enforced the isolation property via its concurrency control subsystem.
4. All of the above

Answer: D) All of the above

Explanation:

In case of Isolation -

1. By using the data used during a transaction, the second transaction will not be able to use it until the first has been executed.
2. The data item X cannot be accessed by any other transaction T2 until the transaction T1 is completed and the data item X is used by the transaction T1.
3. It enforced the isolation property via its concurrency control subsystem.

Discuss this Question

---

21. A database's consistent state is measured by the ___ property.

1. Consistency
2. Rollback
3. Durability
4. Isolation

Answer: C) Durability

Explanation:

A database's consistent state is measured by the durability property.

Discuss this Question

---

22. A durable transaction is one that makes ___ changes.

1. Permanent
2. Temporary
3. Basic
4. Advanced

Answer: A) Permanent

Explanation:

A durable transaction is one that makes permanent changes.

Discuss this Question

---

23. What is TRUE about Durability?

1. The failure of the system or an error in a transaction cannot cause them to be lost.
2. A consistent state is reached when a transaction is completed.
3. System failures cannot lead to the loss of that consistent state.
4. All of the above

Answer: D) All of the above

Explanation:

In case of Durability -

1. The failure of the system or an error in a transaction cannot cause them to be lost.
2. A consistent state is reached when a transaction is completed.
3. System failures cannot lead to the loss of that consistent state.

Discuss this Question

---

24. The reliability property of a DBMS is managed by the ___ subsystem.

1. Recovery
2. Reliability
3. Property
4. Database

Answer: A) Recovery

Explanation:

The reliability property of a DBMS is managed by the recovery subsystem.

Discuss this Question

---

---