Oracle
1Z0-043 · Question #77
You are designing an application for certkiller.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…
The correct answer is D. create a sorted hash cluster to store the data. See the full explanation below for the reasoning.
Question
You are designing an application for certkiller.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?
Options
- Acreate a hash cluster to store the data
- Bcreate an index cluster to store the data
- Ccreate a partitioned table to store the data
- Dcreate a sorted hash cluster to store the data
- Ecreate a heap table with rowid to store the data
How the community answered
(42 responses)- A2% (1)
- B14% (6)
- C7% (3)
- D74% (31)
- E2% (1)
Community Discussion
No community discussion yet for this question.