Book description
A Complete Study System for OCA Exam 1Z0-062
Prepare for the Oracle Certified Associate Oracle Database 12c Installation and Administration exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-062, including:
- Installing and upgrading Oracle Database software
- Managing the database instance
- Configuring the Oracle network environment
- Managing database storage structures
- Administering user security
- Managing undo data and data concurrency
- Implementing Oracle Database auditing
- Performing database maintenance
- Managing performance and tuning SQL
- Managing resources using Oracle Database Resource Manager
- Automating tasks
- Moving data
- Performing backup and recovery
- Installing Oracle Grid Infrastructure for a standalone server
Electronic content includes:
- 185+ practice exam questions with detailed answers and explanations
- Test engine that provides custom exams by chapter or by domain
Table of contents
- Cover
- About the Authors
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- Preface
- Introduction
- 1. Installing Oracle Database Software
- 2. Creating an Oracle Database Using DBCA
-
3. Exploring the Oracle Database Architecture
- List the Architectural Components of an Oracle Database
- Explain the Memory Structures
-
Describe the Background Processes
- SMON, the System Monitor
- PMON, the Process Monitor
- DBWn, the Database Writer
- LGWR, the Log Writer
- CKPT, the Checkpoint Process
- MMON, the Manageability Monitor
- MMNL, the Manageability Monitor Light
- MMAN, the Memory Manager
- LREG, the Listener Registration Process
- ARCn, the Archiver
- RECO, the Recoverer Process
- Some Other Background Processes
- Exercise 3-3: Investigate the Processes Running in Your Instance
- Explain the Relationship Between Logical and Physical Storage Structures
- Two-Minute Drill
- Q&A Self Test
- Lab Question
- Self Test Answers
- Lab Answer
- 4. Managing the Database Instance
- 5. Configuring the Oracle Network Environment
- 6. Managing Database Storage Structures
-
7. Managing Space
- Explain How Oracle Database Server Automatically Manages Space
- Save Space by Using Compression
- Proactively Monitor and Manage Tablespace Space Usage
- Use the Segment Advisor
- Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
- Manage Resumable Space Allocation
- Two-Minute Drill
- Q&A Self Test
- Lab Question
- Self Test Answers
- Lab Answer
- 8. Administering User Security
- 9. Managing Undo Data
- 10. Managing Data Concurrency
- 11. Implementing Oracle Database Auditing
- 12. Performing Database Maintenance
- 13. Managing Performance
- 14. Managing Performance: SQL Tuning
- 15. Managing Resources Using Database Resource Manager
- 16. Automating Tasks by Using Oracle Scheduler
-
17. Moving Data
- Describe Ways to Move Data
- Create and Use Directory Objects
- Use SQL*Loader to Load Data from a Non-Oracle Database
- Use External Tables to Move Data via Platform-Independent Files
- Explain the General Architecture of Oracle Data Pump
- Use Data Pump Export and Import to Move Data between Oracle Databases
- Two-Minute Drill
- Q&A Self Test
- Lab Question
- Self Test Answers
- Lab Answer
- 18. Backup and Recovery: Concepts and Configuration
-
19. Backup and Recovery Operations
- Create Consistent Database Backups
- Back Up Your Database Without Shutting It Down
- Create Incremental Backups
- Automate Database Backups
- Manage Backups
- Determine the Need for Performing Recovery
- Use Recovery Manager (RMAN) and the Data Recovery Advisor to Perform Recovery of the Controlfile, Redo Logfile, and Datafile
- Two-Minute Drill
- Q&A Self Test
- Lab Question
- Self Test Answers
- Lab Answer
- 20. Installing Oracle Grid Infrastructure for a Standalone Server
- 21. Using Oracle Restart
- 22. Upgrading Oracle Database Software and Migrating Data
-
23. Database Upgrade: Preparation, Upgrading, and Post-Upgrade Tasks
- Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
- Use the Pre-Upgrade Information Tool Before Performing an Upgrade
- Prepare the New Oracle Home Prior to Performing an Upgrade
- Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant (DBUA)
- Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
- Migrate to Unified Auditing
- Perform Post-Upgrade Tasks
- Two-Minute Drill
- Q&A Self Test
- Lab Question
- Self Test Answers
- Lab Answer
- A. About the Download
- Glossary
- Index
Product information
- Title: OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062), 2nd Edition
- Author(s):
- Release date: May 2014
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071831277
You might also like
book
OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition
This Oracle Press certification exam guide prepares you for the new Oracle Database 12 c certification …
book
OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition
A Complete Study System for OCA Exam 1Z0-061 Prepare for the Oracle Certified Associate Oracle Database …
book
OCP Oracle Database 12c Advanced Administration Exam Guide (Exam 1Z0-063), 3rd Edition
A Complete Study System for OCP Exam 1Z0-063 Prepare for the Oracle Certified Professional Oracle Database …
audiobook
CISSP All-in-One Exam Guide, Ninth Edition
Thoroughly updated for the latest release of the Certified Information Systems Security Professional exam, this comprehensive …