Ask a Question

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

in Education by
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) One Safe (b) Two Safe (c) Two-very Safe (d) Very Safe I have been asked this question during an online exam. The doubt is from Remote Backup Systems in division 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
Right answer is (c) Two-very Safe Easiest explanation - The problem with this scheme is that transaction processing cannot proceed if either the primary or the backup site is down.

Related questions

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 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: Remote backup system must be _________ with the primary site.Select the correct answer from above options
    Remote backup system must be _________ with the primary site. (a) Synchronised (b) Separated (c) ... Backup Systems topic in chapter Recovery System of Database Management...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The simplest way of transferring control is for the old primary to receive __________ from the old backup site.
    The simplest way of transferring control is for the old primary to receive __________ from the old backup site ... Systems topic in division Recovery System of Database Management...
asked Oct 10, 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: A _______________ configuration can make takeover by the backup site almost instantaneous.
    A _______________ configuration can make takeover by the backup site almost instantaneous. (a) Hot-spare (b ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The remote backup site is sometimes also called the
    The remote backup site is sometimes also called the (a) Primary Site (b) Secondary Site (c) Tertiary ... Backup Systems topic in division Recovery System of Database Management...
asked Oct 10, 2021 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

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

...