Oracle 1Z0-238 Online Practice Questions and Exam Preparation

Oracle 1Z0-238 Online Questions & Answers

• Question 71:

  Sam has to apply a patch on his Oracle Applications system. He has already brought down the services on the application tier. The database tier and the database listener are up and running. He goes through the readme of the patch and discovers that three prerequisite patches need to be applied on the system before applying the main patch. Now, Sam needs to check if these prerequisite patches have already been applied to the system, so he decides to extract this information from the database. Identify the tables that would help him in extracting the above information from the database. (Choose all that apply.)

  A. ad_bugs
  B. fnd_bugs
  C. ad_patches
  D. ad_patches_applied
  E. ad_applied_patches
  A. ad_bugs
  E. ad_applied_patches

• Question 72:

  The patch 384610 was applied to the test environment successfully. To schedule the patch to be applied to the production environment, the Applications DBA should inform the users of the unavailability of the production environment. Which report can the Applications DBA look at to determine the estimated duration of the task, assuming that the hardware, server load, and applications running on the servers are unchanged?

  A. Timing report
  B. Bug Fixes report
  C. Files Copied report
  D. Action Details report
  E. Patch Details report
  F. Action Summary report
  A. Timing report

• Question 73:

  Identify three valid AD utilities for Oracle E-Business Suite R12. (Choose three.)

  A. admail
  B. adjkey
  C. adident
  D. adsplice
  E. adcontrol
  F. adcfgclon
  G. adlicmgr.sh
  B. adjkey
  C. adident
  D. adsplice

• Question 74:

  You run a report that generates output in PDF format. The report completes with the error "REP- 3000: Internal error starting Oracle Toolkit." How will you resolve this?

  A. Set up the DISPLAY environment variable in .profile of the database user.
  B. Set up the DISPLAY environment variable in .profile of the application user.
  C. No DISPLAY settings are required. Shutting down and restarting the services under APPSTier will fix the issue.
  D. Set up the DISPLAY environment variable in adovars.env to point to an active X Windows.
  E. Set up the DISPLAY environment variable in $CONTEXT_FILE of the database tier to point to an active X Windows, and then run AutoConfig.
  F. Set up the DISPLAY environment variable in $CONTEXT_FILE of the application tier to point to an active X Windows, and then run AutoConfig.
  F. Set up the DISPLAY environment variable in $CONTEXT_FILE of the application tier to point to an active X Windows, and then run AutoConfig.

• Question 75:

  John and Peter are working for the same project and handling the same environment called TEST. John receives a request to apply a big patch on the TEST environment. He stops all services and starts applying this patch. At the time when d-portion of the patch is going on, Peter gets a request to recompile all forms of the GL schema. Peter is not aware that John is applying the patch, so he starts adadmin in the other session. What will happen in this case?

  A. As soon as Peter executes adadmin, the adpatch session gets killed.
  B. As soon as Peter executes adadmin, both adpatch and adadmin sessions get killed.
  C. As soon as Peter executes adadmin, he gets the error You must be in Maintenance Mode to run adadmin.
  D. As soon as Peter executes adadmin, he gets the error "You dont have permissions to execute adadmin as adpatch is running."
  E. As soon as Peter executes adadmin and passes all relevant parameters required by adadmin to generate all GL forms, adpatch will run as it was running and adadmin will indicate that "the FND_INSTALL_PROCESSES table created by AutoPatch already exists."
  E. As soon as Peter executes adadmin and passes all relevant parameters required by adadmin to generate all GL forms, adpatch will run as it was running and adadmin will indicate that "the FND_INSTALL_PROCESSES table created by AutoPatch already exists."

• Question 76:

  Which AutoPatch option is used to run a noninteractive autopatch session?

  A. defaultfile
  B. defaultsfile
  C. default_file
  D. defaults_file
  B. defaultsfile

• Question 77:

  What kind of files can be found in the /admin directory?

  A. data merge files used to upgrade seed data
  B. driver files, which control AutoUpgrade processes
  C. product-specific files used by AutoUpgrade to upgrade that product
  D. object-description files used to create tables and other database objects
  C. product-specific files used by AutoUpgrade to upgrade that product

• Question 78:

  The Application Utilities (AU_TOP) directory contains _____.

  A. a consolidated set of all product files
  B. utilities such as AutoUpgrade and AutoPatch
  C. files and scripts used by AutoUpgrade during upgrade
  D. consolidated logs and output directories used by concurrent processing
  A. a consolidated set of all product files

• Question 79:

  Identify the elements of a patch. (Choose all that apply.)

  A. unified driver
  B. readme files
  C. generic driver
  D. patch history files
  E. patch metadata files
  A. unified driver
  B. readme files
  E. patch metadata files

• Question 80:

  Where can you find the generated report file after running the Validate APPS schema task in the Oracle Applications R12 E-Business Suite setup?

  A. /admin/.lst
  B. /admin/out/.lst
  C. /admin/out/.lst
  D. /admin//out/.lst
  E. /admin//out/.lst
  E. /admin//out/.lst