OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052) | 
 enlarge | Author: John Watson
Publisher: McGraw-Hill Osborne Media
Category: Book
List Price: $59.99
Buy New: $32.77
You Save: $27.22 (45%)
New (27) Used (2) from $32.77
Avg. Customer Rating:  1 reviews
Sales Rank: 31786
Media: Paperback
Edition: 1
Number Of Items: 1
Pages: 733
Shipping Weight (lbs): 2.8
Dimensions (in): 9 x 7.4 x 1.7
ISBN: 0071591028
Dewey Decimal Number: 005
EAN: 9780071591027
ASIN: 0071591028
Publication Date: May 2, 2008
Availability: Usually ships in 1-2 business days
Shipping: International shipping available
Condition: Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.
|
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11g Administration 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-052, including: Database architecture - Creating an Oracle Database
- Managing the Oracle instance
- Configuring and managing the Oracle network
- Managing database storage structures
- Administering user security
- Managing schema objects, data and concurrency, and undo data
- Implementing Oracle Database security
- Database maintenance and performance management
- Backup and recovery
- Moving data
- Intelligent infrastructure enhancements
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
|
| Customer Reviews:
decent - has some inaccuracies June 25, 2008
4 out of 4 found this review helpful
This book has a fairly decent walk through of the exam. The 'substance' is there but the proofreading is not. Many times this can be inferred - for example; on page 175 - it tells you to set the 'processes' parameter in the 'static' parameter file by using the 'scope=spfile' option.
alter system set processes=200 scope=spfile;
Okay - so far so good. Next page - we set the optimizer mode to the outdated 'rule' value. However - we want the change to work for the current session only - so we use the 'scope=spfile' value. (HUH??)
alter system set optimizer_mode=rule scope=spfile;
This is straight out of the book. It was obviously a mistake because they said the same value for scope did two different things. I looked it up the 'alter system' command on the net and found the correct scope value to affect only the current session is 'memory' - so it should actually have been:
alter system set optimizer_mode=rule scope=memory;
Makes much more sense now. The thing that kinda scares me is how many more of these little mistakes are there that are not as obvious? So I try to read this book as a 'rough in' but take it all with a grain of salt.
I don't know how many good books there are out there yet for the 11g exam - this one is OKAY. I bought this one impulsively at B&N without prior research... maybe you can find a better one.
One more thing - if you are not yet familiar with the fundamentals of a relational database (normalization, foreign keys, join types, etc.) - do NOT go off of the explanation in the beginning 'primer' chapter of this book - it is horrible and I was only able to piece it together using my prior knowledge of the same. Once it gets into the actual DBA work the writing improves.
|
|
|
