Apps DBA Certification

Oracle 11i Applications Database Administrator Certified Professional
[Applications DBA Fundamentals I 1Z0_235 +
Applications DBA Fundamentals II 1Z0_236 +
Oracle 11I Install, Patch and Maintain Applications 1Z0_233 ] = Oracle 11i Applications Database Administrator Certified Professional


Exam:1Z0-235
Exam Price: $195 USD
Duration: 120 minutes
Number of Questions: 68
Passing Score: 70%


Exam Topics
Oracle Architectural Components
Describe the Oracle architecture and its main components
List (describe) the structures involved in connecting a user to an Oracle instance

Getting Started With the Oracle Server
Identify common database administrative tools available to a DBA

Managing an Oracle Instance
Create and manage initialization parameter files
Start up and shut down an instance
Monitor the use of diagnostic files

Creating a Database
Describe the prerequisites necessary for database creation
Create a database manually

Data Dictionary Content and Usage
Identify key data dictionary components
Identify the contents and uses of the data dictionary
Query the data dictionary

Maintaining the Control File
Explain the uses of the control file
Mulitplex and manage the control file
Obtain control file information

Maintaining Redo Log Files
Explain the purpose of online redo log files
Describe the structure of online redo log files
Control log switches and checkpoints
Mulitplex and maintain online redo log files

Managing Tablespaces and Data files
Describe the logical structure of tablespaces within the database
Create tablespaces
Allocate space for temporary segments
Change the status of tablespaces
Change the storage settings of tablespaces

Storage Structure and Relationships
List the segment types and their uses
List the keywords that control block space usage
Obtain information about storage structures from the data dictionary

Managing Undo Data
Describe the purpose of undo data
Implement Automatic Undo Management

Managing Tables
Identify the various methods of storing data
Create regular and temporary tables
Reorganize, truncate, drop a table
Drop a column within a table

Managing Indexes
List the different types of indexes and their uses
Reorganize indexes
Monitor the usage of an index

Maintaining Data Integrity
Describe the Types of Data Integrity Constraints

Managing Users
Create new database users
Alter and drop existing database users
Monitor information about existing users

Managing Privileges
Identify system and object privileges
Grant and revoke privileges

Using Globalization Support
Choose database character set and national character set for a database
Specify the language-dependent behavior using initialization parameters, environment variables and the ALTER SESSION command

Basic Oracle Net Architecture
Explain the key components of the Oracle Net layered architecture
Explain Oracle Net Services role in client server connections
Describe how web client connections are established through Oracle networking products

Basic Net Server-Side Configuration
Identify how the listener responds to incoming connections
Configure the listener using Oracle Net Manager
Control the listener using the Listener Control Utility (lsnrctl)
Describe Dynamic Service Registration

Basic Oracle Net Services Client-Side Configuration
Describe the difference between host naming and local service name resolution
Use Oracle Net Configuration Assistant to configure: Host Naming, Local naming method, Net service names
Perform simple connection troubleshooting



Exam: 1Z0-236
Exam Price: $195 USD
Duration: 120 minutes
Number of Questions: 66
Passing Score: 72%


Exam Topics
Overview of Tuning
Describe the dependency between tuning in different development phases
Describe appropriate tuning goals
Describe the most common tuning problems

Diagnostic and Tuning Tools
Describe how the alert.log file is used
Describe the statistics kept in the dynamic performance views
Collect statistics using StatsPack
Use other tuning tools

Database Configuration and I/O Issues
Diagnose tablespace usage problems
Describe how checkpoints work
Monitor and tune checkpoints
Monitor and tune redo logs

Tuning the Shared Pool
Measure and tune the library cache hit ratio
Measure and tune the dictionary cache hit ratio
Size and pin objects in the shared pool
Tune the shared pool reserved space
Describe the user global area (UGA) and session memory considerations
Explain other tuning issues related to the shared pool

Tuning the Buffer Cache
Describe how the buffer cache is used by different Oracle processes
Describe the tuning issues related to the buffer cache
Monitor the use of buffer cache, and the different pools within buffer cache
Implement dynamic SGA allocation
Set the DB_CACHE_ADVICE parameter
Create and size multiple buffer pools
Detect and resolve free list contention

Sizing Other SGA Structures
Monitor and size the redo log buffer
Monitor and size the java pool

Optimizing Sort Operations
Identify the SQL operations which require sorts
Create and monitor temporary tablespaces
Reduce total sorts and disk sorts

