OCA Oracle® Database 11g Administrator Certified Associate: Study Guide

OCA Oracle® Database 11g Administrator Certified Associate: Study Guide

by
Released April 2009
Publisher(s): Sybex
ISBN: 9780470395127

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you’ll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more.

Table of contents

  1. Copyright
  2. Acknowledgments
  3. About the Author
  4. Introduction
    1. Why Become Oracle Certified?
    2. Oracle Certifications
    3. Oracle Database 11g Administrator Certified Associate
    4. Oracle Database 11g Administrator Certified Professional
    5. Oracle Database 11g Administrator Certified Master
    6. More Information and Resources
    7. OCA/OCP Study Guides
    8. Oracle Exam Requirements
    9. OCA SQL (1Z0-051) Requirements
    10. OCA Admin I (1Z0-052) Requirements
    11. Tips for Taking the OCA Exams
    12. What Is Covered in This Book
      1. Part I: Oracle Database 11g SQL Fundamentals I
      2. Part II: Oracle Database 11g Administration I
    13. How to Use This Book
    14. How to Contact the Author
    15. SQL Fundamentals I Assessment Test
    16. Answers to SQL Fundamentals I Assessment Test
    17. Administration I Assessment Test
    18. Answers to Administration I Assessment Test
  5. I. Oracle Database 11g: SQL Fundamentals I
    1. 1. Introducing SQL
      1. 1.1. SQL Fundamentals
        1. 1.1.1. SQL Tools: SQL*Plus
          1. 1.1.1.1. Entering SQL Statements
          2. 1.1.1.2. Entering SQL*Plus Commands
          3. 1.1.1.3. Getting Information with the DESCRIBE Command
          4. 1.1.1.4. Editing the SQL Buffer
            1. 1.1.1.4.1. LIST
            2. 1.1.1.4.2. APPEND
            3. 1.1.1.4.3. CHANGE
            4. 1.1.1.4.4. INPUT
            5. 1.1.1.4.5. DEL
            6. 1.1.1.4.6. CLEAR BUFFER
          5. 1.1.1.5. Using Script Files
            1. 1.1.1.5.1. Saving Query Results to a File
            2. 1.1.1.5.2. Adding Comments to a Script File
        2. 1.1.2. Oracle Datatypes
          1. 1.1.2.1. CHAR(<size>)
          2. 1.1.2.2. VARCHAR2(<size>)
          3. 1.1.2.3. NUMBER (<p>, <s>)
          4. 1.1.2.4. DATE
          5. 1.1.2.5. TIMESTAMP [<precision>]
        3. 1.1.3. Operators and Literals
          1. 1.1.3.1. Arithmetic Operators
          2. 1.1.3.2. Concatenation Operator
          3. 1.1.3.3. Operator Precedence
          4. 1.1.3.4. Literals
            1. 1.1.3.4.1. Text Literals
            2. 1.1.3.4.2. Numeric Literals
            3. 1.1.3.4.3. Datetime Literals
            4. 1.1.3.4.4. Interval Literals
      2. 1.2. Writing Simple Queries
        1. 1.2.1. Using the SELECT Statement
          1. 1.2.1.1. Column Alias Names
          2. 1.2.1.2. Ensuring Uniqueness
          3. 1.2.1.3. The DUAL Table
        2. 1.2.2. Limiting Rows
          1. 1.2.2.1. Comparison Operators
            1. 1.2.2.1.1. = (Equality)
            2. 1.2.2.1.2. !=, <>, or ⁁= (Inequality)
            3. 1.2.2.1.3. < (Less Than)
            4. 1.2.2.1.4. > (Greater Than)
            5. 1.2.2.1.5. <= (Less Than or Equal to)
            6. 1.2.2.1.6. >= (Greater Than or Equal to)
            7. 1.2.2.1.7. ANY or SOME
            8. 1.2.2.1.8. ALL
          2. 1.2.2.2. Logical Operators
            1. 1.2.2.2.1. NOT
            2. 1.2.2.2.2. AND
            3. 1.2.2.2.3. OR
            4. 1.2.2.2.4. Logical Operator Truth Tables
          3. 1.2.2.3. Other Operators
            1. 1.2.2.3.1. IN and NOT IN
            2. 1.2.2.3.2. BETWEEN
            3. 1.2.2.3.3. EXISTS
            4. 1.2.2.3.4. IS NULL and IS NOT NULL
            5. 1.2.2.3.5. LIKE
        3. 1.2.3. Sorting Rows
          1. 1.2.3.1. Sorting NULLs
        4. 1.2.4. Using Expressions
          1. 1.2.4.1. The CASE Expression
      3. 1.3. Accepting Values at Runtime
        1. 1.3.1. Using Substitution Variables
        2. 1.3.2. Saving a Variable for a Session
        3. 1.3.3. Using Positional Notation for Variables
      4. 1.4. Summary
      5. 1.5. Exam Essentials
      6. 1.6. Review Questions
      7. 1.7. Answers to Review Questions
    2. 2. Using Single-Row Functions
      1. 2.1. Single-Row Function Fundamentals
        1. 2.1.1. Functions for NULL Handling
          1. 2.1.1.1. NVL
          2. 2.1.1.2. NVL2
          3. 2.1.1.3. COALESCE
      2. 2.2. Using Single-Row Character Functions
        1. 2.2.1. Character Function Overview
        2. 2.2.2. Character Function Descriptions
          1. 2.2.2.1. ASCII
          2. 2.2.2.2. CHR
          3. 2.2.2.3. CONCAT
          4. 2.2.2.4. INITCAP
          5. 2.2.2.5. INSTR
          6. 2.2.2.6. INSTRB
          7. 2.2.2.7. LENGTH
          8. 2.2.2.8. LENGTHB
          9. 2.2.2.9. LOWER
          10. 2.2.2.10. LPAD
          11. 2.2.2.11. LTRIM
          12. 2.2.2.12. REPLACE
          13. 2.2.2.13. RPAD
          14. 2.2.2.14. RTRIM
          15. 2.2.2.15. SOUNDEX
          16. 2.2.2.16. SUBSTR
          17. 2.2.2.17. SUBSTRB
          18. 2.2.2.18. TRANSLATE
          19. 2.2.2.19. TRIM
          20. 2.2.2.20. UPPER
      3. 2.3. Using Single-Row Numeric Functions
        1. 2.3.1. Numeric Function Overview
        2. 2.3.2. Numeric Function Descriptions
          1. 2.3.2.1. ABS
          2. 2.3.2.2. ACOS
          3. 2.3.2.3. ASIN
          4. 2.3.2.4. ATAN
          5. 2.3.2.5. ATAN2
          6. 2.3.2.6. BITAND
          7. 2.3.2.7. CEIL
          8. 2.3.2.8. COS
          9. 2.3.2.9. COSH
          10. 2.3.2.10. EXP
          11. 2.3.2.11. FLOOR
          12. 2.3.2.12. LN
          13. 2.3.2.13. LOG
          14. 2.3.2.14. MOD
          15. 2.3.2.15. NANVL
          16. 2.3.2.16. POWER
          17. 2.3.2.17. REMAINDER
          18. 2.3.2.18. ROUND
          19. 2.3.2.19. SIGN
          20. 2.3.2.20. SIN
          21. 2.3.2.21. SINH
          22. 2.3.2.22. SQRT
          23. 2.3.2.23. TAN
          24. 2.3.2.24. TANH
          25. 2.3.2.25. TRUNC
          26. 2.3.2.26. WIDTH_BUCKET
      4. 2.4. Using Single-Row Date Functions
        1. 2.4.1. Date-Format Conversion
        2. 2.4.2. Date-Function Overview
        3. 2.4.3. Date-Function Descriptions
          1. 2.4.3.1. SYSDATE
          2. 2.4.3.2. SYSTIMESTAMP
          3. 2.4.3.3. LOCALTIMESTAMP
          4. 2.4.3.4. ADD_MONTHS
          5. 2.4.3.5. CURRENT_DATE
          6. 2.4.3.6. CURRENT_TIMESTAMP
          7. 2.4.3.7. DBTIMEZONE
          8. 2.4.3.8. EXTRACT
          9. 2.4.3.9. FROM_TZ
          10. 2.4.3.10. LAST_DAY
          11. 2.4.3.11. MONTHS_BETWEEN
          12. 2.4.3.12. NEW_TIME
          13. 2.4.3.13. NEXT_DAY
          14. 2.4.3.14. ROUND
          15. 2.4.3.15. SESSIONTIMEZONE
          16. 2.4.3.16. SYS_EXTRACT_UTC
          17. 2.4.3.17. TRUNC
          18. 2.4.3.18. TZ_OFFSET
      5. 2.5. Using Single-Row Conversion Functions
        1. 2.5.1. Conversion-Function Overview
        2. 2.5.2. Conversion-Function Descriptions
          1. 2.5.2.1. ASCIISTR
          2. 2.5.2.2. BIN_TO_NUM
          3. 2.5.2.3. CAST
          4. 2.5.2.4. CHARTOROWID
          5. 2.5.2.5. COMPOSE
          6. 2.5.2.6. CONVERT
          7. 2.5.2.7. DECOMPOSE
          8. 2.5.2.8. HEXTORAW
          9. 2.5.2.9. NUMTODSINTERVAL
          10. 2.5.2.10. NUMTOYMINTERVAL
          11. 2.5.2.11. RAWTOHEX
          12. 2.5.2.12. ROWIDTOCHAR
          13. 2.5.2.13. SCN_TO_TIMESTAMP
          14. 2.5.2.14. TIMESTAMP_TO_SCN
          15. 2.5.2.15. TO_BINARY_DOUBLE
          16. 2.5.2.16. TO_BINARY_FLOAT
          17. 2.5.2.17. TO_CHAR
            1. 2.5.2.17.1. Date Conversion
            2. 2.5.2.17.2. Number Conversion
          18. 2.5.2.18. TO_CLOB
          19. 2.5.2.19. TO_DATE
          20. 2.5.2.20. TO_DSINTERVAL
          21. 2.5.2.21. TO_LOB
          22. 2.5.2.22. TO_MULTI_BYTE
          23. 2.5.2.23. TO_NUMBER
          24. 2.5.2.24. TO_SINGLE_BYTE
          25. 2.5.2.25. TO_TIMESTAMP
          26. 2.5.2.26. TO_TIMESTAMP_TZ
          27. 2.5.2.27. TO_YMINTERVAL
          28. 2.5.2.28. UNISTR
      6. 2.6. Using Other Single-Row Functions
        1. 2.6.1. Miscellaneous-Function Overview
        2. 2.6.2. Miscellaneous-Function Descriptions
          1. 2.6.2.1. BFILENAME
          2. 2.6.2.2. DECODE
          3. 2.6.2.3. DUMP
          4. 2.6.2.4. EMPTY_BLOB
          5. 2.6.2.5. EMPTY_CLOB
          6. 2.6.2.6. GREATEST
          7. 2.6.2.7. LEAST
          8. 2.6.2.8. NULLIF
          9. 2.6.2.9. ORA_HASH
          10. 2.6.2.10. SYS_CONTEXT
          11. 2.6.2.11. SYS_GUID
          12. 2.6.2.12. UID
          13. 2.6.2.13. USER
          14. 2.6.2.14. USERENV
          15. 2.6.2.15. VSIZE
      7. 2.7. Summary
      8. 2.8. Exam Essentials
      9. 2.9. Review Questions
      10. 2.10. Answers to Review Questions
    3. 3. Using Group Functions
      1. 3.1. Group-Function Fundamentals
      2. 3.2. Utilizing Aggregate Functions
        1. 3.2.1. Grouping Data with GROUP BY
        2. 3.2.2. Group-Function Overview
        3. 3.2.3. Group-Function Descriptions: Part 1
          1. 3.2.3.1. AVG
          2. 3.2.3.2. COUNT
          3. 3.2.3.3. MAX
          4. 3.2.3.4. MIN
          5. 3.2.3.5. SUM
          6. 3.2.3.6. MEDIAN
          7. 3.2.3.7. STDDEV
          8. 3.2.3.8. VARIANCE
        4. 3.2.4. Group-Function Descriptions: Part 2
          1. 3.2.4.1. CORR
          2. 3.2.4.2. COVAR_POP
          3. 3.2.4.3. COVAR_SAMP
          4. 3.2.4.4. CUME_DIST
          5. 3.2.4.5. DENSE_RANK
          6. 3.2.4.6. FIRST
          7. 3.2.4.7. GROUP_ID
          8. 3.2.4.8. GROUPING
          9. 3.2.4.9. GROUPING_ID
          10. 3.2.4.10. KEEP
          11. 3.2.4.11. LAST
          12. 3.2.4.12. PERCENT_RANK
          13. 3.2.4.13. PERCENTILE_CONT
          14. 3.2.4.14. PERCENTILE_DISC
          15. 3.2.4.15. RANK
          16. 3.2.4.16. STDDEV_POP
          17. 3.2.4.17. STDDEV_SAMP
          18. 3.2.4.18. VAR_POP
          19. 3.2.4.19. VAR_SAMP
        5. 3.2.5. Limiting Grouped Data with HAVING
        6. 3.2.6. Creating Superaggregates with CUBE and ROLLUP
          1. 3.2.6.1. Using ROLLUP
          2. 3.2.6.2. Using CUBE
        7. 3.2.7. Nesting Functions
          1. 3.2.7.1. Nesting Single-Row Functions with Group Functions
          2. 3.2.7.2. Nesting Group Functions
      3. 3.3. Summary
      4. 3.4. Exam Essentials
      5. 3.5. Review Questions
      6. 3.6. Answers to Review Questions
    4. 4. Using Joins and Subqueries
      1. 4.1. Writing Multiple-Table Queries
        1. 4.1.1. Inner Joins
          1. 4.1.1.1. Simple Inner Joins
          2. 4.1.1.2. Complex Inner Joins
          3. 4.1.1.3. Using Table Aliases
          4. 4.1.1.4. Using the ANSI Syntax
            1. 4.1.1.4.1. NATURAL JOIN
            2. 4.1.1.4.2. JOIN...USING
            3. 4.1.1.4.3. JOIN...ON
          5. 4.1.1.5. Multitable Joins
        2. 4.1.2. Cartesian Joins
          1. 4.1.2.1. Using the ANSI Syntax
        3. 4.1.3. Outer Joins
          1. 4.1.3.1. Using the ANSI Syntax
            1. 4.1.3.1.1. Left Outer Joins
            2. 4.1.3.1.2. Right Outer Joins
            3. 4.1.3.1.3. Full Outer Joins
        4. 4.1.4. Other Multiple-Table Queries
          1. 4.1.4.1. Self-Joins
          2. 4.1.4.2. Nonequality Joins
      2. 4.2. Using Set Operators
        1. 4.2.1. The UNION Operator
        2. 4.2.2. The UNION ALL Operator
        3. 4.2.3. The INTERSECT Operator
        4. 4.2.4. The MINUS Operator
        5. 4.2.5. Putting It All Together
      3. 4.3. Subqueries
        1. 4.3.1. Single-Row Subqueries
        2. 4.3.2. Multiple-Row Subqueries
        3. 4.3.3. Subquery Returns No Rows
        4. 4.3.4. Correlated Subqueries
        5. 4.3.5. Scalar Subqueries
          1. 4.3.5.1. A Scalar Subquery in a CASE Expression
          2. 4.3.5.2. A Scalar Subquery in a SELECT Clause
          3. 4.3.5.3. A Scalar Subquery in SELECT and WHERE Clauses
          4. 4.3.5.4. A Scalar Subquery in an ORDER BY Clause
        6. 4.3.6. Multiple-Column Subqueries
        7. 4.3.7. Subqueries in Other DML Statements
      4. 4.4. Summary
      5. 4.5. Exam Essentials
      6. 4.6. Review Questions
      7. 4.7. Answers to Review Questions
    5. 5. Manipulating Data
      1. 5.1. Using DML Statements
        1. 5.1.1. Inserting Rows into a Table
          1. 5.1.1.1. Inserting Rows from a Subquery
          2. 5.1.1.2. Inserting Rows into Multiple Tables
        2. 5.1.2. Updating Rows in a Table
          1. 5.1.2.1. Updating Rows Using a Subquery
        3. 5.1.3. Deleting Rows from a Table
          1. 5.1.3.1. Truncating a Table
            1. 5.1.3.1.1. TRUNCATE vs. DELETE
        4. 5.1.4. Merging Rows
      2. 5.2. Understanding Transaction Control
        1. 5.2.1. Savepoints and Partial Rollbacks
        2. 5.2.2. Data Visibility
          1. 5.2.2.1. Consistency and Transactions
          2. 5.2.2.2. Locking Mechanism
      3. 5.3. Summary
      4. 5.4. Exam Essentials
      5. 5.5. Review Questions
      6. 5.6. Answers to Review Questions
    6. 6. Creating Tables and Constraints
      1. 6.1. Database Objects Overview
        1. 6.1.1. Schema Objects
      2. 6.2. Built-in Datatypes
        1. 6.2.1. Character Datatypes
          1. 6.2.1.1. CHAR
          2. 6.2.1.2. NCHAR
          3. 6.2.1.3. VARCHAR2 or VARCHAR
          4. 6.2.1.4. NVARCHAR2
          5. 6.2.1.5. CLOB
          6. 6.2.1.6. NCLOB
          7. 6.2.1.7. LONG
        2. 6.2.2. Numeric Datatypes
          1. 6.2.2.1. NUMBER
          2. 6.2.2.2. BINARY_FLOAT
          3. 6.2.2.3. BINARY_DOUBLE
          4. 6.2.2.4. FLOAT
        3. 6.2.3. Date and Time Datatypes
          1. 6.2.3.1. DATE
          2. 6.2.3.2. TIMESTAMP
          3. 6.2.3.3. TIMESTAMP WITH TIME ZONE
          4. 6.2.3.4. TIMESTAMP WITH LOCAL TIME ZONE
          5. 6.2.3.5. INTERVAL YEAR TO MONTH
          6. 6.2.3.6. INTERVAL DAY TO SECOND
        4. 6.2.4. Date Arithmetic
        5. 6.2.5. Binary Datatypes
          1. 6.2.5.1. RAW
          2. 6.2.5.2. LONG RAW
          3. 6.2.5.3. BLOB
          4. 6.2.5.4. BFILE
        6. 6.2.6. Row ID Datatypes
          1. 6.2.6.1. ROWID
          2. 6.2.6.2. UROWID
      3. 6.3. Creating Tables
        1. 6.3.1. Naming Tables and Columns
        2. 6.3.2. Specifying Default Values for Columns
        3. 6.3.3. Adding Comments
        4. 6.3.4. Creating a Table from Another Table
      4. 6.4. Modifying Tables
        1. 6.4.1. Adding Columns
        2. 6.4.2. Modifying Columns
        3. 6.4.3. Renaming Columns
        4. 6.4.4. Dropping Columns
        5. 6.4.5. Dropping Tables
        6. 6.4.6. Renaming Tables
        7. 6.4.7. Making Tables Read-Only
      5. 6.5. Managing Constraints
        1. 6.5.1. Creating Constraints
          1. 6.5.1.1. NOT NULL Constraint
          2. 6.5.1.2. Check Constraints
          3. 6.5.1.3. Unique Constraints
          4. 6.5.1.4. Primary Key Constraints
          5. 6.5.1.5. Foreign Key Constraints
          6. 6.5.1.6. Disabled Constraints
        2. 6.5.2. Dropping Constraints
        3. 6.5.3. Enabling and Disabling Constraints
          1. 6.5.3.1. Validated Constraints
        4. 6.5.4. Deferring Constraint Checks
      6. 6.6. Summary
      7. 6.7. Exam Essentials
      8. 6.8. Review Questions
      9. 6.9. Answers to Review Questions
    7. 7. Creating Schema Objects
      1. 7.1. Creating and Modifying Views
        1. 7.1.1. Using Defined Column Names
        2. 7.1.2. Creating Views with Errors
        3. 7.1.3. Creating Read-Only Views
        4. 7.1.4. Creating Constraints on Views
        5. 7.1.5. Modifying Views
          1. 7.1.5.1. Changing a View's Definition
          2. 7.1.5.2. Recompiling a View
        6. 7.1.6. Dropping a View
        7. 7.1.7. Using Views
          1. 7.1.7.1. Using Views in Queries
          2. 7.1.7.2. Inserting, Updating, and Deleting Data through Views
          3. 7.1.7.3. Using Join Views
          4. 7.1.7.4. Viewing Allowable DML Operations
          5. 7.1.7.5. Using Inline Views
          6. 7.1.7.6. Performing Top-n Analysis
      2. 7.2. Creating and Managing Sequences
        1. 7.2.1. Creating and Dropping Sequences
        2. 7.2.2. Using Sequences
          1. 7.2.2.1. Sequence Initialization
          2. 7.2.2.2. Missing Sequence Values
          3. 7.2.2.3. Maximum and Minimum Values
        3. 7.2.3. Altering Sequences
      3. 7.3. Creating and Managing Synonyms
        1. 7.3.1. Creating and Dropping Synonyms
          1. 7.3.1.1. Public Synonyms
          2. 7.3.1.2. Private Synonyms
        2. 7.3.2. Resolving Object References
      4. 7.4. Creating and Managing Indexes
        1. 7.4.1. How Indexes Work
        2. 7.4.2. Using B-Tree Indexes
        3. 7.4.3. Using Bitmap Indexes
        4. 7.4.4. Dropping Indexes
      5. 7.5. Summary
      6. 7.6. Exam Essentials
      7. 7.7. Review Questions
      8. 7.8. Answers to Review Questions
  6. II. Oracle Database 11g: Administration I
    1. 8. Introducing Oracle Database 11g Components and Architecture
      1. 8.1. Oracle Database Fundamentals
      2. 8.2. Relational Databases
      3. 8.3. Oracle Database 11g Objects
      4. 8.4. Interacting with Oracle 11g
        1. 8.4.1. SQL*Plus
        2. 8.4.2. SQL Developer
        3. 8.4.3. Enterprise Manager Database Control
      5. 8.5. Oracle 11g Architecture
      6. 8.6. User Processes
      7. 8.7. The Oracle Instance
        1. 8.7.1. Oracle Memory Structures
          1. 8.7.1.1. Database Buffer Cache
          2. 8.7.1.2. Redo Log Buffer
          3. 8.7.1.3. Shared Pool
          4. 8.7.1.4. Large Pool
          5. 8.7.1.5. Java Pool
          6. 8.7.1.6. Streams Pool
        2. 8.7.2. Oracle Processes Structures
          1. 8.7.2.1. Database Writer (DBWn)
          2. 8.7.2.2. Checkpoint (CKPT)
          3. 8.7.2.3. Log Writer (LGWR)
          4. 8.7.2.4. Process Monitor (PMON)
          5. 8.7.2.5. System Monitor (SMON)
      8. 8.8. Oracle Storage Structures
        1. 8.8.1. Control Files
        2. 8.8.2. Data Files
        3. 8.8.3. Redo Log Files
        4. 8.8.4. The Logical Structure
      9. 8.9. Installing Oracle 11g
      10. 8.10. Review the Documentation
      11. 8.11. Review the System Requirements
      12. 8.12. Plan Your Install
        1. 8.12.1. Creating the Oracle User Account
        2. 8.12.2. Naming Volumes and Mount Points
        3. 8.12.3. Creating OFA Directory Paths
      13. 8.13. Using the Oracle Universal Installer
        1. 8.13.1. Mounting the CD and Starting the OUI
        2. 8.13.2. Performing Preinstallation Checks
        3. 8.13.3. Responding to OUI Prompts
        4. 8.13.4. Selecting Products to Install
        5. 8.13.5. Copying and Compiling Files
        6. 8.13.6. Performing Postinstall Tasks
      14. 8.14. Summary
      15. 8.15. Exam Essentials
      16. 8.16. Review Questions
      17. 8.17. Answers to Review Questions
    2. 9. Creating an Oracle 11g Database
      1. 9.1. Using DBCA to Create Oracle 11g Databases
        1. 9.1.1. Invoking the Database Configuration Assistant
          1. 9.1.1.1. Database Templates
          2. 9.1.1.2. Database Identification
          3. 9.1.1.3. Management Options
          4. 9.1.1.4. Database Credentials
          5. 9.1.1.5. Storage Options
            1. 9.1.1.5.1. File System Storage
            2. 9.1.1.5.2. ASM Storage
            3. 9.1.1.5.3. Raw Devices
          6. 9.1.1.6. Database File Locations
            1. 9.1.1.6.1. Use Database File Locations from Template
            2. 9.1.1.6.2. Use Common Location for all Database Files
            3. 9.1.1.6.3. Use Oracle-Managed Files
          7. 9.1.1.7. Recovery Configuration
            1. 9.1.1.7.1. Flash Recovery
            2. 9.1.1.7.2. Enable Archive Logging
          8. 9.1.1.8. Database Content
          9. 9.1.1.9. Sample Schemas and Custom Scripts
          10. 9.1.1.10. Initialization Parameters
            1. 9.1.1.10.1. The Memory Tab
            2. 9.1.1.10.2. The Sizing Tab
            3. 9.1.1.10.3. The Character Sets Tab
            4. 9.1.1.10.4. The Connection Mode Tab
          11. 9.1.1.11. Security and Maintenance Settings
          12. 9.1.1.12. Database Storage
          13. 9.1.1.13. Creation Options
        2. 9.1.2. Configuring an Oracle Database Using the DBCA
        3. 9.1.3. Deleting an Oracle Database Using the DBCA
        4. 9.1.4. Managing Database Templates Using the DBCA
          1. 9.1.4.1. Creating Template Definitions Using the DBCA
          2. 9.1.4.2. Deleting Template Definitions Using the DBCA
      2. 9.2. Working with Oracle 11g Metadata
        1. 9.2.1. Data Dictionary Views
        2. 9.2.2. Dynamic Performance Views
      3. 9.3. Managing Initialization-Parameter Files
        1. 9.3.1. Locating the Default Parameter File
        2. 9.3.2. Modifying Initialization-Parameter Values
          1. 9.3.2.1. Using EM Database Control
          2. 9.3.2.2. Using SQL*Plus
            1. 9.3.2.2.1. V$PARAMETER
            2. 9.3.2.2.2. V$SPPARAMETER
            3. 9.3.2.2.3. V$PARAMETER vs. V$SPPARAMETER
      4. 9.4. Starting Up and Shutting Down an Oracle Instance
        1. 9.4.1. Starting Up an Oracle 11g Database
          1. 9.4.1.1. Starting Up Oracle Using EM Database Control
          2. 9.4.1.2. Starting Oracle Using SQL*Plus
          3. 9.4.1.3. Changing Database Startup States Using SQL
        2. 9.4.2. Shutting Down an Oracle 11g Database
          1. 9.4.2.1. Shutting Down Oracle Using EM Database Control
          2. 9.4.2.2. Shutting Down Oracle Using SQL*Plus
      5. 9.5. Monitoring the Database Alert Log
      6. 9.6. Summary
      7. 9.7. Exam Essentials
      8. 9.8. Review Questions
      9. 9.9. Answers to Review Questions
    3. 10. Allocating Database Storage and Creating Schema Objects
      1. 10.1. Tablespaces and Data Files Overview
      2. 10.2. Managing Tablespaces
        1. 10.2.1. Identifying Default Tablespaces
        2. 10.2.2. Creating and Maintaining Tablespaces
          1. 10.2.2.1. Creating Bigfile and Smallfile Tablespaces
          2. 10.2.2.2. Working with Oracle Managed File Tablespaces
          3. 10.2.2.3. Choosing Extent Management
          4. 10.2.2.4. Choosing Segment Space Management
          5. 10.2.2.5. Choosing Other Tablespace Options
          6. 10.2.2.6. Using Nonstandard Block Sizes
          7. 10.2.2.7. Creating Temporary Tablespaces
          8. 10.2.2.8. Creating Undo Tablespaces
          9. 10.2.2.9. Removing Tablespaces
          10. 10.2.2.10. Modifying Tablespaces
            1. 10.2.2.10.1. Changing Storage Defaults
            2. 10.2.2.10.2. Adding a Data File to a Tablespace
            3. 10.2.2.10.3. Taking a Tablespace Offline or Online
            4. 10.2.2.10.4. Making a Tablespace Read-Only
            5. 10.2.2.10.5. Putting a Tablespace in Backup Mode
        3. 10.2.3. Obtaining Tablespace Information
          1. 10.2.3.1. Obtaining Tablespace Information Using SQL*Plus
          2. 10.2.3.2. Obtaining Tablespace Information Using the EM Database Control
      3. 10.3. Managing Data Files
        1. 10.3.1. Performing Operations on Data Files
          1. 10.3.1.1. Sizing Files
          2. 10.3.1.2. Making Files Online and Offline
          3. 10.3.1.3. Renaming Files
            1. 10.3.1.3.1. Renaming a Data File
            2. 10.3.1.3.2. Relocating a Tablespace
            3. 10.3.1.3.3. Renaming or Relocating Files Belonging to Multiple Tablespaces
            4. 10.3.1.3.4. Moving Read-Only Tablespaces
        2. 10.3.2. Using the Oracle Managed Files Feature
          1. 10.3.2.1. Enabling the Oracle Managed Files Feature
          2. 10.3.2.2. Creating Databases Using the OMF Feature
          3. 10.3.2.3. Creating Tablespaces Using the OMF Feature
          4. 10.3.2.4. Overriding the Default File Size
        3. 10.3.3. Querying Data File Information
          1. 10.3.3.1. V$DATAFILE
          2. 10.3.3.2. V$TEMPFILE
          3. 10.3.3.3. DBA_DATA_FILES
          4. 10.3.3.4. DBA_TEMP_FILES
      4. 10.4. Working with Schema Objects
        1. 10.4.1. A Little Background on Creating Tables
          1. 10.4.1.1. Creating a Table
            1. 10.4.1.1.1. Storing LOB Structures
            2. 10.4.1.1.2. Using Other Create Clauses
          2. 10.4.1.2. Creating a Table Using a Subquery
          3. 10.4.1.3. Creating a Temporary Table
          4. 10.4.1.4. Reorganizing Tables
          5. 10.4.1.5. Truncating a Table
          6. 10.4.1.6. Using Namespaces
        2. 10.4.2. Working with Constraints
          1. 10.4.2.1. NOT NULL
          2. 10.4.2.2. CHECK
          3. 10.4.2.3. UNIQUE
          4. 10.4.2.4. PRIMARY KEY
          5. 10.4.2.5. FOREIGN KEY
          6. 10.4.2.6. Deferred Constraint Checking
        3. 10.4.3. Working with Indexes
          1. 10.4.3.1. Specifying Storage
          2. 10.4.3.2. Using Other Create Clauses
          3. 10.4.3.3. Reverse Key Indexes
          4. 10.4.3.4. Function-Based Indexes
          5. 10.4.3.5. Index-Organized Tables
      5. 10.5. Summary
      6. 10.6. Exam Essentials
      7. 10.7. Review Questions
      8. 10.8. Answers to Review Questions
    4. 11. Understanding Network Architecture
      1. 11.1. Introducing Network Configurations
        1. 11.1.1. Single-Tier Architecture
        2. 11.1.2. Two-Tier Architecture
        3. 11.1.3. n-Tier Architecture
      2. 11.2. An Overview of Oracle Net Features
        1. 11.2.1. Connectivity
        2. 11.2.2. Manageability
          1. 11.2.2.1. Web Applications
          2. 11.2.2.2. Location Transparency
          3. 11.2.2.3. Directory Naming
        3. 11.2.3. Scalability
          1. 11.2.3.1. Oracle Shared Server
          2. 11.2.3.2. Connection Manager
        4. 11.2.4. Security
          1. 11.2.4.1. Advanced Security
          2. 11.2.4.2. Firewall Support
        5. 11.2.5. Accessibility
          1. 11.2.5.1. Heterogeneous Services
          2. 11.2.5.2. External Procedures
      3. 11.3. Configuring Oracle Net on the Server
        1. 11.3.1. Understanding the Oracle Listener
          1. 11.3.1.1. How Do Listeners Respond to Connection Requests?
            1. 11.3.1.1.1. Dedicated Connections: Direct Handoff Method
            2. 11.3.1.1.2. Dedicated Connections: Redirect Method
            3. 11.3.1.1.3. Oracle Shared Server: Direct Handoff Method
            4. 11.3.1.1.4. Oracle Shared Server: Redirect Method
        2. 11.3.2. Managing Oracle Listeners
          1. 11.3.2.1. Managing Listeners with Oracle Net Manager
            1. 11.3.2.1.1. Configuring Listener Services Using Oracle Net Manager
            2. 11.3.2.1.2. Creating the Listener
            3. 11.3.2.1.3. Adding Service-Name Information to the Listener
          2. 11.3.2.2. Optional listener.ora Parameters
          3. 11.3.2.3. Managing Listeners with Oracle Enterprise Manager
            1. 11.3.2.3.1. Adding a Listener Using Enterprise Manager Database Control
            2. 11.3.2.3.2. Editing Existing Listeners Using EM Database Control
          4. 11.3.2.4. Managing Listeners with lsnrctl
            1. 11.3.2.4.1. Starting the Listener
            2. 11.3.2.4.2. Reloading the Listener
            3. 11.3.2.4.3. Showing the Status of the Listener
            4. 11.3.2.4.4. Listing the Services for the Listener
            5. 11.3.2.4.5. Other Commands in lsnrctl
            6. 11.3.2.4.6. Using the set Commands in lsnrctl
            7. 11.3.2.4.7. Stopping the Listener
        3. 11.3.3. Dynamically Registering Services
        4. 11.3.4. Oracle Net Logging and Tracing on the Server
          1. 11.3.4.1. Server Logging
          2. 11.3.4.2. Server Tracing
          3. 11.3.4.3. Enabling Server Tracing
      4. 11.4. Configuring Oracle Net for the Client
        1. 11.4.1. Client-Side Names Resolution Options
        2. 11.4.2. The Host Naming Method
          1. 11.4.2.1. Configuring the Host Naming Method
        3. 11.4.3. The Oracle Easy Connect Method
        4. 11.4.4. The Local Naming Method
          1. 11.4.4.1. Configuring the Local Naming Method Using Oracle Net Manager
          2. 11.4.4.2. Contents and Structure of the tnsnames.ora File
          3. 11.4.4.3. Configuring Local Naming Using Enterprise Manager
        5. 11.4.5. Troubleshooting Client-Side Connection Problems
          1. 11.4.5.1. Checking Network File Locations
          2. 11.4.5.2. Checking NAMES.DIRECTORY_PATH
          3. 11.4.5.3. Checking NAMES.DEFAULT_DOMAIN
          4. 11.4.5.4. Checking for Client-Side Error Codes
      5. 11.5. An Overview of Oracle Shared Server
        1. 11.5.1. Dedicated Server vs. Shared Server
        2. 11.5.2. Advantages and Disadvantages of Shared Server
      6. 11.6. Oracle Shared Server Infrastructure
        1. 11.6.1. PGA and SGA Changes When Using Oracle Shared Server
        2. 11.6.2. The Role of the Listener in an Oracle Shared Server Environment
        3. 11.6.3. Configuring the Oracle Shared Server
          1. 11.6.3.1. Defining the Shared Server Parameters
            1. 11.6.3.1.1. Using the DISPATCHERS Parameter
            2. 11.6.3.1.2. Using the MAX_DISPATCHERS Parameter
            3. 11.6.3.1.3. Using the SHARED_SERVERS Parameter
            4. 11.6.3.1.4. Using the SHARED_SERVER_SESSIONS Parameter
            5. 11.6.3.1.5. Using the MAX_SHARED_SERVERS Parameter
            6. 11.6.3.1.6. Using the CIRCUITS Parameter
        4. 11.6.4. Managing a Shared Server
          1. 11.6.4.1. Displaying Information about Shared Server Connections Using the Listener Utility
          2. 11.6.4.2. Requesting a Dedicated Connection in a Shared Server Environment
            1. 11.6.4.2.1. Configuring Dedicated Connections Manually
            2. 11.6.4.2.2. Configuring Dedicated Connections Using Oracle Net Manager
      7. 11.7. Summary
      8. 11.8. Exam Essentials
      9. 11.9. Review Questions
      10. 11.10. Answers to Review Questions
    5. 12. Implementing Security and Auditing
      1. 12.1. Creating and Managing User Accounts
        1. 12.1.1. Configuring Authentication
          1. 12.1.1.1. Password-Authenticated Users
          2. 12.1.1.2. Externally Authenticated Users
          3. 12.1.1.3. Globally Authenticated Users
        2. 12.1.2. Assigning Tablespaces and Quotas
          1. 12.1.2.1. Assigning a Temporary Tablespace
          2. 12.1.2.2. Assigning Space Quotas
        3. 12.1.3. Assigning a Profile and Account Settings
        4. 12.1.4. Removing a User from the Database
        5. 12.1.5. Managing Default User Accounts
      2. 12.2. Granting and Revoking Privileges
        1. 12.2.1. Granting Object Privileges
          1. 12.2.1.1. Table Object Privileges
            1. 12.2.1.1.1. Commonly Granted Privileges
            2. 12.2.1.1.2. Powerful Administrative Privileges on Tables
          2. 12.2.1.2. View Object Privileges
          3. 12.2.1.3. Sequence Object Privileges
          4. 12.2.1.4. Stored Functions, Procedures, Packages, and Java Object Privileges
          5. 12.2.1.5. How to Grant Privileges
        2. 12.2.2. Granting System Privileges
          1. 12.2.2.1. Database
          2. 12.2.2.2. Debugging
          3. 12.2.2.3. Indexes
          4. 12.2.2.4. Job Scheduler
          5. 12.2.2.5. Procedures
          6. 12.2.2.6. Profiles
          7. 12.2.2.7. Roles
          8. 12.2.2.8. Sequences
          9. 12.2.2.9. Sessions
          10. 12.2.2.10. Synonyms
          11. 12.2.2.11. Tables
          12. 12.2.2.12. Tablespaces
          13. 12.2.2.13. Triggers
          14. 12.2.2.14. Users
          15. 12.2.2.15. Views
          16. 12.2.2.16. Others
          17. 12.2.2.17. How to Grant System Privileges
        3. 12.2.3. Role Privileges
          1. 12.2.3.1. Creating and Managing Roles
          2. 12.2.3.2. Granting Role Privileges
            1. 12.2.3.2.1. Enabling Roles
            2. 12.2.3.2.2. Identifying Enabled Roles
            3. 12.2.3.2.3. Disabling Roles
            4. 12.2.3.2.4. Setting Default Roles
          3. 12.2.3.3. Default Database Roles
        4. 12.2.4. Applying the Principle of Least Privilege
      3. 12.3. Controlling Resource Usage by Users
        1. 12.3.1. Implementing Password Security Features
      4. 12.4. Auditing Database Activity
        1. 12.4.1. Managing Statement Auditing
          1. 12.4.1.1. Enabling Statement Auditing
          2. 12.4.1.2. Identifying Enabled Statement-Auditing Options
          3. 12.4.1.3. Disabling Statement Auditing
          4. 12.4.1.4. Examining the Audit Trail
        2. 12.4.2. Managing Privilege Auditing
          1. 12.4.2.1. Enabling Privilege Auditing
          2. 12.4.2.2. Identifying Enabled Privilege-Auditing Options
          3. 12.4.2.3. Disabling Privilege Auditing
        3. 12.4.3. Managing Object Auditing
          1. 12.4.3.1. Enabling Object Auditing
          2. 12.4.3.2. Identifying Enabled Object-Auditing Options
          3. 12.4.3.3. Disabling Object Auditing
        4. 12.4.4. Purging the Audit Trail
        5. 12.4.5. Managing Fine-Grained Auditing
          1. 12.4.5.1. Creating an FGA Policy
          2. 12.4.5.2. Enabling an FGA Policy
          3. 12.4.5.3. Disabling an FGA Policy
          4. 12.4.5.4. Dropping an FGA Policy
          5. 12.4.5.5. Identifying FGA Policies in the Database
          6. 12.4.5.6. Reporting on the FGA Audit Trail Entries
      5. 12.5. Summary
      6. 12.6. Exam Essentials
      7. 12.7. Review Questions
      8. 12.8. Answers to Review Questions
    6. 13. Managing Data and Undo
      1. 13.1. Manipulating Data through SQL
        1. 13.1.1. Using the INSERT Statement
          1. 13.1.1.1. Inserting into a Single Table
          2. 13.1.1.2. Inserting into Multiple Tables
        2. 13.1.2. Using the UPDATE Statement
        3. 13.1.3. Using the MERGE Statement
        4. 13.1.4. Using the DELETE Statement
      2. 13.2. Identifying PL/SQL Objects
        1. 13.2.1. Working with Functions
        2. 13.2.2. Working with Procedures
        3. 13.2.3. Working with Packages
          1. 13.2.3.1. Creating a Package Body
        4. 13.2.4. Working with Triggering Events and Managing Triggers
          1. 13.2.4.1. DML Trigger Events
          2. 13.2.4.2. DDL Trigger Events
          3. 13.2.4.3. Database Trigger Events
          4. 13.2.4.4. Enabling and Disabling Triggers
        5. 13.2.5. Using and Administering PL/SQL Programs
      3. 13.3. Monitoring Locks and Resolving Lock Conflicts
        1. 13.3.1. Understanding Locks and Transactions
        2. 13.3.2. Maximizing Data Concurrency
          1. 13.3.2.1. Lock Modes
          2. 13.3.2.2. NOWAIT Mode
          3. 13.3.2.3. WAIT Mode
          4. 13.3.2.4. DDL Lock Waits
        3. 13.3.3. Detecting and Resolving Lock Conflicts
          1. 13.3.3.1. Understanding Lock Conflicts
          2. 13.3.3.2. Detecting Lock Conflicts
          3. 13.3.3.3. Understanding and Resolving Deadlocks
      4. 13.4. Leveraging Undo Management
        1. 13.4.1. Understanding Undo Segments
        2. 13.4.2. Using Undo Data
          1. 13.4.2.1. User Transaction Rollback
          2. 13.4.2.2. Read Consistency
        3. 13.4.3. Monitoring, Configuring, and Administering Undo
          1. 13.4.3.1. Configuring the Undo Tablespace
            1. 13.4.3.1.1. UNDO_MANAGEMENT
            2. 13.4.3.1.2. UNDO_TABLESPACE
            3. 13.4.3.1.3. UNDO_RETENTION
          2. 13.4.3.2. Monitoring the Undo Tablespace
          3. 13.4.3.3. Sizing the Undo Tablespace Using the Undo Advisor
          4. 13.4.3.4. Guaranteeing Undo Retention
      5. 13.5. Summary
      6. 13.6. Exam Essentials
      7. 13.7. Review Questions
      8. 13.8. Answers to Review Questions
    7. 14. Maintaining the Database and Managing Performance
      1. 14.1. Proactive Database Maintenance
        1. 14.1.1. Managing Optimizer Statistics
          1. 14.1.1.1. Collecting Statistics
            1. 14.1.1.1.1. Manually Collecting Stats Using SQL*Plus
            2. 14.1.1.1.2. Manually Collecting Stats Using EM Grid Control
          2. 14.1.1.2. Defining Statistics Preferences
            1. 14.1.1.2.1. Pending Statistics
            2. 14.1.1.2.2. Extended Statistics
          3. 14.1.1.3. Configuring Automated Maintenance Tasks Using EM
        2. 14.1.2. Gathering Performance Statistics
          1. 14.1.2.1. Using Automatic Workload Repository
            1. 14.1.2.1.1. Managing AWR Snapshots Manually
          2. 14.1.2.2. Active Session History
          3. 14.1.2.3. AWR Baselines
            1. 14.1.2.3.1. Managing AWR Baselines Using SQL*Plus
            2. 14.1.2.3.2. Managing AWR Baselines Using EM Database Control
        3. 14.1.3. Automatic Database Diagnostic Monitoring
          1. 14.1.3.1. Using EM Database Control to View ADDM Analysis
            1. 14.1.3.1.1. The EM Database Control Performance Findings Link
            2. 14.1.3.1.2. The EM Database Control Performance Tab
            3. 14.1.3.1.3. The Advisor Central Screen
          2. 14.1.3.2. Using Data Dictionary Views to View ADDM Analysis
        4. 14.1.4. The Advisory Framework
        5. 14.1.5. Monitoring Server-Generated Alerts
          1. 14.1.5.1. Viewing and Configuring Alerts Using EM Database Control
          2. 14.1.5.2. Viewing and Configuring Alerts Using SQL
        6. 14.1.6. Understanding Automatic Diagnostic Repository
          1. 14.1.6.1. Using ADRCI to View the Alert Log File
          2. 14.1.6.2. Using EM to View the Alert Log File
      2. 14.2. Managing Performance
        1. 14.2.1. Sources of Tuning Information
          1. 14.2.1.1. The Alert Log
          2. 14.2.1.2. Background and User Trace Files
          3. 14.2.1.3. Dynamic Performance Views
          4. 14.2.1.4. Data Dictionary Views
        2. 14.2.2. Compiling Invalid and Unusable Objects
          1. 14.2.2.1. Identifying Unusable Objects Using the Data Dictionary
          2. 14.2.2.2. Identifying Unusable Objects Using EM
        3. 14.2.3. Tuning Memory
          1. 14.2.3.1. Memory Components
          2. 14.2.3.2. Automatic Shared Memory Management
          3. 14.2.3.3. Automatic SQL Execution Memory Management
          4. 14.2.3.4. Automatic Memory Management
          5. 14.2.3.5. Managing Memory Using EM Database Control
        4. 14.2.4. Important Performance Metrics
          1. 14.2.4.1. Using EM Database Control to View Performance Metrics
      3. 14.3. Summary
      4. 14.4. Exam Essentials
      5. 14.5. Review Questions
      6. 14.6. Answers to Review Questions
    8. 15. Implementing Database Backups
      1. 15.1. Understanding and Configuring Recovery Components
        1. 15.1.1. Understanding Control Files
          1. 15.1.1.1. Control File Architecture
          2. 15.1.1.2. Multiplexing Control Files
            1. 15.1.1.2.1. Multiplexing Control Files Using init.ora
            2. 15.1.1.2.2. Multiplexing Control Files Using an Spfile
        2. 15.1.2. Understanding Checkpoints
        3. 15.1.3. Understanding Redo Log Files
          1. 15.1.3.1. Redo Log File Architecture
          2. 15.1.3.2. Log Switch Operations
          3. 15.1.3.3. Multiplexing Redo Log Files
            1. 15.1.3.3.1. Creating New Groups
            2. 15.1.3.3.2. Adding New Members
            3. 15.1.3.3.3. Renaming Log Members
            4. 15.1.3.3.4. Dropping Redo Log Groups
            5. 15.1.3.3.5. Dropping Redo Log Members
            6. 15.1.3.3.6. Clearing Online Redo Log Files
        4. 15.1.4. Understanding Archived Redo Log (ARCHIVELOG) Files
          1. 15.1.4.1. Archived Redo Log File Architecture
          2. 15.1.4.2. Setting the Archive Destination
            1. 15.1.4.2.1. LOG_ARCHIVE_DEST_n
            2. 15.1.4.2.2. LOG_ARCHIVE_MIN_SUCCEED_DEST
            3. 15.1.4.2.3. LOG_ARCHIVE_FORMAT
          3. 15.1.4.3. Setting ARCHIVELOG
        5. 15.1.5. Understanding the Flash Recovery Area
          1. 15.1.5.1. Flash Recovery Area Occupants
          2. 15.1.5.2. The Flash Recovery Area and SQL Commands
          3. 15.1.5.3. The Flash Recovery Area and EM Database Control
          4. 15.1.5.4. Flash Recovery Area Management
      2. 15.2. Performing Backups
        1. 15.2.1. Understanding Backup Terminology
        2. 15.2.2. Backing Up the Control File
          1. 15.2.2.1. Text Backup of Control File
          2. 15.2.2.2. Binary Backup of Control File
          3. 15.2.2.3. RMAN Backup of Control File
        3. 15.2.3. Backing Up the Database
          1. 15.2.3.1. User-Managed Cold Backups
          2. 15.2.3.2. User-Managed Hot Backups
        4. 15.2.4. Using RMAN to Create Backups
          1. 15.2.4.1. Configuring RMAN Backup Settings
          2. 15.2.4.2. Understanding Image Copies and Backup Sets
          3. 15.2.4.3. Creating Full and Incremental Backups
        5. 15.2.5. Managing Backups
          1. 15.2.5.1. Catalog Maintenance
          2. 15.2.5.2. Viewing Backup Reports
      3. 15.3. Summary
      4. 15.4. Exam Essentials
      5. 15.5. Review Questions
      6. 15.6. Answers to Review Questions
    9. 16. Recovering the Database
      1. 16.1. Understanding Types of Database Failure
        1. 16.1.1. Statement Failures
        2. 16.1.2. User-Process Failures
        3. 16.1.3. Network Failures
        4. 16.1.4. User-Error Failures
        5. 16.1.5. Instance Failures
        6. 16.1.6. Media Failures
      2. 16.2. Performing Recovery Operations
        1. 16.2.1. Understanding Instance Startup
        2. 16.2.2. Keeping an Instance from Failing
        3. 16.2.3. Recovering from Instance Failure
        4. 16.2.4. Tuning Instance Recovery
        5. 16.2.5. Recovering from User Errors
          1. 16.2.5.1. Using Flashback Query
          2. 16.2.5.2. Using Flashback Drop and the Recycle Bin
            1. 16.2.5.2.1. Recycle-Bin Concepts
            2. 16.2.5.2.2. Retrieving Dropped Tables from the Recycle Bin
            3. 16.2.5.2.3. Recycle-Bin Considerations and Limitations
          3. 16.2.5.3. Using Flashback Table
          4. 16.2.5.4. Using EM Database Control to Perform Table Recovery
          5. 16.2.5.5. Using Flashback Transaction
          6. 16.2.5.6. Using LogMiner
        6. 16.2.6. Recovering from Loss of a Control File
        7. 16.2.7. Using the Data Recovery Advisor
        8. 16.2.8. Recovering from the Loss of a Redo Log File
        9. 16.2.9. Recovering from the Loss of a Non–System-Critical Data File
          1. 16.2.9.1. Loss of a Non-System-Critical Data File in NOARCHIVELOG Mode
          2. 16.2.9.2. Loss of a Non-System-Critical Data File in ARCHIVELOG Mode
        10. 16.2.10. Recovering from the Loss of a System-Critical Data File
          1. 16.2.10.1. Loss of a System-Critical Data File in NOARCHIVELOG Mode
          2. 16.2.10.2. Loss of a System-Critical Data File in ARCHIVELOG Mode
      3. 16.3. Summary
      4. 16.4. Exam Essentials
      5. 16.5. Review Questions
      6. 16.6. Answers to Review Questions
    10. 17. Moving Data and Using EM Tools
      1. 17.1. Understanding Data Pump
        1. 17.1.1. Architecture of Data Pump
          1. 17.1.1.1. Data Pump Components
          2. 17.1.1.2. Data Pump Processes
          3. 17.1.1.3. Data Access Methods
        2. 17.1.2. Using Data Pump Clients
          1. 17.1.2.1. Setting Up the Dump Location
          2. 17.1.2.2. Specifying Export and Import Modes
          3. 17.1.2.3. Using expdp
            1. 17.1.2.3.1. Data Pump Export Parameters
          4. 17.1.2.4. Using impdp
            1. 17.1.2.4.1. Data Pump Import Parameters
            2. 17.1.2.4.2. Import Transformations
          5. 17.1.2.5. Network-Mode Import
          6. 17.1.2.6. Data and Metadata Filters
          7. 17.1.2.7. Managing Data Pump Jobs
        3. 17.1.3. Using the Data Pump Wizard
          1. 17.1.3.1. Import Using EM Database Control
      2. 17.2. Loading Data with SQL*Loader
        1. 17.2.1. Specifying SQL*Loader Command-Line Parameters
        2. 17.2.2. Specifying Control File Options
          1. 17.2.2.1. Using Direct Path Loading
        3. 17.2.3. Using EM to Load Data
      3. 17.3. Populating External Tables
        1. 17.3.1. Loading External Tables Using Data Pump
        2. 17.3.2. Loading External Tables Using Loader
      4. 17.4. Using EM Support Workbench
        1. 17.4.1. Identifying a Problem
        2. 17.4.2. Gathering Additional Diagnostic Information
        3. 17.4.3. Creating a Service Request
        4. 17.4.4. Packaging Diagnostic Data
          1. 17.4.4.1. Configuring Incident Packaging
        5. 17.4.5. Tracking and Closing the Incident
      5. 17.5. Using EM to Manage Patches
        1. 17.5.1. Using the Patch Advisor
        2. 17.5.2. Viewing the Patch Cache
        3. 17.5.3. Finding the Patch Prerequisites
        4. 17.5.4. Staging a Patch
        5. 17.5.5. Applying a Patch
      6. 17.6. Summary
      7. 17.7. Exam Essentials
      8. 17.8. Review Questions
      9. 17.9. Answers to Review Questions
    11. A. About the Companion CD
      1. A.1. What You'll Find on the CD
        1. A.1.1. Sybex Test Engine
        2. A.1.2. PDF of the Book
        3. A.1.3. Adobe Reader
        4. A.1.4. Electronic Flashcards
      2. A.2. System Requirements
        1. A.2.1. Using the CD
      3. A.3. Troubleshooting
        1. A.3.1. Customer Care
  7. Glossary

Product information

  • Title: OCA Oracle® Database 11g Administrator Certified Associate: Study Guide
  • Author(s):
  • Release date: April 2009
  • Publisher(s): Sybex
  • ISBN: 9780470395127