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