My Research Institute
Home Notes

Library

Brain Dumps

Software Market

 

Exams.ws

 
OCP Braindumps, Oracle 9i exam #1Z0-007, “Introduction to Oracle 9i: SQL.” Passing this exam, plus one other, makes you an Oracle9i Certified Database Administrator (an “OCA”). This exam covers the SQL language in depth. Test topics include SQL language elements, SELECT statements, functions (single-row and group), updating data, creating common objects, the security system, and using SQL*Plus.
 

Exam #:

 

1Z0-007

Status:

Active

Time Limit:

120 min.

Avg. Time:

92 min.

Passing Score:

68%

# of Questions:

57

Format:

Form-based

Difficulty:

3

Certifications:

Oracle 9i Certifed Database Associate (OCA)

 

Microsoft Braindumps, Oracle Braindumps, Sun Braindumps, Cisco Braindumps
Citrix Braindumps, CIW Braindumps, Comptia Braindumps, Novell Braindumps

 
Introduction to Oracle9i: SQL™

 

Writing Basic SQL Select Statements

[ ]  List the capabilities of SQL
     SELECT statements

[ ]  Execute a basic SELECT
     statement

[ ]   Differentiate between SQL
      statements and iSQL*Plus
      commands

Restricting and Sorting Data

[ ]   Limit the rows retrieved by a
      query

[ ]   Sort the rows retrieved by a
      query

Single-Row Functions

[ ]   Describe various types of
      functions available in SQL

[ ]   Use character, number, and
      date functions in SELECT
      statements

[ ]   Use conversion functions

 

Displaying Data from Multiple Tables

[ ]   Write SELECT statements to
      access data from more than
      one table using equality and
      nonequality joins

[ ]   View data that generally does
      not meet a join condition by
      using outer joins

[ ]   Join a table to itself using a
      self-join

Aggregating Data using Group Functions

[ ]   Identify the available group
      functions

[ ]   Use group functions

[ ]   Group data using the GROUP
      BY clause

[ ]   Include or exclude grouped
      rows by using the HAVING
      clause

 

 

 

Exam Questions