Oracle Oracle Certifications 1Z0-238 Questions & Answers

• Question 51:

  Oracle Workflow provides infrastructure for the enterprise wide communication of data. This data is related to defined business events, providing capabilities needed to _____. (Choose three.)

  A. manage concurrent processing

  B. streamline and automate transaction flows

  C. notify users about specific database exceptions

  D. support standard and personalized business rules

  E. deliver notification emails to any Oracle Applications or Internet user

  Correct Answer: BDE

• Question 52:

  The worker shows the Running or Restarted status, but the process is not really running. Which are the two corrective actions that you would perform to restart a worker? (Choose two.)

  A. Tell the worker to quit.

  B. Tell the worker to shut down.

  C. Restart a worker on the current machine.

  D. Tell the manager that a worker has failed in its job.

  E. Tell the manager that a worker acknowledges quit.

  Correct Answer: CD

• Question 53:

  Which four statements are true about the Rapid Clone utility? (Choose four.)

  A. It removes components of the file system.

  B. It does not remove any components of the file system.

  C. It can be used to migrate an existing system to a new server.

  D. It reimplements the saved configuration on the target system.

  E. It is applied in Normal mode to all APPL_TOPs on the source system.

  F. It preserves the Oracle Applications configuration information that is specific to the target system.

  Correct Answer: ACDF

• Question 54:

  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.

  Correct Answer: BDE

• Question 55:

  Identify two ways in which you validate the APPS schema in the Oracle Applications R12 EBusiness Suite setup. (Choose two.)

  A. Run the /appsutil/scripts//advrfapp.sh script.

  B. Run the AD Administration utility in noninteractive mode with the default file having menu_option=VALIDATE_APPS.

  C. Run the AD Administration utility in interactive mode, and then select Compile/Reload Applications Database Entities menu > Compile APPS Schema option.

  D. Use SQL*PLUS / @$AD_TOP/admin/sql/advrfapp.sql .

  Correct Answer: BD

• Question 56:

  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

  Correct Answer: A

• Question 57:

  When you execute adutconf.sql as the apps database user, it creates a file called adutconf.lst. Identify the configuration information that will be captured in adutconf.lst. (Choose four.)

  A. Product installation status

  B. Rollback segment information

  C. Version of Oracle Applications

  D. Status of Multiorg enabled or not

  E. Location and size of database data files

  F. Versions of all ORACLE_HOMEs used by Oracle Applications R12

  Correct Answer: ABCD

• Question 58:

  Which three statements are true? (Choose three.)

  A. adcfgclone.pl must successfully finish on the database tier first.

  B. adcfgclone.pl must successfully finish on the application tier first.

  C. The apps password is required to run adcfgclone.pl on the application tier.

  D. The port pool information is required for running adcfgclone.pl on the database tier.

  E. The system database user password is required to run adcfgclone.pl on the application tier.

  F. adcfgclone.pl can be run in any sequence. It can be run on the database tier first or on the application tier first.

  Correct Answer: ACD

• Question 59:

  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

  Correct Answer: AE

• Question 60:

  Identify three situations where relinking may be necessary. (Choose three.)

  A. after running AutoConfig

  B. after the server libraries are updated

  C. after the product JAR files are generated

  D. when executable programs become corrupted

  E. when executable programs are accidentally deleted

  Correct Answer: BDE