• Description: Compaq/Oracle 8i I&P with Windows NT
• Passing Score: 75%
• Practice Test - Number of questions: 117 questions
• Simulation Test - Number of questions: 117 questions
• Simulation Test Duration: 90 minutes
• Has explanations: No

Which statement is true?

Answer(s)

1. It is not necessary to physically separate tables from their indexes because Oracle accessesthe index first, then the table.
2. Because Oracle accesses the table and its index concurrently, it is best to physicallyseparate the two.
3. Hash partitioning divides the table into partitions based on a range of values for one of itscolumns.
4. Creating striped tables with Oracle is impossible because Oracle always fills up the currentdata file before allocating space in another one.

It is not necessary to physically separate tables from their indexes because Oracle accessesthe index first, then the table.