OCA/OCP Oracle Database 11g All-in-One Exam Guide

Book description

A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053

Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill 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 objectives for exams 1Z0-051, 1Z0-052, and 1Z0-053, including:

  • Instance management
  • Networking and storage
  • Security
  • SQL
  • Oracle Recovery Manager and Oracle Flashback
  • Oracle Automatic Storage Management
  • Resource manager
  • Oracle Scheduler
  • Automatic workload repository
  • Performance tuning
  • Three bonus exams available with free online registration

Table of contents

  1. Cover Page
  2. OCA/OCP Oracle Database 11g All-in-One Exam Guide
  3. Copyright Page
  4. Dedication
  5. Contents
  6. Introduction
  7. PART I Oracle Database 11g Administration
    1. CHAPTER 1 Architectural Overview of Oracle Database 11g
      1. Exam Objectives
      2. Oracle Product Stack
      3. Oracle Server Family
      4. Oracle Development Tools
      5. Oracle Applications
      6. Prerequisite Concepts
      7. Oracle Concepts
      8. SQL Concepts
      9. Operating System Concepts
      10. Single-Instance Architecture
      11. Single-Instance Database Architecture
      12. Distributed Systems Architectures
      13. Instance Memory Structures
      14. The Database Buffer Cache
      15. The Log Buffer
      16. The Shared Pool
      17. The Large Pool
      18. The Java Pool
      19. The Streams Pool
      20. Instance Process Structures
      21. SMON, the System Monitor
      22. PMON, the Process Monitor
      23. DBWn, the Database Writer
      24. LGWR, the Log Writer
      25. CKPT, the Checkpoint Process
      26. MMON, the Manageability Monitor
      27. MMNL, the Manageability Monitor Light
      28. MMAN, the Memory Manager
      29. ARCn, the Archiver
      30. RECO, the Recoverer Process
      31. Some Other Background Processes
      32. Database Storage Structures
      33. The Physical Database Structures
      34. The Logical Database Structures
      35. The Data Dictionary
      36. Two-Minute Drill
      37. Single-Instance Architecture
      38. Instance Memory Structures
      39. Instance Process Structures
      40. Database Storage Structures
      41. Self Test
      42. Self Test Answers
    2. CHAPTER 2 Installing and Creating a Database
      1. Exam Objectives
      2. Identify the Tools for Administering an Oracle Database
      3. The Oracle Universal Installer
      4. Database Creation and Upgrade Tools
      5. Tools for Issuing Ad Hoc SQL: SQL*Plus and SQL Developer
      6. Oracle Enterprise Manager
      7. Other Administration Tools
      8. Plan an Oracle Database Installation
      9. Choice of Operating System
      10. Hardware and Operating System Resources
      11. Optimal Flexible Architecture
      12. Environment Variables
      13. Install the Oracle Software by Using the Oracle Universal Installer (OUI)
      14. Create a Database by Using the Database Configuration Assistant
      15. The Instance, the Database, and the Data Dictionary
      16. Using the DBCA to Create a Database
      17. The Scripts and Other Files Created by the DBCA
      18. The DBCA’s Other Functions
      19. Two-Minute Drill
      20. Identify the Tools for Administering an Oracle Database
      21. Plan an Oracle Database Installation
      22. Install the Oracle Software by Using the Oracle Universal Installer (OUI)
      23. Create a Database by Using the Database Configuration Assistant
      24. Self Test
      25. Self Test Answers
    3. CHAPTER 3 Instance Management
      1. Exam Objectives
      2. Set Database Initialization Parameters
      3. Static and Dynamic Parameters and the Initialization Parameter File
      4. The Basic Parameters
      5. Describe the Stages of Database Startup and Shutdown
      6. Starting and Connecting to Database Control
      7. Starting the Database Listener
      8. Starting SQL*Plus
      9. Database Startup and Shutdown
      10. Use the Alert Log and Trace Files
      11. Use Data Dictionary and Dynamic Performance Views
      12. The Data Dictionary Views
      13. The Dynamic Performance Views
      14. Two-Minute Drill
      15. Describe the Stages of Database Startup and Shutdown
      16. Set Database Initialization Parameters
      17. Use the Alert Log and Trace Files
      18. Use Data Dictionary and Dynamic Performance Views
      19. Self Test
      20. Self Test Answers
    4. CHAPTER 4 Oracle Networking
      1. Exam Objectives
      2. Configure and Manage the Oracle Network
      3. Oracle Net and the Client-Server Paradigm
      4. A Word on Oracle Net and Communication Protocols
      5. Establishing a Session
      6. Creating a Listener
      7. Database Registration
      8. Techniques for Name Resolution
      9. The Listener Control Utility
      10. Configuring Service Aliases
      11. Filenames and the TNSADMIN Environment Variable
      12. Database Links
      13. Use the Oracle Shared Server Architecture
      14. The Limitations of Dedicated Server Architecture
      15. The Shared Server Architecture
      16. Configuring Shared Server
      17. When to Use the Shared Server
      18. Two-Minute Drill
      19. Configure and Manage the Oracle Network
      20. Use the Oracle Shared Server Architecture
      21. Self Test
      22. Self Test Answers
    5. CHAPTER 5 Oracle Storage
      1. Exam Objectives
      2. Overview of Tablespaces and Datafiles
      3. The Oracle Data Storage Model
      4. Segments, Extents, Blocks, and Rows
      5. File Storage Technologies
      6. Create and Manage Tablespaces
      7. Tablespace Creation
      8. Altering Tablespaces
      9. Dropping Tablespaces
      10. Oracle-Managed Files (OMF)
      11. Space Management in Tablespaces
      12. Extent Management
      13. Segment Space Management
      14. Two-Minute Drill
      15. Overview of Tablespaces and Datafiles
      16. Create and Manage Tablespaces
      17. Space Management in Tablespaces
      18. Self Test
      19. Self Test Answers
    6. CHAPTER 6 Oracle Security
      1. Exam Objectives
      2. Create and Manage Database User Accounts
      3. User Account Attributes
      4. Authentication Methods
      5. Creating Accounts
      6. Grant and Revoke Privileges
      7. System Privileges
      8. Object Privileges
      9. Create and Manage Roles
      10. Creating and Granting Roles
      11. Predefined Roles
      12. Enabling Roles
      13. Create and Manage Profiles
      14. Password Management
      15. Resource Limits
      16. Creating and Assigning Profiles
      17. Database Security and Principle of Least Privilege
      18. Public Privileges
      19. Security-Critical Instance Parameters
      20. Work with Standard Database Auditing
      21. Auditing SYSDBA Activity
      22. Database Auditing
      23. Value-Based Auditing with Triggers
      24. Fine-Grained Auditing (FGA)
      25. Two-Minute Drill
      26. Create and Manage Database User Accounts
      27. Grant and Revoke Privileges
      28. Create and Manage Roles
      29. Create and Manage Profiles
      30. Database Security and Principle of Least Privilege
      31. Work with Standard Database Auditing
      32. Self Test
      33. Self Test Answers
  8. PART II SQL
    1. CHAPTER 7 DDL and Schema Objects
      1. Exam Objectives
      2. Categorize the Main Database Objects
      3. Object Types
      4. Naming Schema Objects
      5. Object Namespaces
      6. List the Data Types That Are Available for Columns
      7. Create a Simple Table
      8. Creating Tables with Column Specifications
      9. Creating Tables from Subqueries
      10. Altering Table Definitions after Creation
      11. Dropping and Truncating Tables
      12. Create and Use Temporary Tables
      13. Indexes
      14. Why Indexes Are Needed?
      15. Types of Index
      16. Creating and Using Indexes
      17. Modifying and Dropping Indexes
      18. Constraints
      19. The Types of Constraint
      20. Defining Constraints
      21. Constraint State
      22. Constraint Checking
      23. Views
      24. Why Use Views at All?
      25. Simple and Complex Views
      26. CREATE VIEW, ALTER VIEW, and DROP VIEW
      27. Synonyms
      28. Sequences
      29. Creating Sequences
      30. Using Sequences
      31. Two-Minute Drill
      32. Categorize the Main Database Objects
      33. List the Data Types That Are Available for Columns
      34. Create a Simple Table
      35. Create and Use Temporary Tables
      36. Constraints
      37. Indexes
      38. Views
      39. Synonyms
      40. Sequences
      41. Self Test
      42. Self Test Answers
    2. CHAPTER 8 DML and Concurrency
      1. Exam Objectives
      2. Data Manipulation Language (DML) Statements
      3. INSERT
      4. UPDATE
      5. DELETE
      6. TRUNCATE
      7. MERGE
      8. DML Statement Failures
      9. Control Transactions
      10. Database Transactions
      11. Executing SQL Statements
      12. Transaction Control: COMMIT, ROLLBACK, SAVEPOINT, SELECT FOR UPDATE
      13. Identify and Administer PL/SQL Objects
      14. Stored and Anonymous PL/SQL
      15. PL/SQL Objects
      16. Monitor and Resolve Locking Conflicts
      17. Shared and Exclusive Locks
      18. The Enqueue Mechanism
      19. Lock Contention
      20. Deadlocks
      21. Overview of Undo
      22. Transactions and Undo Data
      23. Managing Undo
      24. Error Conditions Related to Undo
      25. Parameters for Undo Management, and Retention Guarantee
      26. Sizing and Monitoring the Undo Tablespace
      27. Creating and Managing Undo Tablespaces
      28. Two-Minute Drill
      29. Describe Each Data Manipulation Language (DML) Statement
      30. Control Transactions
      31. Manage Data Using DML
      32. Identify and Administer PL/SQL Objects
      33. Monitor and Resolve Locking Conflicts
      34. Overview of Undo
      35. Transactions and Undo Data
      36. Managing Undo
      37. Self Test
      38. Self Test Answers
    3. CHAPTER 9 Retrieving, Restricting, and Sorting Data Using SQL
      1. Exam Objectives
      2. List the Capabilities of SQL SELECT Statements
      3. Introducing the SQL SELECT Statement
      4. The DESCRIBE Table Command
      5. Capabilities of the SELECT Statement
      6. Data Normalization
      7. Create the Demonstration Schemas
      8. The HR and WEBSTORE Schemas
      9. Demonstration Schema Creation
      10. Execute a Basic SELECT Statement
      11. Syntax of the Primitive SELECT Statement
      12. Rules Are Meant to Be Followed
      13. SQL Expressions and Operators
      14. NULL Is Nothing
      15. Limit the Rows Retrieved by a Query
      16. The WHERE Clause
      17. Comparison Operators
      18. Boolean Operators
      19. Precedence Rules
      20. Sort the Rows Retrieved by a Query
      21. The ORDER BY Clause
      22. Ampersand Substitution
      23. Substitution Variables
      24. Define and Verify
      25. Two-Minute Drill
      26. List the Capabilities of SQL SELECT Statements
      27. Execute a Basic SELECT Statement
      28. Limit the Rows Retrieved by a Query
      29. Sort the Rows Retrieved by a Query
      30. Ampersand Substitution
      31. Self Test
      32. Self Test Answers
    4. CHAPTER 10 Single-Row and Conversion Functions
      1. Exam Objectives
      2. Describe and Use Character, Number, and Date Functions in SQL
      3. Defining a Function
      4. Types of Functions
      5. Using Case Conversion Functions
      6. Using Character Manipulations Functions
      7. Using Numeric Functions
      8. Working with Dates
      9. Describe Various Types of Conversion Functions Available in SQL
      10. Conversion Functions
      11. Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
      12. Using the Conversion Functions
      13. Apply Conditional Expressions in a SELECT Statement
      14. Nested Functions
      15. Conditional Functions
      16. Two-Minute Drill
      17. Describe Various Types of Functions Available in SQL
      18. Use Character, Number, and Date Functions in SELECT Statements
      19. Describe Various Types of Conversion Functions Available in SQL
      20. Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
      21. Apply Conditional Expressions in a SELECT Statement
      22. Self Test
      23. Self Test Answers
    5. CHAPTER 11 Group Functions
      1. Exam Objectives
      2. The Group Functions
      3. Definition of Group Functions
      4. Using Group Functions
      5. Group Data Using the GROUP BY Clause
      6. Creating Groups of Data
      7. The GROUP BY Clause
      8. Grouping by Multiple Columns
      9. Nested Group Functions
      10. Include or Exclude Grouped Rows Using the HAVING Clause
      11. Restricting Group Results
      12. The HAVING Clause
      13. Two-Minute Drill
      14. Describe the Group Functions
      15. Identify the Available Group Functions
      16. Group Data Using the GROUP BY Clause
      17. Include or Exclude Grouped Rows Using the HAVING Clause
      18. Self Test
      19. Self Test Answers
    6. CHAPTER 12 SQL Joins
      1. Exam Objectives
      2. Write SELECT Statements to Access Data from More Than One Table
      3. Using Equijoins and Nonequijoins Types of Joins
      4. Joining Tables Using SQL:1999 Syntax
      5. Qualifying Ambiguous Column Names
      6. The NATURAL JOIN Clause
      7. The Natural JOIN USING Clause
      8. The Natural JOIN ON Clause
      9. N-Way Joins and Additional Join Conditions
      10. Nonequijoins
      11. Join a Table to Itself Using a Self-Join
      12. Joining a Table to Itself Using the JOIN ON Clause
      13. View Data That Does Not Meet a Join Condition by Using Outer Joins
      14. Inner Versus Outer Joins
      15. Left Outer Joins
      16. Right Outer Joins
      17. Full Outer Joins
      18. Generate a Cartesian Product of Two or More Tables
      19. Creating Cartesian Products Using Cross Joins
      20. Two-Minute Drill
      21. Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
      22. Join a Table to Itself Using a Self-Join
      23. View Data That Does Not Meet a Join Condition Using Outer Joins
      24. Generate a Cartesian Product of Two or More Tables
      25. Self Test
      26. Self Test Answers
    7. CHAPTER 13 Subqueries and Set Operators
      1. Exam Objectives
      2. Define Subqueries
      3. Describe the Types of Problems That the Subqueries Can Solve
      4. Use of a Subquery Result Set for Comparison Purposes
      5. Generate a Table from Which to SELECT
      6. Generate Values for Projection
      7. Generate Rows to Be Passed to a DML Statement
      8. List the Types of Subqueries
      9. Single- and Multiple-Row Subqueries
      10. Correlated Subqueries
      11. Write Single-Row and Multiple-Row Subqueries
      12. Describe the Set Operators
      13. Sets and Venn Diagrams
      14. Set Operator General Principles
      15. Use a Set Operator to Combine Multiple Queries into a Single Query
      16. The UNION ALL Operator
      17. The UNION Operator
      18. The INTERSECT Operator
      19. The MINUS Operator
      20. More Complex Examples
      21. Control the Order of Rows Returned
      22. Two-Minute Drill
      23. Define Subqueries
      24. Describe the Types of Problems That the Subqueries Can Solve
      25. List the Types of Subqueries
      26. Write Single-Row and Multiple-Row Subqueries
      27. Describe the Set Operators
      28. Use a Set Operator to Combine Multiple Queries into a Single Query
      29. Control the Order of Rows Returned
      30. Self Test
      31. Self Test Answers
  9. PART III Advanced Database Administration
    1. CHAPTER 14 Configuring the Database for Backup and Recovery
      1. Exam Objectives
      2. Backup and Recovery Issues
      3. Categories of Failures
      4. Statement Failure
      5. User Process Failure
      6. Network Failure
      7. User Errors
      8. Media Failure
      9. Instance Failure
      10. Instance Recovery
      11. The Mechanics of Instance Recovery
      12. The Impossibility of Database Corruption
      13. Tuning Instance Recovery
      14. The MTTR Advisor and Checkpoint Auto-Tuning
      15. Checkpointing
      16. Preparing the Database for Recoverability
      17. Protecting the Controlfile
      18. Protecting the Online Redo Log Files
      19. Archivelog Mode and the Archiver Process
      20. Protecting the Archive Redo Log Files
      21. The Flash Recovery Area
      22. Recovery Files
      23. Configure the Flash Recovery Area
      24. Flash Recovery Area Space Usage
      25. Two-Minute Drill
      26. Identify the Types of Failure That Can Occur in an Oracle Database
      27. Describe Ways to Tune Instance Recovery
      28. Identify the Importance of Checkpoints, Redo Log Files, and Archived Log Files
      29. Configure ARCHIVELOG Mode
      30. Configure Multiple Archive Log File Destinations to Increase Availability
      31. Overview of the Flash Recovery Area
      32. Configure the Flash Recovery Area
      33. Use the Flash Recovery Area
      34. Self Test
      35. Self Test Answers
    2. CHAPTER 15 Back Up with RMAN
      1. Exam Objectives
      2. Backup Concepts and Terminology
      3. Using the RMAN BACKUP Command to Create Backups
      4. Server-Managed Consistent Backups
      5. Server-Managed Open Backups
      6. Incremental Backups
      7. Image Copies
      8. Protect Your Backups
      9. Parallelizing Backup Operations
      10. Encrypting Backups
      11. Configuring RMAN Defaults
      12. Managing and Monitoring RMAN Backups
      13. The LIST, REPORT, and DELETE Commands
      14. Archival Backups
      15. The Dynamic Performance Views
      16. Crosschecking Backups
      17. Two-Minute Drill
      18. Create Consistent Database Backups
      19. Back Up Your Database Without Shutting It Down
      20. Create Incremental Backups
      21. Automate Database Backups
      22. Manage Backups, View Backup Reports, and Monitor the Flash Recovery Area
      23. Define, Apply, and Use a Retention Policy
      24. Create Image File Backups
      25. Create a Whole Database Backup
      26. Enable Fast Incremental Backup
      27. Create Duplex Backups and Back Up Backup Sets
      28. Create an Archival Backup for Long-Term Retention
      29. Create a Multisection, Compressed, and Encrypted Backup
      30. Report On and Maintain Backups
      31. Configure Backup Settings
      32. Allocate Channels to Use in Backing Up
      33. Configure Backup Optimization
      34. Self Test
      35. Self Test Answers
    3. CHAPTER 16 Restore and Recover with RMAN
      1. Exam Objectives
      2. The Data Recovery Advisor
      3. The Health Monitor and the ADR
      4. The Capabilities and Limitations of the DRA
      5. Using the Data Recovery Advisor
      6. Database Restore and Recovery
      7. Complete Recovery from Data File Loss Using RMAN
      8. Recovery of Datafiles in Noarchivelog Mode
      9. Recovery of a Noncritical File in Archivelog Mode
      10. Recovering from Loss of a Critical Datafile
      11. Incomplete Recovery
      12. Autobackup and Restore of the Controlfile
      13. Using Image Copies for Recovery
      14. Block Recovery
      15. Detection of Corrupt Blocks
      16. Block Media Recovery
      17. The BLOCK RECOVER Command
      18. Two-Minute Drill
      19. Describe the Data Recovery Advisor
      20. Use the Data Recovery Advisor to Perform Recovery (Controlfile, Redo Log File, and Datafile)
      21. Perform Complete Recovery from a Critical or Noncritical Data File Loss Using RMAN
      22. Perform Incomplete Recovery Using RMAN
      23. Recover Using Incrementally Updated Backups
      24. Switch to Image Copies for Fast Recovery
      25. Recover Using a Backup Control File
      26. Perform Block Media Recovery
      27. Self Test
      28. Self Test Answers
    4. CHAPTER 17 Advanced RMAN Facilities
      1. Exam Objectives
      2. The Recovery Catalog
      3. The Need for a Recovery Catalog
      4. Creating and Connecting to the Catalog
      5. The Virtual Private Catalog
      6. Protecting and Rebuilding the Catalog
      7. Stored Scripts
      8. Using RMAN to Create Databases
      9. Tablespace Point-in-Time Recovery (TSPITR)
      10. The TSPITR Methodology
      11. Perform Automated TSPITR
      12. RMAN Performance and Monitoring
      13. Monitoring RMAN Sessions and Jobs
      14. Tuning RMAN
      15. Tuning the BACKUP Command
      16. Configure RMAN for Asynchronous I/O
      17. Two-Minute Drill
      18. Identify Situations That Require an RMAN Recovery Catalog
      19. Create and Configure a Recovery Catalog
      20. Synchronize the Recovery Catalog
      21. Create and Use RMAN Stored Scripts
      22. Back Up the Recovery Catalog
      23. Create and Use a Virtual Private Catalog
      24. Create a Duplicate Database
      25. Use a Duplicate Database
      26. Restore a Database onto a New Host
      27. Perform Disaster Recovery
      28. Identify the Situations That Require TSPITR
      29. Perform Automated TSPITR
      30. Monitor RMAN Sessions and Jobs
      31. Tune RMAN
      32. Configure RMAN for Asynchronous I/O
      33. Self Test
      34. Self Test Answers
    5. CHAPTER 18 User-Managed Backup, Restore, and Recovery
      1. Exam Objectives
      2. Backup and Recovery in One Page
      3. User-Managed Database Backup
      4. Backup in Noarchivelog Mode
      5. Backup in Archivelog Mode
      6. Backup of the Password and Parameter Files
      7. Media Failure That Does Not Affect Datafiles
      8. Recovery from Loss of a Multiplexed Controlfile
      9. Recovery from Loss of a Multiplexed Online Redo Log File
      10. Recovery from Loss of a Tempfile
      11. Recovery from Loss of Datafiles
      12. Recovery of Datafiles in Noarchivelog Mode
      13. Recovery of a Noncritical Datafile in Archivelog Mode
      14. Recovering a Critical Datafile in Archivelog Mode
      15. User-Managed Incomplete Recovery
      16. Two-Minute Drill
      17. Recover from a Lost TEMP File
      18. Recover from a Lost Redo Log Group
      19. Recover from the Loss of a Password File
      20. Perform User-Managed Complete Database Recovery
      21. Perform User-Managed Incomplete Database Recovery
      22. Perform User-Managed Backups
      23. Identify the Need for Backup Mode
      24. Back Up and Recover a Controlfile
      25. Self Test
      26. Self Test Answers
    6. CHAPTER 19 Flashback
      1. Exam Objectives
      2. The Different Flashback Technologies
      3. Flashback Database
      4. Flashback Query, Transaction, and Table
      5. Flashback Drop
      6. Flashback Data Archive
      7. When to Use Flashback Technology
      8. Flashback Database
      9. Flashback Database Architecture
      10. Configuring Flashback Database
      11. Monitoring Flashback Database
      12. Using Flashback Database
      13. Limiting the Amount of Flashback Data Generated
      14. Flashback Drop
      15. The Implementation of Flashback Drop
      16. Using Flashback Drop
      17. Managing the Recycle Bin
      18. Flashback Query
      19. Basic Flashback Query
      20. Flashback Table Query
      21. Flashback Versions Query
      22. Flashback Transaction Query
      23. Flashback and Undo Data
      24. The Flashback Data Archive
      25. Two-Minute Drill
      26. Restore Dropped Tables from the Recycle Bin
      27. Perform Flashback Query
      28. Use Flashback Transaction
      29. Perform Flashback Table Operations
      30. Configure and Monitor Flashback Database and Perform Flashback Database Operations
      31. Set Up and Use a Flashback Data Archive
      32. Self Test
      33. Self Test Answers
    7. CHAPTER 20 Automatic Storage Management
      1. Exam Objectives
      2. The Purpose of a Logical Volume Manager
      3. RAID Levels
      4. Volume Sizes
      5. Choice of RAID Level
      6. ASM Compared with Third-Party LVMs
      7. The ASM Architecture
      8. The Cluster Synchronization Service
      9. The ASM Disks and Disk Groups
      10. The ASM Instance
      11. The RDBMS Instance
      12. The ASM Files
      13. Creating Raw Devices
      14. Creating, Starting, and Stopping an ASM Instance
      15. Creating ASM Disk Groups
      16. Creating and Using ASM Files
      17. ASM and RMAN
      18. The ASMCMD Utility
      19. Two-Minute Drill
      20. Describe Automatic Storage Management (ASM)
      21. Set Up Initialization Parameter Files for ASM and Database Instances
      22. Start Up and Shut Down ASM Instances
      23. Administer ASM Disk Groups
      24. Self Test
      25. Self Test Answers
    8. CHAPTER 21 The Resource Manager
      1. Exam Objectives
      2. The Need for Resource Management
      3. The Resource Manager Architecture
      4. Consumer Groups
      5. Resource Manager Plans
      6. Resource Manager Configuration Tools
      7. Managing Users and Consumer Groups
      8. Resource Manager Plans
      9. CPU Method
      10. Use of the Ratio CPU Method
      11. The Active Session Pool Method
      12. Limiting the Degree of Parallelism
      13. Controlling Jobs by Execution Time
      14. Terminating Sessions by Idle Time
      15. Restricting Generation of Undo Data
      16. Automatic Consumer Group Switching
      17. Adaptive Consumer Group Mapping
      18. Two-Minute Drill
      19. Understand the Database Resource Manager
      20. Create and Use Database Resource Manager Components
      21. Self Test
      22. Self Test Answers
    9. CHAPTER 22 The Scheduler
      1. Exam Objectives
      2. The Scheduler Architecture
      3. Scheduler Objects
      4. Jobs
      5. Programs
      6. Schedules
      7. Job Classes
      8. Windows
      9. Privileges
      10. Creating and Scheduling Jobs
      11. A Self-Contained Job
      12. Using Programs and Schedules
      13. Event-Driven Jobs
      14. Job Chains
      15. Lightweight Jobs
      16. Using Classes, Windows, and the Resource Manager
      17. Using Job Classes
      18. Using Windows
      19. Two-Minute Drill
      20. Create a Job, Program, and Schedule
      21. Use a Time-Based or Event-Based Schedule for Executing Scheduler Jobs
      22. Create Lightweight Jobs
      23. Use Job Chains to Perform a Series of Related Tasks
      24. Create Windows and Job Classes
      25. Use Advanced Scheduler Concepts to Prioritize Jobs
      26. Self Test
      27. Self Test Answers
    10. CHAPTER 23 Moving and Reorganizing Data
      1. Exam Objectives
      2. SQL*Loader
      3. External Tables
      4. Directories
      5. Using External Tables
      6. Data Pump
      7. Data Pump Architecture
      8. Directories and File Locations
      9. Direct Path or External Table Path?
      10. Using Data Pump Export and Import
      11. Capabilities
      12. Using Data Pump with the Command-Line Utilities
      13. Using Data Pump with Database Control
      14. Tablespace Export and Import
      15. Resumable Space Allocation
      16. Segment Reorganization
      17. Row Chaining and Migration
      18. Segment Shrink
      19. Two-Minute Drill
      20. Describe and Use Methods to Move Data (Directory Objects, SQL*Loader, External Tables)
      21. Explain the General Architecture of Oracle Data Pump
      22. Use Data Pump Export and Import to Move Data Between Oracle Databases
      23. Describe the Concepts of Transportable Tablespaces and Databases
      24. Manage Resumable Space Allocation
      25. Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
      26. Self Test
      27. Self Test Answers
    11. CHAPTER 24 The AWR and the Alert System
      1. Exam Objectives
      2. The Automatic Workload Repository
      3. Gathering AWR Statistics
      4. Managing the AWR
      5. Statistics, Metrics, and Baselines
      6. The DBMS_WORKLOAD_REPOSITORY Package
      7. The Database Advisory Framework
      8. The Automatic Database Diagnostic Monitor
      9. The Advisors
      10. Automatic Maintenance Jobs
      11. Using the Server-Generated Alert System
      12. Alert Condition Monitoring and Notifications
      13. Setting Thresholds
      14. The Notification System
      15. Two-Minute Drill
      16. Use and Manage the Automatic Workload Repository
      17. Use the Advisory Framework
      18. Manage Alerts and Thresholds
      19. Self Test
      20. Self Test Answers
    12. CHAPTER 25 Performance Tuning
      1. Exam Objectives
      2. Managing Memory
      3. PGA Memory Management
      4. SGA Memory Management
      5. Automatic Memory Management
      6. The Memory Advisors
      7. The SQL Tuning Advisor
      8. The Capabilities of the SQL Tuning Advisor
      9. Using the SQL Tuning Advisor with Enterprise Manager
      10. The SQL Tuning Advisor API: the DBMS_SQLTUNE Package
      11. The SQL Access Advisor
      12. Using the SQL Access Advisor with Database Control
      13. Using the SQL Access Advisor with DBMS_ADVISOR
      14. Identifying and Fixing Invalid and Unusable Objects
      15. Invalid Objects
      16. Unusable Indexes
      17. Database Replay
      18. Database Replay Workload Capture
      19. Database Replay Workload Preprocessing
      20. Launch the Replay
      21. Database Replay Analysis and Reporting
      22. Two-Minute Drill
      23. Use Automatic Memory Management
      24. Use Memory Advisors
      25. Troubleshoot Invalid and Unusable Objects
      26. Implement Automatic Memory Management
      27. Manually Configure SGA Parameters
      28. Configure Automatic PGA Memory Management
      29. Use the SQL Tuning Advisor
      30. Use the SQL Access Advisor to Tune a Workload
      31. Understand Database Replay
      32. Self Test
      33. Self Test Answers
    13. CHAPTER 26 Globalization
      1. Exam Objectives
      2. Globalization Requirements and Capabilities
      3. Character Sets
      4. Language Support
      5. Territory Support
      6. Other NLS Settings
      7. Using Globalization Support Features
      8. Choosing a Character Set
      9. Changing Character Sets
      10. Globalization Within the Database
      11. Globalization at the Instance Level
      12. Client-Side Environment Settings
      13. Session-Level Globalization Settings
      14. Statement Globalization Settings
      15. Languages and Time Zones
      16. Linguistic Sorting and Selection
      17. The Locale Builder
      18. Using Time Zones
      19. Two-Minute Drill
      20. Customize Language-Dependent Behavior for the Database and Individual Sessions
      21. Work with Database and NLS Character Sets
      22. Self Test
      23. Self Test Answers
    14. CHAPTER 27 The Intelligent Infrastructure
      1. Exam Objectives
      2. The Enterprise Manager Support Workbench
      3. The Automatic Diagnostic Repository (ADR)
      4. Problems and Incidents
      5. The ADR Command-Line Interface (ADRCI)
      6. The Support Workbench
      7. Patches
      8. Types of Patch
      9. Integration with MetaLink and the Patch Advisor
      10. Applying Patches
      11. Two-Minute Drill
      12. Use the Enterprise Manager Support Workbench
      13. Manage Patches
      14. Set Up the Automatic Diagnostic Repository
      15. Self Test
      16. Self Test Answers
  10. APPENDIX 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
  11. Glossary
  12. Index

Product information

  • Title: OCA/OCP Oracle Database 11g All-in-One Exam Guide
  • Author(s): John Watson, Roopesh Ramklass, Bob Bryla
  • Release date: September 2009
  • Publisher(s): Oracle Press
  • ISBN: 9780071629218