Oracle Database 12c: Installation and Administration — Question 166

Examine the command:

SQL> CREATE TABLESPACE test1 -
DATAFILE '/u01/app/oracle/oradata/orc1/test01.dbf' SIZE 5M
AUTOEXTEND ON UNIFORM;
Which statement is true?

Answer options

• A. The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.
• B. The tablespace, TEST1, can contain a maximum of one data file.
• C. Allocated and free extents are tracked using bitmaps.
• D. Segment free space is tracked in the data dictionary.

Correct answer: C

Explanation

The correct answer is C because Oracle uses bitmaps to manage allocated and free extents within a tablespace. Option A is incorrect since the data file can auto-extend beyond 5M if not limited by another factor. Option B is wrong as a tablespace can contain multiple data files. Option D is also incorrect since segment free space is specifically managed in the segment header, not solely in the data dictionary.