Oracle 1Z0-238 Online Practice Questions and Exam Preparation

Oracle 1Z0-238 Online Questions & Answers

• Question 81:

  Which statement is true regarding AutoPatch in the Oracle Applications Release 12 environment?

  A. AutoPatch is platform-independent.
  B. There is a limit to the number of times AutoPatch can be restarted.
  C. If language translation patches need to be applied in addition to the patch you are applying, AutoPatch notifies you.
  D. If all the prerequisite patches have not been applied, AutoPatch lists the missing prerequisites and continues with applying the current patch.
  E. AutoPatch replaces the files in the product directory with the files in the patch directory in case the latter have the same version as the former.
  C. If language translation patches need to be applied in addition to the patch you are applying, AutoPatch notifies you.

• Question 82:

  Which two statements are correct about multi-node cloning using Rapid Clone (adcfgclone.pl) for Oracle Applications R12? (Choose two.)

  A. Rapid Clone cannot be used for cloning if the source system is using a shared file system.
  B. Post clone must be run first on the application tier node and then on the database node.
  C. Rapid Clone can be used where the source system or the target system is a multi-node system.
  D. Rapid Clone cannot be used for cloning if the source is using Parallel Concurrent Processing (PCP).
  E. One copy of the applications node files must be copied to the target system, regardless of whether a shared file system is being used on the source or the target system.
  C. Rapid Clone can be used where the source system or the target system is a multi-node system.
  E. One copy of the applications node files must be copied to the target system, regardless of whether a shared file system is being used on the source or the target system.

• Question 83:

  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.
  A. Hybrid objects contain materialized view objects, and store and process data.
  C. Data objects contain table, index, and sequence and index-organized table objects.
  E. Code objects contain trigger, PL/SQL package, Java-stored procedure, synonym, and view objects.

• Question 84:

  A company has implemented Oracle Applications Release 12. It wants tob configure a system that sends emails to key database administrators (DBAs) when a tablespace in the Oracle Applications database does not have adequate free space. Identify which component in the Oracle Applications technology layer performs this task.

  A. Oracle Alert
  B. Oracle Workflow
  C. Oracle E-mail Notification
  D. Oracle Applications Framework
  A. Oracle Alert

• Question 85:

  Which three statements are true about the AD Merge program? (Choose three.)

  A. The AD Merge Patch creates the merged patch driver files and copies the actual files needed by the merged patches into the destination directory.
  B. You can merge patches without unzipping the automated release updates by using the manifest file. The manifest file is a text in which youdocument the location and names of the patch zip files. The contents of a manifest file would resemble the following: /home/applmgr/patches/p123456_11i_GENERIC.zip /home/applmgr/patches/p233455_11i_SUN.zip /home/applmgr/patches/p902345_11i_LINUX.zip
  C. The AD Merge Patch supports both split patch driver files and unified patch driver files. If all the source patches have split driver files, the merged patch has split driver files. If any of the source patches has a unified driver file, the merged patch has a unified driver file.
  D. When merging patches, the source and destination directories cannot be child or parent directories of each other. It is recommended to run AD Merge Patch from the parent directory of the source directory, and the destination directory should also belocated in the same parent directory.
  A. The AD Merge Patch creates the merged patch driver files and copies the actual files needed by the merged patches into the destination directory.
  C. The AD Merge Patch supports both split patch driver files and unified patch driver files. If all the source patches have split driver files, the merged patch has split driver files. If any of the source patches has a unified driver file, the merged patch has a unified driver file.
  D. When merging patches, the source and destination directories cannot be child or parent directories of each other. It is recommended to run AD Merge Patch from the parent directory of the source directory, and the destination directory should also belocated in the same parent directory.

• Question 86:

  In Oracle Applications R12, to which directory does the $OA_HTML environment variable point?

  A. $INST_TOP/html
  B. $COMMON_TOP/html
  C. $INST_TOP/webapps/oacore/html
  D. $COMMON_TOP/webapps/oacore/html
  D. $COMMON_TOP/webapps/oacore/html

• Question 87:

  In which scenario does the Applications DBA need to run the Rapid Clone utility?

  A. There are two systems (Test and Production) for XYZ company. There are invalid objects being encountered in the Production system. The errors are not happening on the Test system.The Applications DBA plans to run the Oracle utility on the Production system to fix the invalid objects.
  B. ABC company has three systems: Development, Test, and Production. Testing of the Oracle Applications patches are being done on the Test system and being promoted to Development for further testing. After the patches are tested in the Test and Development systems without any issues, they would be promoted to the Production system. The Applications DBA plans to run the Oracle utility for the promotion of the patch.
  C. There was a hardware disk failure on the Development server. The Development system was being used to test the application patches. The POIUY company has only two systems: Development and Production. As soon as the hardware disk failure is resolved on the Development server, there is a need to rebuild that Development system. The Applications DBA plans to run the Oracle utility to rebuild the Development system.
  D. There is a need for another Oracle Applications system to test the patches to be applied on the Production system. Currently, QWERT company has five Oracle Applications systems including Production. The Production and Test systems are on Release 12.2.10 and the remaining systems are on Release 12.2.9. The Applications DBA plans to run the Oracle utility on the Test system to test the patch.
  C. There was a hardware disk failure on the Development server. The Development system was being used to test the application patches. The POIUY company has only two systems: Development and Production. As soon as the hardware disk failure is resolved on the Development server, there is a need to rebuild that Development system. The Applications DBA plans to run the Oracle utility to rebuild the Development system.

• Question 88:

  When you choose Search Patches from Oracle Applications Manager Site Map, it defaults to the Applied Patches Simple Search page. What can you do from this Applied Patches home page?

  A. Go to Oracle Enterprise Manager (OEM).
  B. Go to other OAM functionality by selecting it from the option buttons.
  C. Click the Calendar button to view the patches applied on a specific date.
  D. Click the Family Pack button to view all applied family pack patches.
  E. Click the Advanced Search button to access the Applied Patches Advanced Search page.
  E. Click the Advanced Search button to access the Applied Patches Advanced Search page.

• Question 89:

  You downloaded an HRMS patch from Oracle MetaLink, and you run AutoPatch to apply it to the Oracle Applications R12 test setup in your company. If AutoPatch shows an error in one of the workers' jobs, how do you determine the source of the error?

  A. Check the AutoPatch log file for the source of the error.
  B. Review adworkxxx.log in $APPL_TOP/admin//log.
  C. Use the AD Controller utility, and choose the Review worker status.
  D. Search the Oracle MetaLink Web site for the worker control number.
  B. Review adworkxxx.log in $APPL_TOP/admin//log.

• Question 90:

  Which directory structure is created by default when you install the Oracle Applications R12 file system?

  A. db/apps_st/10.2.0
  B. apps/tech_st/10.2.0
  C. apps/tech_st/10.1.2
  D. apps/apps_st/common
  C. apps/tech_st/10.1.2