Ask a Question

There are special redo-only log records generated during transaction rollback, called _________ in ARIES.

in Education by
There are special redo-only log records generated during transaction rollback, called _________ in ARIES. (a) Compensation log records (b) Read log records (c) Page log records (d) Redo log records The question was asked during an internship interview. Asked question is from ARIES in division Recovery System of Database Management

1 Answer

0 votes
by
The correct option is (a) Compensation log records The best I can explain: These serve the same purpose as the redo-only log records in our earlier recovery scheme.

Related questions

0 votes
Q: ARIES uses a ___________ to identify log records, and stores it in database pages.
    ARIES uses a ___________ to identify log records, and stores it in database pages. (a) Log sequence ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: What do you understand by Redo Log file mirroring?
    What do you understand by Redo Log file mirroring?...
asked Dec 18, 2020 in Technology by JackTerrance
0 votes
Q: Which of the following is used to rollback a JDBC transaction?
    Which of the following is used to rollback a JDBC transaction? (a) rollback() (b) rollforward() (c) ... & JDBC of Java Select the correct answer from above options...
asked Feb 22, 2022 in Education by JackTerrance
0 votes
Q: Which of the following is used to rollback a JDBC transaction?
    Which of the following is used to rollback a JDBC transaction? (a) rollback() (b) rollforward() ( ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Oct 24, 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: The only metadata retained on a per-consumer basis is the position of the consumer in the log, called ________.
    The only metadata retained on a per-consumer basis is the position of the consumer in the log, called ________....
asked Nov 16, 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: 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: _______ 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 order of log records in the stable storage ____________ as the order in which they were written to the log buffer.
    The order of log records in the stable storage ____________ as the order in which they were written to ... of Buffer Management in portion Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Before a block of data in main memory can be output to the database, all log records pertaining to data in that block must have been output to stable storage. This is
    Before a block of data in main memory can be output to the database, all log records pertaining to ... Buffer Management topic in chapter Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ­­­­­­__________ on all the records belonging to that file.
    If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ... Based Protocols topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance

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

...