Practice mode DBMS and SQL

In the transaction state model, what is the state of a transaction after its final statement has executed but before its commit has completed?

Correct answer B. Partially committed

Explanation

A transaction is active while it executes its statements. After the last statement it becomes partially committed: the work is done but the changes may still be only in memory, so a failure could force an abort. Only after the commit is made durable, typically by writing the commit log record, does it enter the committed state. Failed means normal execution can no longer proceed.

Report a problem

Answer checked 12 October 2026 How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

In the transaction state model, what is the state of a transaction after its final statement has executed but before its commit has completed?

Discussion

Have a question about this answer? Cancel reply

In the transaction state model, what is the state of a transaction after its final statement has executed but before its commit has completed?

More DBMS and SQL questions

In table OrderItem(order_id, product_id, quantity), neither order_id nor product_id is unique alone, so the primary key is declared as (order_id, product_id). What is such a key called?

Table Student(roll_no, cnic, email, name) has roll_no, cnic and email each unique and never NULL. If roll_no is chosen as the primary key, what are cnic and email called?

In a B+ tree index, where are the pointers to actual data records (or the records themselves) stored?

Which integrity rule states that no attribute of a primary key may contain NULL?

Discussion

Have a question about this answer? Cancel reply