Ask a Question

A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is

in Education by
A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is (a) One Safe (b) Two Safe (c) Two-very Safe (d) Very Safe I have been asked this question in my homework. Question is from Remote Backup Systems in section Recovery System 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
Correct option is (a) One Safe The explanation is: The problem with this scheme is that the updates of a committed transaction may not have made it to the backup site, when the backup site takes over processing.

Related questions

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: 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: 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: 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: The transaction can no longer continue with its normal execution because of some internal condition, such as bad input, data not found, overflow, or resource limit exceeded. This is
    The transaction can no longer continue with its normal execution because of some internal condition, such ... topic in chapter Recovery System of Database Management...
asked Oct 10, 2021 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: Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the _______ field of the page.
    Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the _______ ... is from ARIES in section Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Delete commits from a branch in Git -Git delete commit
    I would like to know how to delete a commit. By delete, I mean it is as if I didn't make that commit, ... -hard HEAD. Is this correct? Select the correct answer from above options...
asked Feb 2, 2022 in Education by JackTerrance
0 votes
Q: What do you mean by commit log in Cassandra?
    What do you mean by commit log in Cassandra?...
asked Apr 15, 2021 in Technology by JackTerrance
0 votes
Q: Define commit log.
    Define commit log....
asked Dec 13, 2020 in Technology 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: ___________ is popular for applications such as storage of log files in a database system since it offers the best write performance.
    ___________ is popular for applications such as storage of log files in a database system since it offers the ... in division Storage and File Structures of Database Management...
asked Oct 10, 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: ______________ policy allows multiple updates to accumulate on a block before it is output to stable storage, which can reduce the number of output operations greatly for frequently updated blocks.
    ______________ policy allows multiple updates to accumulate on a block before it is output to stable storage, ... Management topic in chapter Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance

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

...