Free OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) Ebooks Online
A Fully Integrated Study System for OCA Exam 1Z0-052Prepare 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 architectureCreating an Oracle DatabaseManaging the Oracle instanceConfiguring and managing the Oracle networkManaging database storage structuresAdministering user securityManaging schema objects, data and concurrency, and undo dataImplementing Oracle Database securityDatabase maintenance and performance managementBackup and recoveryMoving dataIntelligent infrastructure enhancementsOn the CD-ROM:One full practice exam that simulates the actual OCA examDetailed answers and explanationsScore report performance assessment toolComplete electronic bookBonus exam available free with online registration
Paperback: 733 pages
Publisher: McGraw-Hill Education; 1 edition (May 23, 2008)
Language: English
ISBN-10: 9780071591027
ISBN-13: 978-0071591027
ASIN: 0071591028
Product Dimensions: 7.3 x 1.5 x 9.2 inches
Shipping Weight: 2.8 pounds (View shipping rates and policies)
Average Customer Review: 4.3 out of 5 stars See all reviews (22 customer reviews)
Best Sellers Rank: #775,286 in Books (See Top 100 in Books) #49 in Books > Computers & Technology > Certification > Oracle #187 in Books > Computers & Technology > Databases & Big Data > Oracle #812 in Books > Textbooks > Computer Science > Database Storage & Design
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.
This is an extremely comprehensive book -- both from the standpoint of the 1Z0-052 certification test and in terms of the fundamental knowledge that an Oracle DBA needs to have. It does not simply lay out information about the exam topics in isolation but provides background and details that pull everything into context. It's the context that an Oracle DBA needs to have in order to be able to make use of the information in a work environment. Passing the test is obviously a primary aim of anyone reading this book. However, for those just starting out in Oracle, the foremost goal of the certification process should be learning how to become a DBA. This book has the information that will help you to do both.The proofreading issues mentioned by the other reviewers exist. However, they constitute a tiny fraction of the book, and few of the errors impact exam questions. Despite this, be sure to read the errata available on the McGraw Hill web site. To put the errors in perspective -- assume that you use this book to study for the test (without ever checking the errata). If you get every question right where the book provides the correct information, and get every question wrong where there is an error, you would likely miss two or three questions and 'only' pass with 95-97%. Reading the book doesn't guarantee that you'll pass the test. You may fail to understand the information or fail to retain it. However, the answers to the questions you will be asked on the exam are in this book.A couple of the other reviewers mention using other sources in addition to this book and I fully agree. I never use a single source for any certification test if I can help it. The Oracle documentation is well written and free to download.
After reading a few Oracle cert books I really, really, liked the way this book was organized. Structurally, it's written well, with cohesion, conciseness, and terms that don't seem like and endless decoupled liturgy of things to memorize.However, the proof reading and syntax issues in this book blows. It's got way too many errata issues that I'm finding as I read. And this isn't good for a book that supposed to help you pass a test and for a book that's listed at 59.95.And it's not terribly easy to find the already existing errata that's been published on McGraw Hill's web site(s) of which there are many.Things I've found already (excluding the already published errata are)Chapter 5 in the book indicates that BACKGROUND_DUMP_DEST parameter used to point to trace locations. However, this parameter is now deprecated.Page 278 Chapter 7 Self Test Answers number 9. Indicates that D and E are the correct answers outing C "because there is no relevant information in V$DATABASE. However, on page 275 D in the question is V$DATABASE. D is one of the "correct" answers on page 278, yet V$DATABASE, as indicated, is incorrect. The problem is that there's a mismatch of the test question answers with the actual answers. According to the original question, the answer should be E for V$DATAFILE and for V$TABLESPACE. The answer needs to be rewritten, or the question does.Page 278 Chapter 7 Self Test Answers number 10. Discusses the DBA_TABLESPACE view. There is no such view; however, DBA_TABLESPACES exists.Also, I'm getting the feeling that the test questions were aggregated separately from its content. Which is OK, I rather like the challenge--seems more like a test.
OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) Study Guide for 1Z0-052: Oracle Database 11g: Administration I: Oracle Certification Prep OCA: Oracle Database 11g Administrator Certified Associate Study Guide: Exams1Z0-051 and 1Z0-052 OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) Study Guide for 1Z0-067: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP: Oracle Certification Prep OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062) (Oracle Press) OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Oracle Press) Study Guide for 1Z0-053: Oracle Database 11g: Administration II (Oracle Certification Prep) OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Oracle Press) OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050) (Oracle Press) OCA Oracle Solaris 11 System Administration Exam Guide (Exam 1Z0-821) (Oracle Press) OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062 Study Guide for 1Z0-051: Oracle Database 11g: SQL Fundamentals I: Oracle Certification Prep Study Guide for 1Z0-144: Oracle Database 11g: Program with PL/SQL: Oracle Certification Prep Study Guide for 1Z0-146: Oracle Database 11g: Advanced PL/SQL (Oracle Certification Prep) Study Guide for 1Z0-117: Oracle Database 11g Release 2: SQL Tuning (Oracle Certification Prep) OCP Oracle Database 12c Advanced Administration Exam Guide (Exam 1Z0-063) (Oracle Press) OCM Java EE 6 Enterprise Architect Exam Guide (Exams 1Z0-807, 1Z0-865 & 1Z0-866) (Oracle Press) Study Guide for 1Z0-062: Oracle Database 12c: Installation and Administration: Oracle Certification Prep Study Guide for 1Z0-063: Oracle Database 12c: Advanced Administration: Oracle Certification Prep
