1. What is the goal of the optimizer in optimizing joins?
2. How does an optimizer gather statistics about database objects?
3. How does the optimizer improve speed for queries with sorting requirements?
4. What is density and how is it useful to the optimizer?
5. What is the Oracle EXPLAIN statement used for?
6. What is an optimizer and how does it work?
7. What impact does the number of columns in the SELECT clause have on performance?
8. What is a rule-based optimizer?
9. What is a cost-based optimizer?
10.  How does the LIKE logical operator make use of indexes?

Use Assignment Uploader to submit