Oracle Oracle Certifications 1Z0-238 Questions & Answers

• Question 31:

  Identify the environmental variable that defines to which ORACLE schema the System Administration responsibility connects.

  A. GWYID

  B. DBNAM

  C. FNDNAM

  D. FNDCPASS

  E. APPLFENV

  Correct Answer: C

• Question 32:

  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

  Correct Answer: D

• Question 33:

  You want to run preclone on database tier. You logged in to the database node and realized that the appsutil directory is missing. Identify the command you use to re-create appsutil.zip, so that the appsutil directory can be re-created.

  A. perl /bin/admkdbutil.pl

  B. perl /bin/admkappsutil.pl

  C. perl /appl/bin/admkappsutil.pl

  D. perl /appl/bin/admkappsutil.pl

  Correct Answer: B

• Question 34:

  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.

  Correct Answer: C

• Question 35:

  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.

  Correct Answer: BC

• Question 36:

  You have successfully completed preclone on the application tier node. Which application tier file system needs to be copied from the source applications node to the target node for completing postclone successfully on the target node?

  1 .

  2 .

  3.

  4.

  5. oraInventory

  A. 1, 3, 4

  B. 1, 3, 5

  C. 2, 3, 4

  D. 1, 2 ,4

  E. 1, 2, 3

  F. 2, 3, 5

  Correct Answer: A

• Question 37:

  Which two values must be set for changing the temporary directory for log and output files from the PL/ SQL concurrent program? (Choose two.)

  A. TMP_DIR variable

  B. APPLPTMP variable

  C. APPLTMP parameter

  D. Utl_file_dir parameter

  Correct Answer: BD

• Question 38:

  Identify three modes in which AutoPatch can be run, in addition to the normal patch application mode. (Choose three.)

  A. hotptch

  B. Test mode

  C. Pre-install mode

  D. Non-interactive operation

  E. Patch Impact Analysis Mode

  Correct Answer: BCD

• Question 39:

  The Oracle Applications R12 database administrator (DBA) runs the "Recreate grants and synonyms for APPS schema" task by using the adadmin utility when grants or synonyms are missing from the database. Which three causes are responsible for this? (Choose three.)

  A. incomplete database migrations (exports or imports)

  B. patch and administrative sessions that failed to run successfully to completion

  C. invoking PL/SQL routines to maintain multilingual tables by adding missing, untranslated rows

  D. installing or maintaining Oracle Applications R12 E-Business Suite underlying database components or options such as Replication

  Correct Answer: ABD

• Question 40:

  You were applying an Oracle Receivables patch to your Oracle Applications system. The patch failed. Now you want to revert to the older version of the files under the product AR using the backup copy, which AutoPatch creates, before making any changes to the existing files. Where would you find these files?

  A. $AR_TOP/backup/

  B. $AD_TOP/backup/ar/

  C. /backup/ar/

  D. /backup///ar/

  Correct Answer: D