Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?

You are designing an application for Pass4sures.com and you have been asked to design a
database table to facilitate monthly bill generation. The bill would include details of customer
calls, listed in chronological order. Which method would you follow to achieve this objective
without increasing the overhead of sorting the rows?

You are designing an application for Pass4sures.com and you have been asked to design a
database table to facilitate monthly bill generation. The bill would include details of customer
calls, listed in chronological order. Which method would you follow to achieve this objective
without increasing the overhead of sorting the rows?

A.
create a hash cluster to store the data

B.
create an index cluster to store the data

C.
create a partitioned table to store the data

D.
create a sorted hash cluster to store the data

E.
create a heap table with rowid to store the data



Leave a Reply 0

Your email address will not be published. Required fields are marked *