A Fully Integrated Study System for OCA Exam 1Z0-047Prepare 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 statementsManipulating, restricting, and sorting dataSingle-row and group functionsSubqueriesSchema objectsSet operatorsData dictionary viewsLarge data setsHierarchical retrievalRegular expression supportUser access controlAnd moreOn the CD-ROM:One full practice examDetailed answers and explanationsScore report performance assessment toolComplete electronic bookBonus exam available with free online registration