nerdexam
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)
  • A
    2% (1)
  • B
    14% (6)
  • C
    7% (3)
  • D
    74% (31)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice