Question

Blocks/pages are units of both storage allocation and data transfer.

True

False

-------------------------------------

While clustering of records from two or more tables can enhance the performance of some join queries, other queries may see diminished performance.

True

False

----------------------------

databases are too large to fit on the main Memory so they are stored on the magnetic disk

True

False

----------------

Answer 1

1 Blocks/pages are units of both storage allocation and data transfer.

True

Explanation: Block/Pages is the Files in the database is divided into some fixed-length storage units  Blocks/pages are units of both storage allocation and data transfer.

2 While clustering of records from two or more tables can enhance the performance of some join queries, other queries may see a diminished performance.

True

Explanation: Clustering enhances the performance of queries that access data sequentially because fewer I/Os need to be issued to retrieve the same data.

3 Databases are too large to fit on the main Memory so they are stored on the magnetic disk

True

Explanation: They are normally too huge to even consider fitting in the main memory. Additionally, they have to store information that must continue after some time. We prefer secondary storage devices, e.g., magnetic disks

Data stored as magnetized areas on magnetic disk surfaces. Disks are isolated into concentric round tracks on each disk surface. A track is partitioned into littler blocks because it, as a rule, contains a lot of information. The division of a track into blocks is hard-coded on the disk surface. A part of a track that subtends a fixed angle at the center as a block. This angle can be fixed or decrease as we move outward.