Ask a Question

Each modification done in database transaction are first recorded into the

in Education by
Each modification done in database transaction are first recorded into the (a) Harddrive (b) Log (c) Disk (d) Datamart I got this question in an interview. This is a very interesting question from Transaction Atomicity and Durability topic in division 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
The correct choice is (b) Log The best explanation: After commit is issued the data are stored in a database and stored in drive.

Related questions

0 votes
Q: In the ___________ scheme, a transaction that wants to update the database first creates a complete copy of the database.
    In the ___________ scheme, a transaction that wants to update the database first creates a complete copy ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Modification in Dundas BI is done ______________
    Modification in Dundas BI is done ______________ (a) Directly (b) Indirectly (c) Need access to Server (d) ... Started of R Programming Select the correct answer from above options...
asked Feb 13, 2022 in Education by JackTerrance
0 votes
Q: A die is thrown twice. Each time the number appearing on it is recorded. Describe the following events:
    A die is thrown twice. Each time the number appearing on it is recorded. Describe the following events: (i ... are mutually exclusive? Select the correct answer from above options...
asked Nov 22, 2021 in Education by JackTerrance
0 votes
Q: Immediate database modification technique uses
    Immediate database modification technique uses (a) Both undo and redo (b) Undo but no redo (c) Redo ... Undo Operations topic in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: In case of any shut down during transaction before commit which of the following statement is done automatically?
    In case of any shut down during transaction before commit which of the following statement is done ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
    If an transaction is performed in a database and committed, the changes are taken to the previous state ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Which of the following makes the transaction permanent in the database?
    Which of the following makes the transaction permanent in the database? (a) View (b) Commit (c) ... Answers, 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: A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a
    A lock that prevents the use of any tables in the database from one transaction while another ... Multiversion Schemes in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
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: _______ 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: _______ 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: The __________ requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.
    The __________ requires that each transaction Ti executes in two or three different phases in its lifetime ... topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Developments, corrections, and repairs are recorded in tasks and transported using ___________.
    Developments, corrections, and repairs are recorded in tasks and transported using ___________. A. Transport Request B. SAP architecture C. Transport Organizer D. Change request...
asked Feb 20, 2023 in Technology by JackTerrance
0 votes
Q: A die has its six faces marked 0, 1, 1, 1, 6, 6. Two such dice are thrown together and the total score is recorded.
    A die has its six faces marked 0, 1, 1, 1, 6, 6. Two such dice are thrown together and the total score is ... of getting a total of 7? Select the correct answer from above options...
asked Nov 21, 2021 in Education by JackTerrance

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

...