Ask a Question

A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by

in Education by
A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by (a) Buffer (b) Catalog (c) Storage (d) Secondary storage This question was addressed to me by my school principal while I was bunking the class. This interesting question is from Database Buffer in portion Storage and File Structures of Database Management

1 Answer

0 votes
by
Right answer is (a) Buffer Best explanation: There is always a copy kept on disk of every block, but the copy on disk may be a version of the block older than the version in the buffer.

Related questions

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: 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: How can I fix this? " HEAP CORRUPTION DETECTED after normal block.. CRT detected that the application wrote to memory after end of heap buffer "
    I had a program working good (without prompting errors) using references, but I decided to use a pointer-to-pointer array ... that it is there because I have put two flags (cout...
asked Apr 6, 2022 in Education by JackTerrance
0 votes
Q: Land reforms were a major development goal in India after independence.
    State whether the following statement are true or false with reasons. Land reforms were a major development ... after independence. Select the correct answer from above options...
asked Aug 3, 2022 in Education by JackTerrance
0 votes
Q: numbers.4. (a) When running a particular program with Nmemory accesses, a computer with a cacheand paged virtual memory generates atotal of M cache misses and F page faults.Ti is the time for a cache hit; T2 is thetime for a main memory hit and T3 is thetime to load a page into main memoryfrom the disk.(i) What is the cache hit ratio ?(ii) What is the main memory hit ratio ?That is, what percentage of mainmemory accesses do not generate apage fault?(iii) What is the overall effective accessOtime for the system ?
    numbers. 4. (a) When running a particular program with N memory accesses, a computer with a cache and paged ... the system ? cribe Select the correct answer from above options...
asked Dec 6, 2021 in Education by JackTerrance
0 votes
Q: c) A computer system was designed to have a good latest processor and I/Odevices, however the designer of the computer did not put any RAM in it.The computer does have a hard disk of 1 tera-byte. Will this computer be
    c) A computer system was designed to have a good latest processor and I/O devices, however the designer of the ... in support of your Select the correct answer from above options...
asked Nov 28, 2021 in Education by JackTerrance
0 votes
Q: Which level of RAID refers to disk mirroring with block striping?
    Which level of RAID refers to disk mirroring with block striping? (a) RAID level 1 (b) RAID level ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Which level of RAID refers to disk mirroring with block striping?
    Which level of RAID refers to disk mirroring with block striping? (a) RAID level 1 (b) RAID level ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Which of the following is the block that is not permitted to be written back to the disk?
    Which of the following is the block that is not permitted to be written back 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: A block that is not allowed to be written back to disk is said to be ______________
    A block that is not allowed to be written back to disk is said to be ______________ (a) Pinned (b) ... Buffer topic in chapter Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: __________ is increasingly being used in server systems to improve performance by caching frequently used data, since it provides faster access than disk, with larger storage capacity than main memory.
    __________ is increasingly being used in server systems to improve performance by caching frequently used data, ... in portion Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: The current copy of the database is identified by a pointer, called ____________ which is stored on disk.
    The current copy of the database is identified by a pointer, called ____________ which is stored on disk. ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Which factors are affected favourably or unfavourably by climate? What must we do to minimize the effect?
    Which factors are affected favourably or unfavourably by climate? What must we do to minimize the ... Science proposed by,electromagnetic theory engineering physics,Science nptel...
asked Nov 7, 2021 in Education by JackTerrance
0 votes
Q: When a function is defined then the system stores parameters and local variables in an area of memory. What this memory is known as?
    When a function is defined then the system stores parameters and local variables in an area of memory. What this memory is known as?...
asked Nov 26, 2020 in Technology by JackTerrance

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

...