1Z0-082 practice question 15 of 25

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.)

Full set: 142 questions
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 Correct answer
E: It is a locally managed tablespace Correct answer
Correct Answer:
D. It uses the database default blocksize; E. It is a locally managed tablespace
Explanation

The CREATE TABLESPACE statement does not include the BLOCKSIZE clause, so the tablespace will use the database's default block size, defined by the DBBLOCKSIZE parameter. The clause SEGMENT SPACE MANAGEMENT AUTO specifies that the tablespace will use Automatic Segment Space Management (ASSM). A tablespace that uses ASSM must be a locally managed tablespace. Since Oracle Database 10g, locally managed tablespaces are the default, and this clause confirms this configuration.

Why Incorrect

A. A smallfile tablespace's total size is the sum of its datafiles and can exceed a bigfile tablespace's size.
B. SEGMENT SPACE MANAGEMENT AUTO uses bitmaps to manage free space, not freelists, which are used in manual segment space management.
C. The SIZE 5G clause applies only to the initial datafile. Subsequent datafiles added to this tablespace can have different sizes.

References

1. Oracle Database SQL Language Reference

19c. "CREATE TABLESPACE". The documentation states that omitting the BLOCKSIZE clause causes the tablespace to use the standard database block size.

2. Oracle Database Concepts

19c. Chapter 13

"Logical Storage Structures"

Section "Locally Managed Tablespaces". It explains that SEGMENT SPACE MANAGEMENT AUTO is a property of locally managed tablespaces.

3. Oracle Database Administrator's Guide

19c. Chapter 13

"Managing Tablespaces"

Section "Creating Tablespaces". This section confirms that locally managed is the default and describes the behavior of the BLOCKSIZE clause.

Scroll to Top