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? columns in ascending order, which can improve response time during subsequent operations on the clustered data.
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
Explanation:
D (Doubtful)
https://docs.oracle.com/cd/B19306_01/server.102/b14231/hash.htm#i1006536
In a sorted hash cluster, the rows corresponding to each value of the hash function are sorted on a specified set of