Which statements are true regarding the USERS tablespace? (Choose all that apply.)
See the Exhibit:
A.
A bitmap is used to record free extents
B.
Free extents information is managed within the tablespace
C.
Free extents information is managed in the SYSAUX tablespace
D.
The data dictionary tables are updated when extents are allocated or deallocated
Exhibit not showing
Use mozilla browser to see the exhibits.
Chrome also works.
D is also correct.
Here is why ….
SQL> conn SYSTEM/yeahright
Connected.
SQL> CREATE TABLE newtab(c1 date) TABLESPACE newtbs;
Table created.
SQL> ALTER TABLE newtab DEALLOCATE UNUSED;
Table altered.
SQL> SELECT extent_id, bytes from DBA_EXTENTS WHERE OWNER=’SYSTEM’ AND SEGMENT_NAME=’NEWTAB’;
EXTENT_ID BYTES
———- ———-
0 65536
SQL> ALTER TABLE newtab ALLOCATE EXTENT;
Table altered.
SQL> SELECT extent_id, bytes from DBA_EXTENTS WHERE OWNER=’SYSTEM’ AND SEGMENT_NAME=’NEWTAB’;
EXTENT_ID BYTES
———- ———-
0 65536
1 65536
SQL> ALTER TABLE newtab DEALLOCATE UNUSED;
Table altered.
SQL> SELECT extent_id, bytes from DBA_EXTENTS WHERE OWNER=’SYSTEM’ AND SEGMENT_NAME=’NEWTAB’;
EXTENT_ID BYTES
———- ———-
0 65536
USERS (default users tablespace created)
SYSAUX is a secondary tablespace for storage of a number of database components that were previously stored in the SYSTEM tablespace. It is created as a locally managed tablespace using automatic segment space management
Oracle DB uses bitmap management segment in free space .
Bitmap describes the status of each data block segment , the state and the amount of space blocks can be inserted into the relevant row