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