Book 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
Table of contents
- Cover Page
- OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052)
- Copyright Page
- CD Page
- Contents
- Introduction
- 1 Introduction to the Oracle Server Technologies
-
2 Exploring the Database Architecture
- Describe the Single-Instance Architecture
- Explain the Memory Structures
-
Describe the Process Structures
- 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
- ARCn, the Archiver
- RECO, the Recoverer Process
- Some Other Background Processes
- Exercise 2-3: Investigate the Processes Running in Your Instance
- Summarize the Storage Structures
- Two-Minute Drill
- Self Test
- 3 Preparing the Database Environment
- 4 Creating an Oracle Database
- 5 Managing the Oracle Instance
-
6 Configuring the Oracle Network Environment
-
Configure and Manage the Oracle Network
- Oracle Net and the Client-Server Paradigm
- A Word on Oracle Net and Communication Protocols
- Establishing a Session
- Creating a Listener
- Database Registration
- Techniques for Name Resolution
- The Listener Control Utility
- Configuring Service Aliases
- File Names and the TNSADMIN Environment Variable
- Database Links
- Exercise 6-1: Configure Oracle Net
- Use the Oracle Shared Server Architecture
- Two-Minute Drill
- Self Test
-
Configure and Manage the Oracle Network
- 7 Managing Database Storage Structures
- 8 Administering User Security
- 9 Managing Schema Objects
- 10 Managing Data and Concurrency
- 11 Managing Undo Data
- 12 Implementing Oracle Database Security
- 13 Database Maintenance
- 14 Performance Management
- 15 Backup and Recovery Concepts
- 16 Performing Database Backups
-
17 Performing Database Recovery
-
Overview of Data Recovery Advisor
- Recovery from Loss of the Controlfile
- Recovery from Loss of an Online Redo Log File Member
- Loss of Any Datafile in Noarchivelog Mode
- Loss of a Datafile in Archivelog Mode
- The Health Monitor and the ADR
- The Capabilities and Limitations of the DRA
- Exercise 17-1: Use the DRA to Diagnose and Advise Upon Problems
- Use Data Recovery Advisor to Perform Recovery (Control File, Redo Log File, and Data File)
- Two-Minute Drill
- Self Test
-
Overview of Data Recovery Advisor
- 18 Moving Data
- 19 Intelligent Infrastructure Enhancements
- Appendix About the Download
- Glossary
- Index
- MediaCenter
Product information
- Title: OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)
- Author(s):
- Release date: May 2008
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071591034
You might also like
book
OCP Oracle Database 11g Administration II Exam Guide, 2nd Edition
A Fully Integrated Study System for OCP Exam 1Z0-053 Prepare for the Oracle Certified Professional Oracle …
book
OCA/OCP Oracle Database 11g All-in-One Exam Guide
A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053 Prepare …
book
Pro Oracle Database 11g Administration
Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from …
book
OCA Oracle® Database 11g Administrator Certified Associate: Study Guide
Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and …