| | |  | Osborne-McGraw-Hill | Home » » » » OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) | | | | | | | Product Promotions: | | | | | Description: | | 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
| | | Product Details: | | | Author:
| John Watson | | Paperback:
| 581 pages | | Publisher:
| McGraw-Hill Osborne Media | | Publication Date:
| May 29, 2008 | | Language:
| English | | ISBN:
| 0071597867 | | Product Length:
| 9.22 inches | | Product Width:
| 7.39 inches | | Product Height:
| 1.26 inches | | Product Weight:
| 2.29 pounds | | Package Length:
| 9.1 inches | | Package Width:
| 7.4 inches | | Package Height:
| 1.3 inches | | Package Weight:
| 2.25 pounds | | Average Customer Rating:
|  based on 16 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 16 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
13 of 13 found the following review helpful:
 Lots of errors, but otherwise okJan 02, 2009
By spinningplate
This book has a lot of errors in, which I would consider to be a problem for anyone actually studying for the exam. I'd also agree that many of the topics tested on the exam are not fully covered here - I have already taken the exam, and several things were questioned that were not mentioned at all in the textbook. In addition, some of the errors were in the test questions and answers in both the book and downloaded material, which is very confusing. Overall I would say this book should only be used as a backup text to something better edited and more comprehensive.
13 of 14 found the following review helpful:
 Helpful but not usefulDec 10, 2008
By H. THOTA
"Book Worm"
The book is a good resource to give you a overview of features.However,it does not reflect the actual exam scenarios.Topics that appeared most in the exam are discussed in lighter vein.
I would suggest people to study the SQL programmer guide rather than exam guide.Once you are done with the detailed SQL pragramming, then you can briskly follow this one.
Gave it one star as I found SQL Programmer guide more useful than this one.This one is worth reading but not very helpful to pass the exam
9 of 9 found the following review helpful:
Riddled with errors, sample questions too simpleMar 22, 2010
By Joop Van Den Hoop
This book is almost useless. Namely, it is riddled with errors, doesn't cover all the exam topics, examples are way to easy in comparison with the actual test and the 2 sample tests are easy too.
I just took the online exam and passed. However:
- most of the questions were about complex SQL statements, mostly joins and subqueries
- the online test has a serious problem: namely, the question and the proposed answers are displayed in one tab
and the table structures and tabel data are displayed in a second tab. Now the catch: the tabs can't be viewed simultaneously. This is a major problem since you have to switch back and forth between the tabs and you forget either the exhibit or the question and the given answers.
I easily scored over 95% on the practice tests (from this book and other sample tests) and barely got 75% on the real test. On a final note, I do have several years of hands-on SQL experience.
4 of 4 found the following review helpful:
Fair Study Guide for Exam, Lacking DepthJun 04, 2010
By gburgalum01
I purchased this book in preparation for the Oracle Database 11g SQL Fundamentals 1 Exam. While the breadth of the material is good as it covers every topic on the exam, the presented examples are extremely simplified and often present a concept in its most basic form. In addition, the exercise questions at the end of each chapter are much too simplified. I downloaded a practice exam from Transcender and was amazed at the difference in complexity between the questions and exams provided by the book and those from Transcender. If you are taking the exam, the questions in the book as well as the exams will not fully prepare you for the exam. I highly recommend purchasing additional practice exams from Transcender; they have the look and feel of actual Oracle exam questions. I did find the study text in this book extremely useful and would recommend it in conjunction with some other study aid.
2 of 2 found the following review helpful:
 Very basic.Oct 04, 2010
By U. Cetin
This book is an Introduction to SQL level book. If you know SQL a little bit, you will get very little out of this book. The chapters don't go into detail and the questions seem to be dumbed down - they don't look like realistic certification exam questions. Although it is not a certification book, if you would like to learn Oracle SQL I recommend Oracle SQL by Example (by Alice Rischert). This is one of the best book on Oracle SQL and you will learn a lot from it - not just superficial certification SQL.
See all 16 customer reviews on Amazon.com
| | |
|
