Oracle Database 12c: Advanced Administration — Question 34

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, because it allows for efficient retrieval of data in the order of insertion, which is ideal for generating bills with call details. The other options either do not support ordered retrieval efficiently (like a hash cluster or heap table) or are not specifically designed for this purpose (like a partitioned table).