| 1.
|
Describe the SET operators and correlated subqueries and review rules
and guidelines for their use.(I-II)
|
| 2.
|
Explain the benefits of heirarchical query.(III)
|
| 3.
|
Use advanced techniques to retrieve data including SET operators,
correlated subqueries and hierarchical queries.(I-III)
|
| 4.
|
Describe the types of problems that may be solved by writing SQL
scripts that generate other SQL scripts.(IV)
|
| 5.
|
Write and execute SQL scripts that generate SQL scripts of drop table
commands and insert commands.(IV)
|
| 6.
|
Use SQL *Plus to format reports.(V)
|
|