OCA Oracle Database 11g SQL Fundamentals I Exam Guide

A Fully Integrated Study System for OCA Exam 1Z0-051

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-051, including:
SQL SELECT statements

Restricting and sorting data

Single-row functions

Conversion functions and conditional expressions

Group functions

Displaying data from multiple tables

Subqueries

Set operators

DML and DDL statements

Schema objects




On the CD-ROM:

One full practice exam that simulates the actual OCA exam

Detailed answers and explanations

Score report performance assessment tool

Complete electronic book

Bonus exam available free with online registration