Question
a.
It stores related records of two or more relations in each block
b.
It stores related data about the relations in each block
c.
It links each and every block by introducing an external attribute
d.
None of the mentioned
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. What is a multitable clustering file organization?
Similar Questions
Discover Related MCQs
Q. Which of the following need to be stored in the data dictionary?
View solution
Q. The subsystem responsible for the allocation of buffer space is called as _______
View solution
Q. What is the full form of LRU (in buffer replacement strategy)?
View solution
Q. The _________ is the fastest and most costly form of storage, which is relatively small; its use is managed by the computer system hardware.
View solution
Q. Which of the following stores several gigabytes of data but usually lost when power failure?
View solution
Q. The flash memory storage used are
View solution
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.
View solution
Q. Which is the cheapest memory device in terms of costs/bit ?
View solution
Q. The primary medium for the long-term online storage of data is the __________ where the entire database is stored on magnetic disk.
View solution
Q. Optical disk _______ systems contain a few drives and numerous disks that can be loaded into one of the drives automatically (by a robot arm) on demand.
View solution
Q. There are “record-once” versions of compact disk and digital video disk, which can be written only once; such disks are also called __________ disks.
View solution
Q. Tape storage is referred to as __________ storage.
View solution
Q. In magnetic disk ________ stores information on a sector magnetically as reversals of the direction of magnetization of the magnetic material.
View solution
Q. A __________ is the smallest unit of information that can be read from or written to the disk.
View solution
Q. The disk platters mounted on a spindle and the heads mounted on a disk arm are together known as ___________
View solution
Q. The disk controller uses ________ at each sector to ensure that the data is not corrupted on data retrieval.
View solution
Q. _________ is the time from when a read or write request is issued to when data transfer begins.
View solution
Q. The time for repositioning the arm is called the ________ and it increases with the distance that the arm must move.
View solution
Q. _________ is around one-half of the maximum seek time.
View solution
Q. Once the head has reached the desired track, the time spent waiting for the sector to be accessed to appear under the head is called the _______________
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!