adplus-dvertising
frame-decoration

Question

What is a multitable clustering file organization?

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

Answer: (a).It stores related records of two or more relations in each block

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?

Q. The subsystem responsible for the allocation of buffer space is called as _______

Q. What is the full form of LRU (in buffer replacement strategy)?

Q. The _________ is the fastest and most costly form of storage, which is relatively small; its use is managed by the computer system hardware.

Q. Which of the following stores several gigabytes of data but usually lost when power failure?

Q. The flash memory storage used are

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.

Q. Which is the cheapest memory device in terms of costs/bit ?

Q. The primary medium for the long-term online storage of data is the __________ where the entire database is stored on magnetic disk.

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.

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.

Q. Tape storage is referred to as __________ storage.

Q. In magnetic disk ________ stores information on a sector magnetically as reversals of the direction of magnetization of the magnetic material.

Q. A __________ is the smallest unit of information that can be read from or written to the disk.

Q. The disk platters mounted on a spindle and the heads mounted on a disk arm are together known as ___________

Q. The disk controller uses ________ at each sector to ensure that the data is not corrupted on data retrieval.

Q. _________ is the time from when a read or write request is issued to when data transfer begins.

Q. The time for repositioning the arm is called the ________ and it increases with the distance that the arm must move.

Q. _________ is around one-half of the maximum seek time.

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 _______________