SQL Statement Tuning
Describe how the Optimizer is used
Use stored outlines
Use SQL Trace and TKPROF
Collect statistics on indexes and tables
Copy statistics between databases

Using Oracle Blocks Efficiently
Describe the correct usage of extents and Oracle blocks
Explain space usage and the high-water mark
Recover space from sparsely populated segments
Describe and detect chaining and migration of Oracle blocks
Perform index reorganization
Monitor indexes to determine usage

Application Tuning
Explain the different types of indexes
Describe materialized views and the use of query rewrites

Resolving Locking Issues
Define levels of locking
List possible causes of contention
Use Oracle utilities to detect lock contention
Resolve contention in an emergency
Prevent locking problems

Backup and Recovery Overview
Describe the basics of database backup, restore and recovery
List the types of failure that may occur in an Oracle environment
Define a backup and recovery strategy

Instance and Media Recovery Structures
Identify the importance of checkpoints, redo log files, and archived log files

Configuring the Database Archiving Mode
Describe the differences between Archivelog and Noarchivelog modes
Configure a database for Archivelog mode
Enable automatic archiving

User-Managed Backups
Describe user-managed backup and recovery operations
Perform closed database backups
Perform open database backups
Back up the control file

User-Managed Complete Recovery
Perform recovery in Noarchivelog mode
Perform complete recovery in Archivelog mode
Restore datafiles to different locations
Relocate and recover a tablespace by using archived redo logfiles
Describe read-only tablespace recovery

User-Managed Incomplete Recovery
Describe the steps of incomplete recovery
Perform an incomplete database recovery
Identify the loss of current online redo log files

Transporting Data Between Databases
Describe the uses of the Export and Import utilities
Describe Export and Import concepts and structures
Perform simple Export and Import operations

Loading Data into a Database
Demonstrate usage of direct-load insert operations
Describe the usage of SQL*Loader
Perform basic SQL*Loader operations



Exam:1Z0-233

Exam Price: $195 USD
Duration: 90 minutes
Number of Questions: 65
Pssing Score: 67%


Exam Topics
Oracle Applications Overview
Describe components of file system in Oracle Applications

Preparing for Installation
Describe the benefits of Rapid Install Utility
Describe release platforms for 11i Applications
Describe the software requirements to complete installation of 11i Applications
Describe CPU, Memory and Disk Space Requirements for 11i Applications
Explain the pre-requisites for starting rapid install
Run rapid install wizard
Restart installation

Single Node Installation
Explain the steps involved in performing a single-node installation
Use Rapid Install for a single-node installation
Perform an Express installation

Multi Node Installation
Explain the differences between the single-node and multi-node installation processes
Analyze situations in which a multi-node installation is appropriate
Use Rapid Install to perform a multi-node installation

Finishing the Installation
Describe required post-installation tasks
Describe the client software configuration process
Set up printers
Apply Oracle E-Business Suite Consolidated Update
Configure Multiple Servers to Use JInitiator
Resize the database
Set Up National Language Support (NLS)
Set Up UTF8 Character Set
Configure Oracle Workflow Java-based Notification Mailer
Set Up and Implement Oracle Embedded Data Warehouse (EDW)

Oracle Applications Components
Explain How Oracle Applications uses the Applications technology stack components
Describe Components of the desktop tier
Describe Components of the application tier
Describe Components of the database tier
Describe products of the Application Technology layers
Describe Oracle Application Manager

Oracle Applications Environment Files, Control Scripts, and Languages
Explain environment files created by Rapid Install
Describe Application Tier Server Control Scripts
Start and stop server processes
Explain Character Sets
Explain National Language Support (NLS)
Install multiple Languages

Oracle Applications File System
Describe Oracle Applications File System
Describe APPL_TOP directory structure
Describe Globalization as components of Oracle Applications
Distribute files across disks
Describe Structure and Contents of product directories
Describe Key APPL_TOP subdirectories

Oracle Applications Database
Describe the objects and schemas that exist in the Oracle Applications database
Describe the purpose of the APPS schema
Describe Multiple Organization Architecture
Describe Multiple Reporting Currencies
Identify the Oracle database features utilized by Oracle Applications
Start and stop the database server and listener

Advanced Configuration Options
Describe the Shared APPL_TOP feature available for Oracle Applications
Identify the main load balancing options and their key features
Describe the major factors in efficient network design for Oracle Applications

