Multiple choice technology databases

CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_01.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. Segement

  3. Oracle block

  4. Operating system block
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The UNIFORM SIZE 1M clause sets the extent size to 1 MB uniformly across the tablespace. Each extent allocated will be exactly 1 MB, not the segment, block, or OS block. SEGMENT is the collection of extents. Oracle block is the smallest unit of I/O (typically 8KB). OS block is managed by the operating system.

Keep practicing — related questions