Free Oracle 1Z1-238 Exam Dumps Questions & Answers

How many ORACLE_HOMEs are there in the architecture of Oracle Applications Release 12?

• A.  five
• B.  two
• C.  four
• D.  one
• E.  three

Which three are the correct definitions of the objects in the Oracle Applications database? (Choose three.)

• A.  Hybrid objects contain PL/SQL package and Java-stored procedure, and process data objects.
• B.  Code objects contain trigger, PL/SQL package, Java-stored procedure, synonym, and view objects.
• C.  Data objects contain table, index, and sequence and index-organized table objects.
• D.  Code objects contain index, PL/SQL package, and Java-stored procedure objects.
• E.  Hybrid objects contain materialized view objects, and store and process data.

As the Applications DBA, you are tasked to apply a patch and use the adpatch utility in the command line. Only the database driver should be applied. Choose the correct adpatch command-line syntax.

• A.  adpatch option=nocopyportion, nogenerateportion
• B.  adpatch option=nodatabaseportion,nocopyportion,nogenerateportion
• C.  adpatch options=nocopyportion,nogenerateportion
• D.  adpatch options=applydatabaseportion
• E.  adpatch OPTIONS=NOCOPYPORTION,NOGENERATEPORTION

As an Applications DBA, you have been asked to apply a patch that updates the Applications Context file and runs AutoConfig. The application does not work properly with the new, updated application environment. What should you do to roll back an AutoConfig session?

• A.  Use the restore.sh script which is located at <INST_TOP>/admin/out/<MMDDhhmm>.
• B.  Use the restore.sh script which is located at <INST_TOP>/admin/log/<MMDDhhmm>.
• C.  Use the rollback.sh script which is located at <INST_TOP>/admin/out/<MMDDhhmm>.
• D.  Use the rollback.sh script which is located at <APPL_TOP>/admin/log/<MMDDhhmm>.

A patch was applied successfully last night to the Oracle Applications environment to fix a bug. To check the bug fix, the Applications DBA accessed the "Bug Fixes Report." There are 1,000 files displayed in the report. The intended file for the bug fix does not appear. What should the Applications DBA do next?

• A.  Check readme.txt for postinstallation steps.
• B.  Reapply the patch on the Oracle Applications environment.
• C.  Access the Timing report.
• D.  Use the filter to reduce the number of files in the report.
• E.  Start the Oracle Application Manager (OAM) process.