Oracle Execution Plan Techniques - Quiz

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

1.	What is true about bitmap indexes in Oracle? Please select the best answer.
	A.	Bitmap indexes are best when the indexed column has a high number of distinct values.
	B.	A bitmap index stores bitmaps that identify which rows correspond to each indexed key value.
	C.	Bitmap indexes are intended to replace B-tree indexes in modern Oracle databases.
	D.	Bitmap indexes are only suitable for data warehouse applications.

2.	Which of the following are differences between a star query technique and a star transformation query plan? Please select all the correct answers.
	A.	A traditional star query technique can build intermediate row sets in memory, while star transformation may use temporary segments for intermediate results.
	B.	Star transformation is most effective when bitmap access paths on fact-table join columns reduce the candidate row set substantially.
	C.	Star and star transformation techniques can only be used with a separate Oracle Data Warehouse option.
	D.	A traditional star query technique requires bitmap indexes, while star transformation requires a concatenated index.

3.	Which of the following are true about function-based indexes? Please select all the correct answers.
	A.	Oracle built-in SQL functions may be used in a function-based index expression.
	B.	User-defined functions may be included in a function-based index definition when they meet Oracle requirements.
	C.	A function-based index can store the result of a transformation or expression based on one or more column values.
	D.	Function-based indexes are a replacement for bitmap indexes.