Ask a Question

If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by

in Education by
If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by (a) Flashback (b) Rollback (c) Both Flashback and Rollback (d) Cannot be done I got this question in an interview for job. This interesting question is from Transaction Atomicity and Durability topic in chapter Transactions of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
Right choice is (d) Cannot be done The best I can explain: Once committed the changes cannot be rolled back.

Related questions

0 votes
Q: If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.
    If a transaction does not modify the database until it has committed, it is said to use the ___________ ... from Recovery topic in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: ___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
    ___________ refers to the ability of the system to recover committed transaction updates if either the system ... in chapter Query Processing Techniques of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: You can cancel the previous action performed by clicking on the _______ button from __________
    You can cancel the previous action performed by clicking on the _______ button from __________ Select the correct answer from above options...
asked Dec 6, 2021 in Education by JackTerrance
0 votes
Q: You can cancel the previous action performed by clicking on the _______ button from __________
    You can cancel the previous action performed by clicking on the _______ button from __________ Select the correct answer from above options...
asked Dec 5, 2021 in Education by JackTerrance
0 votes
Q: You can cancel the previous action performed by clicking on the _______ button from __________
    You can cancel the previous action performed by clicking on the _______ button from __________ Select the correct answer from above options...
asked Nov 26, 2021 in Education by JackTerrance
0 votes
Q: What is the Git command to blow away all the changes in a file in the working area, since the previous commit?
    What is the Git command to blow away all the changes in a file in the working area, since the previous commit? A. ... git log filename C. git checkout filename D. git rm filename...
asked Dec 21, 2022 in Technology by JackTerrance
0 votes
Q: Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is
    Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: What changes have taken place in the nature of political parties in India?
    What changes have taken place in the nature of political parties in India? Please answer the above question....
asked Aug 14, 2022 in Education by JackTerrance
0 votes
Q: For a transaction to be durable, its changes need to be written to ________ storage.
    For a transaction to be durable, its changes need to be written to ________ storage. (a) Volatile storage ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
    A system is in a ______ state if there exists a set of transactions such that every transaction in the ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: If database modifications occur while the transaction is still active, the transaction is said to use the ___________technique.
    If database modifications occur while the transaction is still active, the transaction is said to use the ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The ___________ policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed.
    The ___________ policy, allows the system to write modified blocks to disk even if the transactions that ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Returning empty tk Entry box to previous state when clicked away from
    I'm currently developing my first python program, a booking system using tkinter. I have a customer account ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 9, 2022 in Education by JackTerrance
0 votes
Q: The system has entered an undesirable state (for example, deadlock), as a result of which a transaction cannot continue with its normal execution. This is
    The system has entered an undesirable state (for example, deadlock), as a result of which a ... Failure Classification in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Each modification done in database transaction are first recorded into the
    Each modification done in database transaction are first recorded into the (a) Harddrive (b) Log (c) Disk ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...