Table Space Fragmentation -Quiz

RelationalDBDesign		Home Search SiteMap
Advanced SQL Basic SQL DB Creation Architect Extended DB Features Managing DB Objects Oracle Net Topology
PL/SQL Programming SQL Tuning Database Analysis Database Design Oracle 8i PL/SQL PL/SQL Objects

Table Space Fragmentation -Quiz

Select the best answer or answers for each question.

1.	Which SQL command can be used to reduce the holes in a tablespace caused by different sized extents? Please select the best answer.
	A.	`ALTER TABLESPACE tablespace_name COMPRESS`
	B.	`ALTER TABLESPACE tablespace_name COALESCE`
	C.	`ALTER TABLESPACE tablespace_name COALESCE PCTFREE 20 PCTUSED 60`
	D.	`ALTER TABLESPACE COALESCE`

2.	What are the effects of tablespace fragmentation? Please select all the correct answers.
	A.	Rows in the tablespace are different sizes.
	B.	Extents in the tablespace are different sizes.
	C.	Disk space in the tablespace is wasted.
	D.	I/O performance is slower.

3.	How can you avoid tablespace fragmentation? Please select the best answer.
	A.	Frequently `COALESCE` the tablespace
	B.	Use large extent sizes for the tablespace
	C.	Use small extent sizes for the tablespace
	D.	Use one extent size for all the extents in the tablespace