Oracle
1Z0-067 · Question #43
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…
The correct answer is B. an index cluster. The table is not static, but instead is continually growing. If a table grows without limit, the space required over the life of the table (its cluster) cannot be predetermined.
New Features for Storage
Question
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?
Options
- Aa hash cluster
- Ban index cluster
- Ca partitioned table
- Da sorted hash cluster
- Ea heap table with a rowid column
How the community answered
(41 responses)- A2% (1)
- B76% (31)
- C7% (3)
- D2% (1)
- E12% (5)
Explanation
The table is not static, but instead is continually growing. If a table grows without limit, the space required over the life of the table (its cluster) cannot be predetermined.
Topics
#index cluster#sorted hash cluster#row ordering#table organization
Community Discussion
No community discussion yet for this question.