Describe the different kinds of indexes Oracle uses. Give an example of when you might use each type.
Why might it be important to determine the size of an index?
What happens to secondary indices when a page split happens in a file organization?
Describe the difference between a view and a table. Why would you use a view instead of a table. Is there any advantage to using views?
Discuss three different V$ views found in the Oracle database.