You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.

A. Free space is managed using freelists.False. The SEGMENT SPACE MANAGEMENT AUTO clause specifies Automatic Segment Space Management (ASSM), which uses bitmaps to track free space, not freelists (used in Manual Segment Space Management).

B. It uses the database default block size.True. The BLOCKSIZE clause is not specified in the command, so the tablespace inherits the database’s default block size (typically 8K unless altered via DB_BLOCK_SIZE).

C. It must be smaller than the smallest BIGFILE tablespace.False. There’s no such restriction; SMALLFILE and BIGFILE tablespaces differ in structure (multiple vs. single data file), not mandated size relationships.

D. It is a locally managed tablespace.True. In Oracle 23ai, all tablespaces created without an explicit EXTENT MANAGEMENT DICTIONARY clause are locally managed by default, using extent allocation bitmaps in the data file headers.

E. Any data files added to the tablespace must have a size of 5 gigabytes.False. The initial data file is 5G, but additional data files can have different sizes when added using ALTER TABLESPACE ... ADD DATAFILE.