RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
Oracle SQL Tuning
Tuning Oracle SQL
Oracle Extensions ANSI SQL
SQL Tuning Tools
Explain Plan Utility
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.
