See the Exhibit:
Which statements are true regarding the USERS tablespace? (Choose all that apply.)
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
Correct Response: A and B
There are 2 types of segment space management
1.Manual
2.Auto
In manual segment space management MANUAL,Oracle will use freelists to manage free space within segments in the tablespace. Free lists are lists of data blocks that have space available for inserting rows.
SEGMENT SPACE MANAGEMENT AUTO tells Oracle to use bitmaps to manage free space within a segment. The bitmap structure stores information that describes the amount of space in the blocks that are available.
for row inserts.
conn SYSTEM/likeimgoingtoputithere
CREATE TABLE newtab(c1 date) TABLESPACE newtbs;
SELECT extent_id,bytes from DBA_EXTENTS WHERE OWNER=’SYSTEM’ AND SEGMENT_NAME=’NEWTAB’;
EXTENT_ID BYTES
———- ———-
0 65536
ALTER TABLE newtab ALLOCATE EXTENT;
SELECT extent_id,bytes from DBA_EXTENTS WHERE OWNER=’SYSTEM’ AND SEGMENT_NAME=’NEWTAB’;
EXTENT_ID BYTES
———- ———-
0 65536
1 65536
ALTER TABLE newtab DEALLOCATE UNUSED;
SELECT extent_id,bytes from DBA_EXTENTS WHERE OWNER=’SYSTEM’ AND SEGMENT_NAME=’NEWTAB’;
EXTENT_ID BYTES
———- ———-
0 65536
SELECT * FROM DICTIONARY WHERE TABLE_NAME LIKE ‘DBA_EXTENTS’;
TABLE_NAME
——————————
COMMENTS
———————————————–
DBA_EXTENTS
Extents comprising all segments in the database
So D is correct also. Right???
A and B