Upgrade Oracle DBA 11g to Oracle Database 12c — Question 21

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?

Answer options

• A. a hash cluster
• B. an index cluster
• C. a partitioned table
• D. a sorted hash cluster
• E. a heap table with a rowid column

Correct answer: B

Explanation

The correct answer is B, an index cluster, as it allows for the organization of data in a way that supports quick retrieval based on indexed columns, thus minimizing sorting. Options A and D, while beneficial for other use cases, do not provide the same level of efficiency for this specific need, and C and E do not inherently support the required ordering for billing without additional processing.