Prev Question
Next Question

Examine the statement:
SQL> CREATE TABLESPACE user_data
2> EXTENT MANAGEMENT LOCAL
3> SEGMENT SPACE MANAGEMENT AUTO;
Which two assumptions must be true for this statement to execute successfully? (Choose
two.)

A.
Oracle Managed Files are used for this instance.

B.
Space within segments in the USER_DATA tablespace is managed with freelists.

C.
The database will manage the free space of segments in thetablespace using a bitmap.

D.
The USER_DATAtablespace is managed using FET$/UET$ tables.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *