About Exam

• Architecture
• Installing the Oracle Database Software
• Creating an Oracle Database
• Managing the Oracle Instance
• Managing Database Storage Structures
• Administering User Security
• Managing Schema Objects  
• Managing Data and Concurrency
• Managing Undo Data
• Implementing Oracle Database Security
• Configuring the Oracle Network Environment
• Proactive Maintenance
• Backup and Recovery Concepts
• Performance Management
• Performing Database Backup
• Performing Database Recovery
• Performing Flashback
• Moving Data

Exam Objectives

• Outline the Oracle Architecture and its main Components
• Explain the Oracle instance architecture

• Identify common database administrative tools available to a DBA (1)
• Use optimal flexible architecture
• Install software with Oracle Universal Installer
• Identify and configure commonly used environment variables
• Use Installer Log (2)

• Use DBCA to Create a database
• Use DBCA to Delete a database
• Use DBCA to manage templates

• Use Enterprise Manager
• Use SQL*Plus and iSQL*Plus to access the Oracle Database
• Modify database initialization parameters
• Describe the stages of database startup
• Describe the database shutdown options
• View the database alert log
• Use dynamic performance views (3)

• Describe how table row data is stored in blocks (4)
• Define the purpose of tablespaces and data files
• Explain space management in tablespaces
• Create tablespaces
• Manage tablespaces: alter, drop, take offline, put online, add data files, make read-only or read-write, generate DDL
• Obtain tablespace information
• Explain key features and benefits of ASM (5)

• Create and manage database user accounts
• Create and manage roles
• Grant and revoke privileges
• Create and manage profiles (6)

• Create and modify tables
• Define constraints and states of constraints (7)
• Dropping and truncating tables (7)
• Create and use B-Tree and Bitmap indexes (8)
• Create Views
• Create sequences
• Use data dictionary

• Manipulate data through the use of SQL
• Identify and administer PL/SQL objects
• Describe triggers and triggering events
• Define levels of locking
• List possible causes of lock conflict
• Monitor and resolve lock conflicts

• Monitor and administer undo
• Configure undo retention
• Describe the relationship between undo and transactions
• Size the undo tablespace

• Apply the principle of least privilege
• Audit database activity
• Implement Fine-Grained Auditing

• Use Database Control to Create additional listeners
• Use Database Control to Create Oracle Net service aliases
• Control Oracle Net Listeners
• Identify when to use shared servers versus dedicated servers

• Gather optimizer statistics
• Manage the Automatic Workload Repository
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Set warning and critical alert thresholds
• React to performance issues

• Use enterprise manager to view performance (9)
• Tune SQL by using SQL tuning advisor (10)
• Tune SQL by using SQL access advisor
• Use automatic shared memory management (11)
• Use the memory advisor to size memory buffer (11)

• Descri