CERTIFICATION WATCH:

Get the latest IT certification news by email when you subscribe to GoCertify
Certification Update


OUR OTHER SITES:

GoCertify: The complete computer certification resource center.

GoExam: Certification practice tests with free demos to download.

CertificationBooks: Find the certification book you're looking for.

 

 

 

Home > Training > Oracle Corporation

Oracle 9i OCA Introduction - SQL Practice Test

Covers objectives for Oracle Certified Associate (OCA) exam 1Z0-007. Over 150 questions.

Available Training Formats:

download
Download
online subscription
Online
     training demo link
(current price & free demo via our partner's website)

Product Details:

Test Engine Features:
  • Questions are similar to exam questions so you test your knowledge of exam objectives
  • Detailed answer explanations reinforce the material
  • Study mode covers all objectives ensuring topics are covered
  • Certification mode prepares students for exam taking conditions
Core Test Information:

This test contains 151 questions and covers the following objectives:

  • Writing Basic SQL Select Statements - 14 questions
  • Restricting and Sorting Data - 6 questions
  • Single-Row Functions - 20 questions
  • Displaying Data from Multiple Tables - 7 questions
  • Aggregating Data using Group Functions - 14 questions
  • Subqueries - 9 questions
  • Producing Readable Output with iSQL*Plus - 11 questions
  • Manipulating Data - 15 questions
  • Creating and Managing Tables - 12 questions
  • Including Constraints - 9 questions
  • Creating Views - 17 questions
  • Creating Other Database Objects - 6 questions
  • Controlling User Access - 11 questions
This test includes references to the following media:
  • Introduction to Oracle9i: SQL

training demo link
(current price & free demo via our partner's website)