• Description:Database Fundamentals I
• Passing Score:75%
• Practice Test - Number of questions:456 questions
• Simulation Test - Number of questions:456 questions
• Simulation Test Duration:90 minutes
• Has explanations:Yes

You specified extent management as local for a tablespace. How will this affect space management in the tablespace?

Answer(s)

1. Bitmap will be used to record free and allocated extents.
2. Free extents will be managed by the data dictionary tables.
3. The tablespace can have extents containing blocks of different sizes.
4. The tablespace will be system managed and the users cannot specify the extent size.

Bitmap will be used to record free and allocated extents.