Oracle Database Administration I — Question 169

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

SIZE 5G -
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

Answer options

• A. It must be smaller than the smallest BIGFILE tablespace
• B. Free space is managed using freelists
• C. Any data files added to the tablespace must have a size of 5 gigabytes
• D. It uses the database default blocksize
• E. It is a locally managed tablespace

Correct answer: D, E

Explanation

The correct answer is D and E because locally managed tablespaces automatically manage space with bitmaps, which is indicated by the SEGMENT SPACE MANAGEMENT AUTO clause. Additionally, the default block size is used unless specified otherwise. Options A, B, and C are incorrect as they do not apply to SMALLFILE tablespaces; SMALLFILE tablespaces can coexist with BIGFILE tablespaces and do not require freelists or fixed data file sizes.