Question

In which state the transaction will wait for the final statement has been executed​

Answer 1

Answer:

Please mark as brainliest answer

Explanation:

2. Partially Committed State- After the last instruction of transaction has executed, it enters into a partially committed state. After entering this state, the transaction is considered to be partially committed.

Answer 2

In the partially committed state the transaction will wait for the final statement has been executed​.

• When all parts of a database transaction have been completed, the RDBMS appears to enter a partially committed state, indicating that it has logically committed to continuing the modifications to the database but has not yet completed so.
• The modifications are made in the primary storage or local buffer after all operations have been performed.
• When changes are made to the Data warehouse securely, the state changes to the committed state, and when they fail, it switches to the failed state.
• A transaction completes its last operation while in the partially committed state, however, the records still aren't stored in the data warehouse.

For more information on Types of State of Transaction in a database, refer to these answers:

https://brainly.in/question/8973989

https://brainly.in/question/9144886

#SPJ3