IBM
C2090-558 · Question #7
You are about to create and load a table that will initially have a size of 50,000 KB. Once the table has been loaded, there will be very few additional inserts or updates to the table. When you…
The correct answer is C. EXTENT SIZE 50000 NEXT SIZE 1000. See the full explanation below for the reasoning.
Question
You are about to create and load a table that will initially have a size of 50,000 KB. Once the table has been loaded, there will be very few additional inserts or updates to the table. When you create the table, which of the following extent size definitions would make the most effective use of disk space over time?
Options
- AEXTENT SIZE 75000 NEXT SIZE 0
- BEXTENT SIZE 1000 NEXT SIZE 50000
- CEXTENT SIZE 50000 NEXT SIZE 1000
- DEXTENT SIZE 50000 NEXT SIZE 50000
How the community answered
(25 responses)- A4% (1)
- B12% (3)
- C76% (19)
- D8% (2)
Community Discussion
No community discussion yet for this question.