MP9003: Network and Database (General) - Practice Exam > Oracle9i SQL 1Z0-007

This course provides questions to prepare users who plan to take exam 1Z0-007: Introduction to Oracle9i: SQL. 

Topics:
SQL Plus reports
Writing basic SQL select statements
Restricting and sorting data
Single-row functions
Displaying data from multiple tables
Aggregating data using group functions
Subqueries
Producing readable output with iSQL Plus
Manipulating data
Creating and managing tables
Including constraints
Creating views
Creating other database objects
Controlling user access

Objectives:
Answer practice questions in the format of the 1Z0-007 Introduction to Oracle 9i SQL exam
Assess readiness to take the exam and identify topic areas requiring further practice

Duration:
1 Hour