You are previewing OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052).
O'Reilly logo
OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

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.

NOTE: This ebook does not provide access to the companion files.

Table of Contents

  1. Cover Page
  2. OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052)
  3. Copyright Page
  4. CD Page
  5. Contents
  6. Introduction
  7. 1 Introduction to the Oracle Server Technologies
    1. Position the Oracle Product Family
      1. The Server Technologies
      2. The Development Tools and Languages
      3. The Oracle Applications
      4. Exercise 1-1: Investigate DBMSs in Your Environment
    2. Explain Relational Structures
      1. Rows and Tables
      2. Data Normalization
    3. Understand the SQL Language
    4. Appreciate the DBA's Role
    5. Two-Minute Drill
    6. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  8. 2 Exploring the Database Architecture
    1. Describe the Single-Instance Architecture
      1. Single-Instance Database Architecture
      2. Distributed Systems Architectures
      3. Exercise 2-1: Determine if the Database Is Single Instance or Part of a Distributed System
    2. Explain the Memory Structures
      1. The Database Buffer Cache
      2. The Log Buffer
      3. The Shared Pool
      4. The Large Pool
      5. The Java Pool
      6. The Streams Pool
      7. Exercise 2-2: Investigate the Memory Structures of the Instance
    3. Describe the Process Structures
      1. SMON, the System Monitor
      2. PMON, the Process Monitor
      3. DBWn, the Database Writer
      4. LGWR, the Log Writer
      5. CKPT, the Checkpoint Process
      6. MMON, the Manageability Monitor
      7. MMNL, the Manageability Monitor Light
      8. MMAN, the Memory Manager
      9. ARCn, the Archiver
      10. RECO, the Recoverer Process
      11. Some Other Background Processes
      12. Exercise 2-3: Investigate the Processes Running in Your Instance
    4. Summarize the Storage Structures
      1. The Physical Database Structures
      2. The Logical Database Structures
      3. The Data Dictionary
      4. Exercise 2-4: Investigate the Storage Structures in Your Database
    5. Two-Minute Drill
    6. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  9. 3 Preparing the Database Environment
    1. Identify the Tools for Administering an Oracle Database
      1. The Oracle Universal Installer
      2. Database Creation and Upgrade Tools
      3. Tools for Issuing Ad Hoc SQL: SQL*Plus and SQL Developer
      4. Exercise 3-1: Install SQL Developer on Windows
      5. Oracle Enterprise Manager
      6. Other Administration Tools
    2. Plan an Oracle Database Installation
      1. Choice of Operating System
      2. Hardware and Operating System Resources
      3. Exercise 3-2: Confirm Available Hardware Resources 104 Optimal Flexible Architecture
      4. Environment Variables
    3. Install the Oracle Software by Using the Oracle Universal Installer (OUI)
      1. Exercise 3-3: Install the Oracle Home
    4. Two-Minute Drill
    5. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  10. 4 Creating an Oracle Database
    1. Create a Database by Using the Database Configuration Assistant
      1. The Instance, the Database, and the Data Dictionary
      2. Using the DBCA to Create a Database
      3. Exercise 4-1: Use the DBCA to Create a Database
      4. The Scripts and Other Files Created by the DBCA
      5. The DBCA's Other Functions
    2. Two-Minute Drill
    3. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  11. 5 Managing the Oracle Instance
    1. Describe the Stages of Database Startup and Shutdown
      1. Starting and Connecting to Database Control
      2. Starting the Database Listener
      3. Starting SQL*Plus
      4. Database Startup and Shutdown
      5. Exercise 5-1: Conduct a Startup and a Shutdown
    2. Set Database Initialization Parameters
      1. Static and Dynamic Parameters, and the Initialization Parameter File
      2. The Basic Parameters
      3. Exercise 5-2: Query and Set Initialization Parameters
    3. Use the Alert Log and Trace Files
      1. Exercise 5-3: Use the Alert Log
    4. Use Data Dictionary and Dynamic Performance Views
      1. The Data Dictionary Views
      2. The Dynamic Performance Views
      3. Exercise 5-4: Query Data Dictionary and Dynamic Performance Views
    5. Two-Minute Drill
    6. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  12. 6 Configuring the Oracle Network Environment
    1. Configure and Manage the Oracle Network
      1. Oracle Net and the Client-Server Paradigm
      2. A Word on Oracle Net and Communication Protocols
      3. Establishing a Session
      4. Creating a Listener
      5. Database Registration
      6. Techniques for Name Resolution
      7. The Listener Control Utility
      8. Configuring Service Aliases
      9. File Names and the TNSADMIN Environment Variable
      10. Database Links
      11. Exercise 6-1: Configure Oracle Net
    2. Use the Oracle Shared Server Architecture
      1. The Limitations of Dedicated Server Architecture
      2. The Shared Server Architecture
      3. Configuring Shared Server
      4. When to Use the Shared Server
      5. Exercise 6-2 (optional): Set Up a Shared Server Environment
    3. Two-Minute Drill
    4. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  13. 7 Managing Database Storage Structures
    1. Understand Tablespaces and Datafiles
      1. The Oracle Data Storage Model
      2. Segments, Extents, Blocks, and Rows
      3. Automatic Storage Management (ASM)
      4. Exercise 7-1: Investigate the Database's Data Storage Structures
    2. Create and Manage Tablespaces
      1. Tablespace Creation
      2. Altering Tablespaces
      3. Dropping Tablespaces
      4. Oracle-Managed Files (OMF)
      5. Exercise 7-2: Create, Alter, and Drop Tablespaces
    3. Manage Space in Tablespaces
      1. Extent Management
      2. Segment Space Management
      3. Exercise 7-3: Change Tablespace Characteristics
    4. Two-Minute Drill
    5. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  14. 8 Administering User Security
    1. Create and Manage Database User Accounts
      1. User Account Attributes
      2. Authentication Methods
      3. Creating Accounts
      4. Exercise 8-1: Create Users
    2. Grant and Revoke Privileges
      1. System Privileges
      2. Object Privileges
      3. Exercise 8-2: Grant Direct Privileges
    3. Create and Manage Roles
      1. Creating and Granting Roles
      2. Predefined Roles
      3. Enabling Roles
      4. Exercise 8-3: Create and Grant Roles
    4. Create and Manage Profiles
      1. Password Management
      2. Resource Limits
      3. Creating and Assigning Profiles
      4. Exercise 8-4: Create and Use Profiles
    5. Two-Minute Drill
    6. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  15. 9 Managing Schema Objects
    1. Create and Modify Tables
      1. Users, User Accounts, Schemas, and Schema Objects
      2. Naming Schema Objects
      3. Object Namespaces
      4. Datatypes
      5. Creating Tables
      6. Exercise 9-1: Create and Modify Tables
    2. Manage Constraints
      1. The Types of Constraint
      2. Defining Constraints
      3. Constraint State
      4. Constraint Checking
      5. Exercise 9-2: Manage Constraints
    3. Create Indexes
      1. Why Indexes Are Needed
      2. Types of Index
      3. Creating and Using Indexes
      4. Modifying and Dropping Indexes
      5. Exercise 9-3: Create Indexes
    4. Create and Use Temporary Tables
      1. Exercise 9-4: Create and Use Temporary Tables
    5. Two-Minute Drill
    6. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  16. 10 Managing Data and Concurrency
    1. Manage Data Using DML
      1. Database Transactions
      2. Executing SQL Statements
      3. Transaction Control: COMMIT, ROLLBACK, SAVEPOINT
      4. Exercise 10-1: Manage Data Using DML
    2. Identify and Administer PL/SQL Objects
      1. SQL and Procedural Languages
      2. Stored and Anonymous PL/SQL
      3. PL/SQL Objects
      4. Exercise 10-2: Create PL/SQL Objects
    3. Monitor and Resolve Locking Conflicts
      1. Shared and Exclusive Locks
      2. The Enqueue Mechanism
      3. Lock Contention
      4. Deadlocks
      5. Exercise 10-3: Detect and Resolve Lock Contention
    4. Two-Minute Drill
    5. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  17. 11 Managing Undo Data
    1. Explain the Purpose of Undo
      1. Exercise 11-1: Use Undo Data
    2. Understand How Transactions Generate Undo
      1. Exercise 11-2: Work with Transactions and Flashback Query
    3. Manage Undo
      1. Error Conditions Related to Undo
      2. Parameters for Undo Management, and Retention Guarantee
      3. Sizing and Monitoring the Undo Tablespace
      4. Flashback Query
      5. Creating and Managing Undo Tablespaces
      6. Exercise 11-3: Work with Undo Tablespaces
    4. Two-Minute Drill
    5. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  18. 12 Implementing Oracle Database Security
    1. Database Security and Principle of Least Privilege
      1. Public Privileges
      2. Security-Critical Instance Parameters
      3. Exercise 12-1: Remove Some Potentially Dangerous Privileges
    2. Work with Standard Database Auditing
      1. Auditing SYSDBA Activity
      2. Database Auditing
      3. Value-Based Auditing with Triggers
      4. Fine-Grained Auditing (FGA)
      5. Exercise 12-2: Use Standard Database Auditing
    3. Two-Minute Drill
    4. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  19. 13 Database Maintenance
    1. Use and Manage Optimizer Statistics
      1. Object Statistics
      2. Gathering Statistics Manually
      3. The STATISTICS_LEVEL Instance Parameter
      4. Exercise 13-1: Gather Optimizer Statistics with Various Tools
    2. Use and Manage the Automatic Workload Repository
      1. Gathering AWR Statistics
      2. Managing the AWR
      3. Statistics, Metrics, and Baselines
      4. The DBMS_WORKLOAD_REPOSITORY Package
      5. Exercise 13-2: Monitor the Automatic Workload Repository
    3. Use the Advisory Framework
      1. The Automatic Database Diagnostic Monitor
      2. The Advisors
      3. Automatic Maintenance Jobs
      4. Exercise 13-3: Generate an ADDM Report
    4. Manage Alerts and Thresholds
      1. Alert Condition Monitoring and Notifications
      2. Setting Thresholds
      3. The Notification System
      4. Exercise 13-4: Configure Alerts
    5. Two-Minute Drill
    6. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  20. 14 Performance Management
    1. Use Automatic Memory Management
      1. PGA Memory Management
      2. SGA Memory Management
      3. Automatic Memory Management
      4. Exercise 14-1: Set the Memory Management Parameters
    2. Use Memory Advisors
      1. Exercise 14-2: Use the Memory Advisors
    3. Troubleshoot Invalid and Unusable Objects
      1. Invalid Objects
      2. Unusable Indexes
      3. Exercise 14-3: Repair Invalid Objects and Unusable Indexes
    4. Two-Minute Drill
    5. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  21. 15 Backup and Recovery Concepts
    1. Identify the Types of Failure That Can Occur in an Oracle Database
      1. Statement Failure
      2. User Process Failure
      3. User Errors
      4. Media Failure
      5. Instance Failure
      6. Exercise 15-1: Correct Statement Failures
    2. Describe Ways to Tune Instance Recovery
      1. The Mechanics of Instance Recovery
      2. The Impossibility of Database Corruption
      3. Tuning Instance Recovery
      4. The MTTR Advisor and Checkpoint Auto-Tuning
      5. Exercise 15-2: Monitor Instance Recovery Times
    3. Identify the Importance of Checkpoints, Redo Log Files, and Archived Log Files
      1. Checkpointing
      2. Protecting the Online Redo Log Files
      3. Archivelog Mode and the Archiver Process(es)
      4. Exercise 15-3: Investigate the Redo Log Configuration
    4. Overview of Flash Recovery Area
      1. Exercise 15-4: Investigate the Flash Recovery Area Configuration
    5. Configure ARCHIVELOG Mode
      1. Exercise 15-5: Enable Archivelog Mode
    6. Two-Minute Drill
    7. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  22. 16 Performing Database Backups
    1. Create Consistent Database Backups
      1. User-Managed Consistent Backups
      2. Server-Managed Consistent Backups
      3. Exercise 16-1: Managing Consistent User- and Server-Managed Backups
    2. Back Up Your Database Without Shutting It Down
      1. User-Managed Open Backups
      2. Server-Managed Open Backups
      3. Exercise 16-2: Perform Server-Managed and User-Managed Open Backups
    3. Create Incremental Backups
      1. Exercise 16-3: Make an Incremental Backup
    4. Automate Database Backups
      1. Exercise 16-4: Define an Automatic Backup Job
    5. Manage Backups, View Backup Reports, and Monitor the Flash Recovery Area
      1. The RMAN Repository
      2. Reports on Backups
      3. Managing Backups
      4. Monitoring the Flash Recovery Area
      5. Exercise 16-5: Manage RMAN Backups
    6. Two-Minute Drill
    7. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  23. 17 Performing Database Recovery
    1. Overview of Data Recovery Advisor
      1. Recovery from Loss of the Controlfile
      2. Recovery from Loss of an Online Redo Log File Member
      3. Loss of Any Datafile in Noarchivelog Mode
      4. Loss of a Datafile in Archivelog Mode
      5. The Health Monitor and the ADR
      6. The Capabilities and Limitations of the DRA
      7. Exercise 17-1: Use the DRA to Diagnose and Advise Upon Problems
    2. Use Data Recovery Advisor to Perform Recovery (Control File, Redo Log File, and Data File)
      1. Exercise 17-2: Repair a Fault with the DRA
    3. Two-Minute Drill
    4. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  24. 18 Moving Data
    1. Describe and Use Methods to Move Data (SQL Loader, Directory Objects, External Tables)
      1. SQL*Loader
      2. Directory Objects
      3. External Tables
      4. Exercise 18-1: Use SQL*Loader and External Tables
    2. Explain the General Architecture of Oracle Data Pump
      1. Data Pump and Export/Import
      2. Data Pump Architecture
      3. Directories and File Locations
      4. Direct Path or External Table Path?
      5. Exercise 18-2: Perform a Data Pump Export
    3. Use Data Pump Export and Import to Move Data Between Oracle Databases
      1. Capabilities
      2. Using Data Pump with the Command-Line Utilities
      3. Using Data Pump with Database Control
      4. Exercise 18-3: Use Data Pump in Network Mode
    4. Two-Minute Drill
    5. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  25. 19 Intelligent Infrastructure Enhancements
    1. Use the Enterprise Manager Support Workbench
      1. The Automatic Diagnostic Repository (ADR)
      2. Problems and Incidents
      3. The ADR Command-Line Interface (ADRCI)
      4. The Support Workbench
      5. Exercise 19-1: Use the Support Workbench
    2. Manage Patches
      1. Types of Patch
      2. Integration with MetaLink and the Patch Advisor
      3. Applying Patches
      4. Exercise 19-2: Download and Apply a Patch
    3. Two-Minute Drill
    4. Self Test
      1. Lab Question
      2. Self Test Answers
      3. Lab Answer
  26. Appendix About the Download
    1. About the Download
      1. Steps to Download MasterExam
        1. System Requirements
        2. MasterExam
      2. Help
      3. Removing Installation
      4. Technical Support
        1. LearnKey Technical Support
  27. Glossary
  28. Index
  29. MediaCenter