OCE Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047‪)‬

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