Roopesh Ramklass & John Watson 
OCA Oracle Database 11g SQL Fundamentals I Exam Guide 
Exam 1Z0-051

A Fully Integrated Study System for OCA Exam 1Z0-051Prepare 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