SQL Tuning   «Prev  Next»

SQL Tuning Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which was listed as a method for making SQL re-usable? (Choose all that apply)
Please select all the correct answers.
  A. Place all SQL in stored procedures.
  B. Replace all hard-coded variables with host variables.
  C. Place all SQL in triggers.
  D. Remove all built-in functions from SQL.

2. Which was listed as a tool to help tune Oracle SQL? (Choose all that apply)
Please select all the correct answers.
  A. TKPROF
  B. SQL*Loader
  C. SQL Analyzer
  D. EXPLAIN PLAN

3. Which is correct about the rule-based optimizer? (Choose all that apply)
Please select all the correct answers.
  A. It was the first optimizer for Oracle.
  B. It uses table and index statistics to determine the access path.
  C. It reads the Oracle data dictionary to determine if indexes exist for tables.
  D. It requires periodic ANALYZE TABLE commands.

4. Which is true about the EXPLAIN PLAN utility? (Choose all that apply)
Please select all the correct answers.
  A. It requires the existence of a plan table.
  B. It places the access path in a plan table for display.
  C. It must execute the SQL to determine the path.
  D. It requires the SET PLAN command.