Which two assumptions must be true for this statement to execute successfully?

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

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.



Leave a Reply 0

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