User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
Oracle9i SQL 1Z0-007 Series: Practice Exam
Product Code: or0711 Time: 1.0 hour(s) CEUs: Available

Summary:

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

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


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

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright � 2006 Webteks. All rights reserved.