Oracle 1Z0-238 Online Practice Questions and Exam Preparation

Oracle 1Z0-238 Online Questions & Answers

• Question 61:

  In an Oracle Applications R12 environment, worker restart files are used to continue processing from the point where it stopped. Where can you locate these files?

  A. $AD_TOP/admin//log
  B. $APPL_TOP/admin//log
  C. $AD_TOP/admin//restart
  D. $APPL_TOP/admin//restart
  E. $APPL_TOP/admin//wrkr/log
  F. $AD_TOP/admin//wrkr/restart
  D. $APPL_TOP/admin//restart

• Question 62:

  You are applying a patch on the database tier. You run AutoConfig as a post installation task of the patch. But the AutoConfig script exits with nonzero status. What should be your first action to resolve the problem?

  A. Restart the patch.
  B. Restart AutoConfig.
  C. Check /admin/log//adconfig.log for the reported error.
  D. Check /appsutil/log///adconfig.log for the reported error.
  D. Check /appsutil/log///adconfig.log for the reported error.

• Question 63:

  Which directory in Oracle Applications R12 contains ORACLE_HOME used for the tools components of the Applications technology stack?

  A. apps/tech_st/8.1.7
  B. apps/tech_st/8.0.6
  C. apps/tech_st/10.1.3
  D. apps/tech_st/10.1.2
  E. apps/tech_st/10.2.0
  D. apps/tech_st/10.1.2

• Question 64:

  Which statement holds true when AutoPatch is run in test mode?

  A. AutoPatch runs AutoConfig in test mode.
  B. AutoPatch relinks executables in test mode.
  C. AutoPatch runs SQL scripts or any executables in test mode.
  D. AutoPatch generates forms, reports, menus, and PL/SQL libraries in test mode.
  A. AutoPatch runs AutoConfig in test mode.

• Question 65:

  What are the three benefits of having the APPS schema in the Oracle Applications R12 database? (Choose three.)

  A. By using the APPS schema, the effect of inefficient ad hoc queries is limited.
  B. By eliminating the need for cross-product grants and synonyms, the APPS schema improves reliability.
  C. The APPS schema helps to ensure that the highest-priority business activities always have sufficient resources.
  D. By using one APPS schema that can access all Oracle Applications objects, cross- product dependencies are eliminated.
  E. By eliminating the need for cross-product grants and synonyms, the APPS schema reduces the time needed for installation, upgrade, and patching.
  B. By eliminating the need for cross-product grants and synonyms, the APPS schema improves reliability.
  D. By using one APPS schema that can access all Oracle Applications objects, cross- product dependencies are eliminated.
  E. By eliminating the need for cross-product grants and synonyms, the APPS schema reduces the time needed for installation, upgrade, and patching.

• Question 66:

  As an Oracle Applications DBA, you are asked to bring up the Oracle Applications R12 environment, which is restored from backup. You try to start the services and find that the startup scripts adapcctl.sh, adalnctl.sh, and adcmctl.sh are missing. Identity which utility you will use to re-create these scripts?

  A. adrelink.sh
  B. adgensgn.sh
  C. adautocfg.sh
  D. adcfginfo.sh
  E. adcrscrpts.sh
  C. adautocfg.sh

• Question 67:

  Identify which three statements are true about restart files. (Choose three.)

  A. Each worker has a restart file called adworkxxx.rf9.
  B. All workers have one restart file called adwork.rf9.
  C. By default, AD utilities delete their restart files when processing completes, but leave no backup versions.
  D. The worker creates the restart file when the manager assigns it a job and deletes the restart file when it finishes the job.
  E. By default, AD utilities delete their restart files when processing completes, but leave backup versions with the .bak, .bk2, or .bk3 extensions.
  F. Restart files are stored in $APPL_TOP/admin//restart or in %APPL_TOP%\admin \ \restart on Windows.
  A. Each worker has a restart file called adworkxxx.rf9.
  D. The worker creates the restart file when the manager assigns it a job and deletes the restart file when it finishes the job.
  E. By default, AD utilities delete their restart files when processing completes, but leave backup versions with the .bak, .bk2, or .bk3 extensions.

• Question 68:

  You are in the midst of applying a patch on an Oracle Applications system when AutoPatch reports that one of the workers failed and that it requires you to fix this error before proceeding. Where would you get detailed information about the cause of the worker's failure?

  A. adpatch.lgi
  B. adpatch.log
  C. adwrkXXX.log
  D. adworkXXX.log
  E. adworkerXXX.log
  D. adworkXXX.log

• Question 69:

  The Applications DBA is assigned to merge five patches without unzipping the automated release updates (ARUs), by running the AD Merge Patch. Which UNIX command has the correct arguments?

  A. admgrpch -s -d \ -merge_name -manifest
  B. admrgpch -s -t \ -merge_name -manifest
  C. admrgpch -s -d \ -merge_name
  D. admrgpch -s -d \ -mergename -manifest
  E. admrgpch -s -d \ -merge_name - manifest_name
  A. admgrpch -s -d \ -merge_name -manifest

• Question 70:

  The Oracle Applications Release 12 processes on the application tier are started successfully. The Applications database administrator (DBA) must apply a patch while the users are still using Oracle Applications. According to the instructions from readme.txt of the patch to be applied, only the concurrent manager process must be shut down before applying the patch. After the patch is applied successfully, one should start the concurrent manager processes. The Applications DBA performs these steps to apply the patch on the application tier:

  Step 1: Logs in to the application tier as "applmgr" Step 2: Changes to the $INST_TOP/admin/scripts directory Step 3: Executes the adstpall.sh script Step 4: Applies the patch Step 5: Checks the log file of the patch for any errors Step 6: Runs the $INST_TOP/admin/scripts/ adstrtal.sh script

  What do you conclude?

  A. There are no mistakes in the steps.
  B. In the sixth step, the location of the script is wrong.
  C. In the third step, the adstpall.sh script should not be used.
  D. In the first step, the user should be oracle instead of applmgr.
  C. In the third step, the adstpall.sh script should not be used.