Checking It

1:Stored Outlines became available with this release of the database:

  1. V8.0.4

  2. V8.1.5

  3. V8.1.7

  4. V9.0.1

2:Which one of these helps control the rule-based optimizer?

  1. Existence of an index

  2. Use of functions in the WHERE clause

  3. Coding techniques

  4. All of the above

3:The rule-based optimizer uses a list of 18 different rules to make its decision.

True/False

4:Both the rule and cost-based optimizers supports bitmapped indexes.

True/False

5:Which of the following commands collects statistics for the cost-based optimizer?

  1. Analyze <object name> computer statistics

  2. Estimate Statistics <object name>

  3. Alter System compute statistics <object name>

  4. Oracle9i supports each of these options

6:If statistics have not been gathered and the OPTIMIZATION MODE is set to CHOOSE, Oracle will use the rule-based optimizer.

True/False

7:If statistics have not been gathered and the OPTIMIZATION MODE is set to COST, Oracle will still use the rule-based optimizer.

True/False

8:The init.ora parameter OPTIMIZER_INDEX_CACHING set to 0 says:

  1. The index cache will not be used

  2. Tells Oracle to do full-table scans

  3. Tells Oracle to rely upon indexes more

  4. Assumes a 0 buffer-hit cache ratio

9:Oracle8i allowed you to edit stored outlines.

True/False

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.225.57.126