Ask a Question

__________ scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk.

in Education by
__________ scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk. (a) Fuzzy logic (b) Checkpoints (c) Fuzzy-checkpoint (d) Logical checkpoint I had been asked this question by my college director while I was bunking the class. My query is from ARIES topic in section Recovery System of Database Management

1 Answer

0 votes
by
Right option is (c) Fuzzy-checkpoint Best explanation: It flushes dirty pages in the background, continuously, instead of writing them during checkpoints.

Related questions

0 votes
Q: ___________ determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.
    ___________ determines which transactions to undo, which pages were dirty at the time of the crash, and ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: A __________ is the smallest unit of information that can be read from or written to the disk.
    A __________ is the smallest unit of information that can be read from or written to the disk. (a) ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: There are “record-once” versions of the compact disk and digital video disk, which can be written only once; such disks are also called __________ disks.
    There are record-once versions of the compact disk and digital video disk, which can be written only once ... Media in portion Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: The ___________ policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed.
    The ___________ policy, allows the system to write modified blocks to disk even if the transactions that ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: There are situations in which it is necessary to write back the block to disk, even though the buffer space that it occupies is not needed. This write is called the
    There are situations in which it is necessary to write back the block to disk, even though the buffer ... Buffer in chapter Storage and File Structures 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: An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.
    An Oracle __________ is a set of tables and views that are used as a read-only reference about the ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The ____________ scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.
    The ____________ scheme uses a page table containing pointers to all pages; the page table itself and all ... is from Recovery in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Answers require a reason. We may evaluate only those answers that have a proper reason!!???
    Answers require a reason. We may evaluate only those answers that have a proper reason!!??? Which type of buffer ... based 4.Heap-based Select the correct answer from above options...
asked Dec 2, 2021 in Education by JackTerrance
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: ___________________ is the method used to locate all the DNS-servers and their associated records for an organization.
    ___________________ is the method used to locate all the DNS-servers and their associated records for an organization. (a ... questions and answers pdf, mcq on Cyber Security pdf,...
asked Nov 4, 2021 in Education by JackTerrance
0 votes
Q: Rails create or update for associated records
    I have this example code which raises a "Duplicate Expection". Instead, I want just to skip if a duplicate exists. (1..10).each do |page| group.products...
asked May 26, 2022 in Education by JackTerrance
0 votes
Q: Rails, polymorphic association - find records with non-dead associated records
    I have following Comments-on-Models design (source: http://railscasts.com/episodes/154-polymorphic-association): ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 18, 2022 in Education by JackTerrance

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

...