1Z0-238 Online Practice Questions and Answers

The Cumulative Update 2 (CU2) patch was applied to the test environment. The patch took a few hours to apply. The Applications DBA was assigned the task of investigating the changes made by the CU2 patch. The investigation would involve a comparison of the prepatched development environment and the patched test environment. Which tool should the Applications DBA use?

A. Oracle Enterprise Manager

B. Oracle Applications Manager

C. Oracle Discoverer reporting tool

D. Oracle Business Intelligence products

E. SQL*Plus program to access the FND tables

F. Oracle Applications concurrent request (System Administrator) reports

How many ORACLE_HOMEs are there in the architecture of Oracle Applications Release 12?

A. four

B. five

C. two

D. one

E. three

You run the adadmin utility to generate message files. It completes with errors. Where will you find the log file (adadmin.log)?

A. $INST_TOP/logs/appl/admin/log

B. $INST_TOP/logs/ora/10.1.2/log

C. $APPL_TOP/admin/$CONTEXT_NAME/log

D. $AD_TOP//log, where is the value of your ORACLE_SID or TWO_TASK variable (UNIX) or LOCAL variable (Windows)

E. $APPL_TOP/admin//log, where is the value of your ORACLE_SID or TWO_TASK variable (UNIX) or LOCAL variable (Windows)

What is the default value of ?

A. APPS_

B. APPS_

C. _

D. _

E. APPS_

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

Which can be patched using the AutoPatch utility? (Choose all that apply.)

A. Oracle Database

B. Oracle Applications

C. Oracle Application Server

D. Oracle Development Tools

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.

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

What is true about the worker process in the Oracle Applications R12 environment?

A. When a worker runs a job for the first time, if the job fails, the manager automatically defers the job to retry at a later time.

B. When a worker runs a job for the third time, if the job fails, the status of the job stays at failed and the worker starts the next job.

C. As long as the total run time is less than 10 minutes, the manager defers the job to retry at the end of the current phase, even if that job failed the previous three times.

D. When a worker runs a job for the second time, if the job fails and the total run time is 15 minutes, then the status of the job stays at failed and the worker starts the next job.

You installed Oracle Applications Release 12 as a multi-node system where every node has a separate APPL_TOP. Consider the following configuration:

Node 1 hosts Forms server and Web server.

Node 2 hosts batch processing services and database server.

As per the above configuration, which values will you find in the Applications Context file of Node 1? (Choose all that apply.)

A. s_isAdWeb = Yes

B. s_isAdConc = Yes

C. s_isAdAdmin = No

D. s_isAdForms = Yes

E. s_isAdAdmin = Yes

Your Oracle Applications system is reporting some problem and the solution is to apply a patch. Before applying the patch, you want to check the effects this new patch would have on your system. Which command would help you achieve this?

A. adpatch

B. adpatch test=y

C. adpatch apply=n

D. adpatch preinstall=y

What are the three benefits of the Oracle Applications Tablespace Model? (Choose three.)

A. takes advantage of manual segment management

B. simplifies maintenance and recovery by using fewer tablespaces

C. uses locally managed tablespaces, and enables more control over unused space

D. decreases block-packing compared to the older model, increasing the overall number of buffer gets

E. makes best use of the restricted number of raw devices available in Real Application Clusters (RAC) andother environments

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 .

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

Oracle Applications produces temporary PL/SQL output files used in concurrent processing. These files are written to a location on the database server node specified by the APPLPTMP environment setting. What would be the value of APPLPTMP in the environment setting?

A. the temporary directory used by the operating system

B. the $COMMON_TOP/temp directory where the common files are located

C. the last value defined for the UTL_FILE_DIR parameter in the init.ora file

D. the first value defined for the UTL_FILE_DIR parameter in the init.ora file

E. the $APPLCSF/out directory where the Applications common output files are located