Oracle Free Diction - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1.	In modern Oracle databases, which segment space management method is normally preferred over manually managed freelists? Please select the best answer.
	A.	Dictionary-managed tablespaces with manually configured freelists
	B.	Locally managed tablespaces with Automatic Segment Space Management
	C.	Rollback segments with manually assigned freelist groups
	D.	Manual free-space tracking in `USER_TABLESPACES`

2.	Which statements correctly describe `PCTFREE`, `PCTUSED`, and modern segment space management? Please select all the correct answers.
	A.	`PCTFREE` reserves space in a block for future row growth and updates.
	B.	`PCTUSED` is mainly relevant to manual segment space management and freelist-managed segments.
	C.	With Automatic Segment Space Management, Oracle uses bitmaps to track block free space instead of relying on manual freelists.
	D.	`PCTUSED` and `FREELISTS` are the preferred tuning controls for new Oracle 23ai tablespaces.

3.	For a modern Oracle table with heavy insert and delete activity, what is usually the best space-management approach? Please select the best answer.
	A.	Use a locally managed tablespace with Automatic Segment Space Management and tune table-level settings such as `PCTFREE` only when workload evidence justifies it.
	B.	Manually configure `PCTUSED` slightly lower than `PCTFREE` for every table.
	C.	Set `PCTUSED` higher than `100 - PCTFREE` so more blocks are reused.
	D.	Disable automatic segment space management and rely on one freelist for all inserts.