Exam Number: 1Z0-238
Exam Title: Oracle EBS R12: Install, Patch and Maintain Applications
Associated Certification Paths Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.
Oracle E-Business Suite R12 Applications Database Administrator Certified Professional
Duration: 90 minutes
Number of Questions: 75
Passing Score: 63%
View passing score policy
Validated Against: This exam has been validated against Release 12
Format: Multiple Choice
Complete Recommended Training
R12.x Install/Patch/Maintain Oracle E-Business Suite
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Preparing for your Installation
Advantages of Rapid Install
Technology Stack Components
Pre-requisites required (Platform Hardware and Softwares)
Staging Software
How Installation works
Performing an Installation
Types of Installation (Standard/Typical/Express)
Validation of Parameters passed
Restart / Troubleshooting fresh Install
Rapid Install progress monitoring
Finishing your Installation
Explain required post-installation tasks
Describe the client software configuration process
Describe installation-specific post-installation tasks
Sanity Checks after successful installation
Oracle Applications Components
Identify and describe the high-level technology stack components that make up the desktop, application and database tiers
Understand how Oracle Applications uses the various technology stack components
Identify the various oracle homes used by the Oracle Applications
Identify and describe the role of the various Applications Technology layer products
Identify the key changes in the R12 applications technology stack
Environment Files, Control Scripts and Languages
Describe the Oracle Applications main environment file and its key parameters
Identify other important environment files
Identify application tier server control scripts
Explain how languages are supported by Oracle Applications
Oracle Applications File System
Describe the Oracle Applications file system (both database tier and application tier)
Describe the product directory structure
Identify the important product directories (AD, AU)
Describe the role of the following directories: APPL_TOP, COMMON_TOP, INST_TOP
List the directories that are new with Release 12
Oracle Applications Database
Describe the objects and schemas that exist in the Oracle Applications database
Describe the purpose of the APPS schema and Additional Schema
Impending Multiple Organization and Reporting Currencies
Overview of Database Features
Database Monitoring Features
Database Performance Features
Database Scalability and Business Intelligence Features
How to Start and Shutdown the database server and listener
Advanced Configuration Options
Understand the use of a shared application tier file system in Oracle Applications
Explain the benefits of using a staged APPL_TOP
Identify the main load balancing options and their key features
Understand the major factors in efficient network design for Oracle Applications
R12 Use Oracle Applications AD Utilities
Configuration and environment files
Identify the AD utilities
Understand the usage of command line arguments and flags
Describe parallel processing
Identify the location and usage of log and restart files. (adadmin.log and adwor0xxx.log)
Distributed AD
AD Administration: Maintain Applications Files Tasks
Relink Oracle Applications programs
Create the main Applications environment file
Identify the appropriate servers for file system administration tasks
Maintain Snapshot Information
AD Administration: Compile/Reload Database Entities Tasks
Using Compile/Reload Database Entities Tasks
Alternative methods to compile/generate & reload objects
AD Administration: Non-interactive Operation and Maintenance Mode
Create a defaults file and running AD Administration in non-interactive mode
Enable and Disable maintenance mode
Benefits of Running AD Administration in Non-interactive Mode
Defaults file available menu options
Special Utilities
Overview of AD Controller
Understand the worker status
Troubleshoot worker processes
Restart and shutdown a worker
AD Relink Utility
Describe the Upgrade Process
Review Worker Status & It’s Flow
Autoconfig
Describe the Applications Context
Describe Autoconfig
Identify Scripts used by Autoconfig
Run Autoconfig to configure an Oracle Application System
Update Applications Context Parameters
Restore Applications Context Parameters
Roll Back an Autocofig Session
Run Autoconfig in Test Mode
Troubleshooting / Dependency while running Autoconfig
Benefits of Context Files
Autoconfig in OAM
AD Administration: Maintain Database Entities Tasks
Using Different Options Maintain Database entities task
Dual Table
License Manager
License Manager Utility
Register products
Register country-specific functionalities
Register languages
Identify licensed products and languages
License Manager Summary Report
Reporting Utilities
Overview of Command Line Reporting Utilities
AD Configuration Report
AD File Identification
AD Job Timing Report
Running AD Configuration
Configuration Utilities
Install a new off-cycle product
How to use AD Splicer
Convert the character set of Applications files
Patching and the AutoPatch Process
Overview of patches (includes the purpose, types of patches, naming convention)
Describe the elements of a patch
Distinguish between a patch, minipack, maintenance pack and consolidated updates
Describe how a patch is created
Overview of Autopatch and its features/ Options
Explain the steps AutoPatch goes through to apply a patch
How to apply a Patch (both on single node and multi node configuration
Downloading a Patch
QUESTION 1
Which three are the correct definitions of the objects in the Oracle Applications database? (Choose three.)
A. Hybrid objects contain materialized view objects, and store and process data.
B. Code objects contain index, PL/SQL package, and Java-stored procedure objects.
C. Data objects contain table, index, and sequence and index-organized table objects.
D. Hybrid objects contain PL/SQL package and Java-stored procedure, and process data objects.
E. Code objects contain trigger, PL/SQL package, Java-stored procedure, synonym, and view objects.
Answer: A,C,E
QUESTION 2
The AD Administration task utility Compile APPS Schema is similar to the “Validate APPS Schema” task, except that instead of just producing a list of invalid objects, it compiles invalid objects using multiple workers in an attempt to move them back to the valid object state. This task is most often run when custom packages are moved into the APPS schema, and during the upgrade process. The “Compile APPS Schema” task can be toggled to compile all objects or just the invalid objects. Choose three correct benefits of using this task. (Choose three.)
A. increases run-time performance in the applications
B. corrects all corrupt schema package bodies and headers
C. finds truly invalid objects before users get a run-time error
D. allows new custom or patched packages to be immediately validated
Answer: A,C,D
QUESTION 3
Which three statements about the Applications Context file are true? (Choose three.)
A. It is a system configuration file.
B. It must be edited manually using a text editor.
C. It is stored in an Oracle Applications Manager (OAM) schema.
D. It can be downloaded from Oracle Applications Manager (OAM).
E. It is created by Rapid Install using AutoConfig during installation and upgrade.
F. It stores all information required to configure an Oracle Applications instance.
Answer: D,E,F
QUESTION 4
Choose two statements that are correct for AutoPatch running in Test Mode. (Choose two.)
A. It Relinks any executables.
B. It does not record patch history.
C. It reads and validates the patch driver’s file.
D. It generates any forms, reports, PL/SQL libraries, or menu files.
E. It copies any files from the patch directory to the installation area.
Answer: B,C
QUESTION 5
What is the version of the Java Oracle home in Oracle Applications Release 12?
A. 10.2
B. 8.1.7
C. 8.0.6
D. 10.1.3
E. 10.1.2
Answer: D
Click here to view complete Q&A of 1Z0-238 exam
Certkingdom Review, Certkingdom PDF Torrents
Best Oracle 1Z0-238 Certification, Oracle 1Z0-238 Training at certkingdom.com