Oracle Database SQL Expert Exam Guide (Exam 1Z0-047) (Oracle Press)

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

Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill 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 objectives for exam 1Z0-047, including:

• DDL and SQL SELECT statements
• Manipulating, restricting, and sorting data
• Single-row and group functions
• Subqueries
• Schema objects
• Set operators
• Data dictionary views
• Large data sets
• Hierarchical retrieval
• Regular expression support
• User access control
• And more

On the CD-ROM:

• One full practice exam
• Detailed answers and explanations
• Score report performance assessment tool
• Complete electronic book
• Bonus exam available with free online registration

For a complete list of Oracle Press titles, visit www.OraclePressBooks.com