Multiple choice

Examine the following SQL statement:

CREATE TABLESPACE user_data DATAFILE '/u01/oradata/userdata_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT;

Which part of the tablespace will be of a uniform size of 1 MB?

  1. Extent

  2. Segment

  3. Oracle block

  4. Operating system block

  5. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In a LOCALLY MANAGED tablespace with UNIFORM SIZE specification, each extent allocated within the tablespace will be exactly the uniform size specified (1 MB in this example). Segments are composed of multiple extents, Oracle blocks are smaller logical units within extents, and operating system blocks are the physical I/O units. The UNIFORM SIZE clause directly controls extent size allocation.

Keep practicing — related questions