52.7k views
1 vote
Which table type interleaves rows of two or more tables in the same storage area?

a.
Heap tables

b.
Table clusters

c.
Hash tables

d.
Sorted tables

User Sergeant
by
8.4k points

1 Answer

2 votes

Final answer:

Table clusters are the type of table that interleaves rows of two or more tables within the same storage area, leading to faster data retrieval for related rows.

Step-by-step explanation:

The type of table that interleaves rows of two or more tables in the same storage area is known as table clusters. Unlike heap tables that do not have any specific order and store data randomly, table clusters save related rows together based on common columns. Therefore, data retrieval for related rows is much faster. Hash tables use a hash function to directly compute the address where a record should be stored, making the data access speed very fast for individual records, but they do not interleave rows of multiple tables. Sorted tables, as suggested by the name, store data in a sorted order based on one or more columns, which is different from the interleaving of rows done in table clusters.

User Kaito Kid
by
7.6k points