Ask a Question

In case of any shut down during transaction before commit which of the following statement is done automatically?

in Education by
In case of any shut down during transaction before commit which of the following statement is done automatically? (a) View (b) Commit (c) Rollback (d) Flashback The question was asked by my college director while I was bunking the class. This is a very interesting question from Transactions in portion SQL : Queries, Constraints and Triggers 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
The correct choice is (c) Rollback Explanation: Once a transaction has executed commit work, its effects can no longer be undone by rollback work.

Related questions

0 votes
Q: Which station has the higher Probability to shut down?
    An inspector of the Alaska Pipeline has the task of comparing the reliability of two pumping stations. Each station ... shut down? Select the correct answer from above options...
asked Nov 19, 2021 in Education by JackTerrance
0 votes
Q: How to cleanly shut down an Android paho MQTT service?
    I have an Android paho MQTT client that listens for sensor data and alerts the user in case of any ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 7, 2022 in Education by JackTerrance
0 votes
Q: A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site. This is
    A transaction commits as soon as its commit log record is written to stable storage at the primary and ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is
    A transaction commits as soon as its commit log record is written to stable storage at the primary site. ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The _______________ policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.
    The _______________ policy, allows a transaction to commit even if it has modified some blocks that have ... Buffer Management in chapter Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: How do I undo 'git add' before commit?
    How do I undo 'git add' before commit?...
asked Jan 7, 2021 in Technology by JackTerrance
0 votes
Q: _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
    _______ means that data used during the execution of a transaction cannot be used by a second transaction ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: There are special redo-only log records generated during transaction rollback, called _________ in ARIES.
    There are special redo-only log records generated during transaction rollback, called _________ in ARIES. (a) ... from ARIES in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
    _______ means that data used during the execution of a transaction cannot be used by a second transaction ... Schemes topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: During which stage of the continuous delivery pipeline should features be verified in production before the business need them?
    During which stage of the continuous delivery pipeline should features be verified in production before the business need them?...
asked Nov 28, 2020 in Technology by JackTerrance
0 votes
Q: Before and during the processing the data is stored on1 registers
    Before and during the processing the data is stored on 1 registers 2 cache Select the correct answer from above options...
asked Dec 17, 2021 in Education by JackTerrance
0 votes
Q: __________ starts from a position determined during analysis, and performs a redo, repeating history, to bring the database to a state it was in before the crash.
    __________ starts from a position determined during analysis, and performs a redo, repeating history, to ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: How to run the clean plugin automatically during the build?
    How to run the clean plugin automatically during the build?...
asked May 4, 2021 in Technology by Editorial Staff
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.

...