AD Utilities
Describe AD utilities
Explain AD Administration: Generate Applications Files Tasks
Explain AD Administration: Maintain Applications Files Tasks
Explain AD Administration: Maintain Database Entities Tasks
Explain AD Administration: Compile/Reload Database Entities Tasks
Explain AD Administration: Non-interactive Operation and Describe Maintenance Mode
Describe AutoConfig
Describe License Manager
Describe Reporting Utilities
Set the Application environment and locate the AD Utilities

AD Administration: Generate Applications Files
Describe AD Administration
Perform preliminary steps before using AD Administration
Respond to prompts
Describe the Generate Applications Files menu tasks
View log files
Perform file generation tasks with AD Administration
Generate message, form, report, graphics, and product jar files

AD Administration: Maintain Applications Files
Create the Applications environment file
Copy files to destinations
Convert the character set
Maintain snapshot information
Check for missing files
Perform file system tasks on multi-node systems
Create the main Applications environment file

AD Administration: Maintain Database Entities
Maintain Database Entities menu tasks
Validate APPS schema
Recreate grants and synonyms for APPS schemas
Maintain multilingual tables
Convert to / Maintain Multiple Reporting Currencies
Maintain Multiple Reporting Currencies
Convert to Multiple Organizations

AD Administration: Compile/Reload Database Entities
Compile/Reload Database Entities menu tasks
Compile APPS schemas
Compile menu information
Compile flexfield data in AOL tables
Reload JAR files to the database

AD Administration: Non-interactive Operation and Maintenance Mode
Create a defaults file
Run AD Administration in non-interactive mode
Enable and Disable maintenance mode

Special Utilities
Monitor worker processes
Restart and shutdown a worker
Troubleshoot worker processes
Relink AD programs
Describe the AutoUpgrade utility

AutoConfig
Describe the Applications Context
Update Applications Contact parameters
Restore Applications Context parameter
Describe AutoConfig
Run AutoConfig to configure your Oracle Applications system
Roll back an AutoConfig session
Identify the control scripts created by AutoConfig
Run AutoConfig in test mode

License Manager
Register products
Register country-specific functionalities
Register languages
Identify licensed products and languages

Reporting Utilities
Run AD Configuration
Use AD File Identification
Run the AD Job Timing report
Reduce system downtime

Configuration Utilities
Install a new off-cycle product
Convert the character set of Applications files

Patching and the AutoPatch Process
Describe Patches, minipacks, and maintenance packs
Describe Family packs and family consolidated upgrade patches
Describe Patch naming convention
Describe patch components
Explain Patch creation
Download a patch
Describe AutoPatch
Explain AutoPatch operations
Apply a patch
Explain Patch application in a multi-node system
Describe Patch documentation files

Patch Wizard
Access Patch Wizard
Describe Patch Wizard main page
Set up Patch Wizard
Define the stage directory
Define patch filters
Submit Patch Wizard requests
View Patch Wizard requests
Describe Patch Wizard results

Running AutoPatch
Explain AutoPatch Setup Tasks
Run AutoPatch
Describe AutoPatch Prompts
Describe AutoPatch Messages
Perform Post AutoPatch Tasks
Restart AutoPatch

OAM Timing Reports
Access OAM Timing Reports
Describe Timing Reports main page
Use the AutoPatch Timing Details report
Use the AD Administration Timing Details report
Use the Job Timing report
Use the Phase Information report
Use the Exceptions report
Track an In-Progress AutoPatch Session

AutoPatch Modes & Testing
Run AutoPatch in test mode
Run AutoPatch in pre-install mode
Run AutoPatch in non-interactive mode
Use AutoPatch command line options
Use test systems to test patches
Merge patch drivers from multiple patches

Applied Patches
Use the Applied Patches search pages
Use Applied Patches reports
Explain Applied Patches and AutoPatch modes
Access Applied Patches
Perform Simple Search for applied patch information
Perform Advanced Search for applied patch information

Cloning Oracle Applications
Describe situation that may require cloning
Describe the Rapid Clone utility
Explain the phases of the cloning process
Perform the steps within each phase of cloning

Advanced Cloning Options
Refresh a cloned target system
Clone a single-node system to a multi-node system
Clone a multi-node system to a multi-node system
Add a node to an existing system
Reduce the number of nodes on a multi-node system

OAM Rapid Clone
Differentiate between a Simple Clone and an Advanced Clone
Establish cloning parameters
Prepare the Source System
Copy Files from Source to Target
Configure the Target System
Initiate Data Purge
Review Checklist