Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Oracle 1z0-238 R12 Oracle: Install, Patch and Maintain Oracle Applications Exam Practice Test

Demo: 33 questions
Total 225 questions

R12 Oracle: Install, Patch and Maintain Oracle Applications Questions and Answers

Question 1

Identify the files that are changed when you run AutoConfig. (Choose all that apply.)

Options:

A.

/listener.ora

B.

/.env

C.

/admin/adconfig.txt

D.

/.env

E.

/appl/admin/.xml

Question 2

Where is the AutoPatch executable located in Oracle Applications R12?

Options:

A.

$AD_TOP

B.

$AU_TOP/bin

C.

$AD_TOP/bin

D.

$APPL_TOP/admin

E.

$COMMON_TOP/bin

Question 3

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?

Options:

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.

Question 4

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.

Options:

A.

perl /bin/admkdbutil.pl

B.

perl /bin/admkappsutil.pl

C.

perl /appl/bin/admkappsutil.pl

D.

perl /appl/bin/admkappsutil.pl

Question 5

In AD Controller, when a job fails the first and second time, the manager automatically defers it to the end of the phase and assigns a new job to the worker. If the deferred job fails the third time, the job stays at the failed status and the worker waits. At this point, you must address the cause of the failure, and then restart the job using AD Controller. Choose two correct steps that would help you to troubleshoot the failure of the job and enable you to run the job to completion. (Choose two.)

Options:

A.

Verify whether the process is consuming CPU time.

B.

Review the adworkXXX.log worker log file in $APPL_TOP/admin//log to find the error.

C.

Review the file name and worker columns of the failed worker to find the name of the failed file and the worker number.

D.

Check for an entry for this process in the V$SESSION table to gather clues about what the process is doing in the database.

Question 6

Identify the script that is used to control the Forms server process in socket mode.

Options:

A.

adfrctl.sh

B.

adfrmctl.sh

C.

adapcctl.sh

D.

adalnctl.sh

E.

adformsrvctl.sh

Question 7

During the AutoUpgrade process, a worker process fails to complete the assigned job, and updates the status as failed. The Review worker status window of AD Controller also shows that the worker status is failed. The log file shows that one of the tables that needs to be updated is locked, and the worker is waiting for the lock to be released and timed out. If the job is deferred after the worker fails, what do you do next?

Options:

A.

Resolve the error and restart the failed job.

B.

Review the worker log file and resolve the error.

C.

Restart the failed job and verify the worker status.

D.

No immediate action is required unless the job fails again.

Question 8

You have done a single-node installation of Oracle Applications R12 on node 1. Because of some resource issues, you move only DB_ORACLE_HOME(10.2.0.2) and the database (.dbf files) to a new server (node 2).

Which statement is correct about uXXXXXX.drv being applied to node 1 and node 2?

Options:

A.

uXXXXXX.drv only on node 2

B.

uXXXXXX.drv only on node 1

C.

uXXXXXX.drv on node 1, and then on node 2

D.

uXXXXXX.drv on node 2, and then on node 1

Question 9

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?

Options:

A.

$AR_TOP/backup/

B.

$AD_TOP/backup/ar/

C.

/backup/ar/

D.

/backup//<appl_top_name>/ar/

Question 10

Your patch was applied and finished without encountering any error during the process. Which is NOT a correct part of the postpatch process?

Options:

A.

updating the MLS

B.

removing any obsolete files

C.

restarting all server processes

D.

cleaning up the log, restarting and out directories

E.

pinning packages and sequences in the System Global Area

F.

performing any manual steps on the basis of readme.txt of the patch

G.

using the Change Maintenance Mode option of AD Administration to enable maintenance mode

Question 11

John is working for XYZ company. He received a tape from a customer that has the.dbf files and ORACLE_HOME database. He extracted the .dbf files from the tape to the server. After checking, he realized that the customer's DBA forgot to run preclone on the source database tier before taking a backup on the tape. To bring up the database successfully using adcfgclone.pl (postclone) on target, what action would you ask the customer's DBA to perform instead of requesting for a full backup again?

Options:

A.

Run preclone on the source database tier and request the customer's DBA to send only .xml.

B.

Run preclone on the source database tier and request the customer's DBA to send only the oraInventory directory.

C.

Run preclone on the source database tier and request the customer's DBA to send only the .dbf system tablespace files.

D.

Run preclone on the source database tier and request the customer's DBA to send only bin under the $ORACLE_HOME database.

E.

Run preclone on the source database tier and request the customer's DBA to send only the appsutil directory under the $ORACLE_HOME

database.

Question 12

As an Applications DBA, you have been asked to apply a patch that updates the Applications Context file and runs AutoConfig. The application does not work properly with the new, updated application environment. What should you do to roll back an AutoConfig session?

Options:

A.

Use the restore.sh script which is located at /admin/out/.

B.

Use the restore.sh script which is located at /admin/log/.

C.

Use the rollback.sh script which is located at /admin/log/.

D.

Use the rollback.sh script which is located at /admin/out/.

Question 13

In Oracle Applications R12, the Applications modules (packaged in the formsapp.ear file) are deployed to the OC4JForms instance. Identify the ORACLE_HOME used by this OC4J instance.

Options:

A.

8.0.6

B.

8.1.7

C.

10.1.2

D.

10.1.3

E.

10.2.0.2

Question 14

Which two statements are correct about multi-node cloning using Rapid Clone (adcfgclone.pl) for Oracle Applications R12? (Choose two.)

Options:

A.

Rapid Clone cannot be used for cloning if the source system is using a shared file system.

B.

Post clone must be run first on the application tier node and then on the database node .

C.

Rapid Clone can be used where the source system or the target system is a multi-node system.

D.

Rapid Clone cannot be used for cloning if the source is using Parallel Concurrent Processing (PCP).

E.

One copy of the applications node files must be copied to the target system, regardless of whether a shared file system is being used on the

source or the target system.

Question 15

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?

Options:

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

Question 16

What are the prerequisites (minimum version) at the operating system level before cloning an environment in Oracle Applications Release 12?

Options:

A.

tar version 4.x (Minimum) and zip version 3 (Minimum)

B.

perl version 5.x (Minimum) and zip version 2.3 (Minimum)

C.

gzip version 2.5 (Minimum) and tar version 5.0 (Minimum)

D.

gunzip version 5.x (Minimum) and perl version 5.x (Minimum)

E.

perl version 2.3 (Minimum) , zip version 5.x (Minimum), and gunzip version 5.x (Minimum)

Question 17

During the AutoUpgrade process, a worker process fails to complete the assigned job, and updates the status as failed. The Review worker status window of AD Controller also shows that the worker status is failed. The log file shows that one of the tables that needs to be updated is locked, and the worker is waiting for the lock to be released and timed out. If the job is deferred after the worker fails, what do you do next?

Options:

A.

Resolve the error and restart the failed job.

B.

Review the worker log file and resolve the error.

C.

Restart the failed job and verify the worker status.

D.

No immediate action is required unless the job fails again.

Question 18

What are the four benefits of using shared APPL_TOP? (Choose four.)

Options:

A.

Disk space requirements are greatly reduced.

B.

Administrative tasks need to be carried out only once, on any node.

C.

There is an increased performance for larger workloads and growing user population.

D.

All active instances can concurrently execute transactions against a shared database.

E.

It provides extensible system architecture; machines can be easily added to an existing system.

F.

By enabling the use of distributed AD, it improves the efficiency of patch application, thereby reducing the down time.

Question 19

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

Options:

A.

unified driver

B.

readme files

C.

generic driver

D.

patch history files

E.

patch metadata files

Question 20

Identify three application-tier technology components used in Oracle Applications Release 12. (Choose three.)

Options:

A.

Jserv

B.

Oracle Developer 10g

C.

Oracle JDeveloper 9i

D.

Application Server 10.1

E.

Oracle HTTP Server/Apache 10.1.3

Question 21

You have a multi-node installation with Forms services and Batch Processing services configured on separate nodes. You attempt to update the Context variable on the batch processing node although Oracle Applications Manager (OAM) fails. What should you do to resolve the problem? (Choose two.)

Options:

A.

Check whether the Web service is up on Forms services.

B.

Check whether the Forms service is up on the middle tier.

C.

Check whether the listener service is up on Forms services.

D.

Check whether the batch processing service is up on the middle tier.

E.

Enable the TNS listener service in the Application's Context file and run AutoConfig.

Question 22

Which three statements are true? (Choose three.)

Options:

A.

Express installation can be used with multi-node installation.

B.

Multi-node installation provides a highly scalable environment.

C.

Shared APPL_TOP is applicable only with multi-node installation.

D.

The load balancing setup window appears during the multi-node installation process.

E.

The rapidwiz -servername command can be used during multi-node installation.

Question 23

As an Applications DBA, you are tasked with cloning a User Acceptance Test System (UAT) to Test System on July 28. You ran preclone on database tier on July 23 itself. Between July 23 and July 28, some changes have happened to the database. Identify three scenarios in which you would have to run preclone again. (Choose three.)

Options:

A.

A database was restarted

B.

A tablespace was dropped.

C.

A custom schema was dropped.

D.

A database data file was resized.

E.

A data file was added to the database.

Question 24

AD Administration contains a utility named Maintain Snapshot Information. Which statements correctly describe the functionality of this utility? (Choose all that apply.)

Options:

A.

You can create a copy of an existing snapshot.

B.

You can delete the current view snapshot.

C.

You can create a list of the current view and named snapshots stored in your system.

D.

You can export an existing snapshot to a file for storage or to another system.

E.

You can update the current view snapshot with any changes to the snapshot since the last update.

Question 25

As the Applications DBA, you are tasked to apply a patch and use the adpatch utility in the command line. Only the database driver should be applied. Choose the correct adpatch command-line syntax.

Options:

A.

adpatch options=applydatabaseportion

B.

adpatch option=nocopyportion, nogenerateportion

C.

adpatch OPTIONS=NOCOPYPORTION,NOGENERATEPORTION

D.

adpatch options=nocopyportion,nogenerateportion

E.

adpatch option=nodatabaseportion,nocopyportion,nogenerateportion

Question 26

You just brought the middle tier back after a hardware problem has been fixed. Oracle Applications now experience problems with an entire product group of forms (fnd), which includes the sign-on form.

You decide that you will generate the forms files in AD Administration to see whether this will fix the problem.

You answered the prompts from the utility as follows:

1. Do you want to generate Oracle Forms using your current character set? (Yes)

2. Do you want to regenerate Oracle Forms PL/SQL library files? (Yes)

3. Do you want to regenerate Oracle Forms executable files? (Yes)

4. Do you want to regenerate Oracle Forms menu files? (Yes)

5. Enter the list of products, or enter 'all' [all]: (fnd)

6. Do you want to generate specific form objects for each selected product? (Yes)

7. Enter libraries and menus to generate, or enter 'all' [all]: (APPCORE.pll, the main library)

8. Enter forms to generate, or enter 'all' [all]: FNDSCSGN.fmx

The utility finished with no errors in the log file.

What is the outcome of running the adadmin utility?

Options:

A.

All forms in the product group fnd now render with errors.

B.

All forms in the product group fnd now render without errors.

C.

All forms but one in the product group fnd now render with errors.

D.

All forms but one in the product group fnd now render without errors.

Question 27

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.)

Options:

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.

Question 28

When you run an autopatch session, the AutoPatch utility prompts you to mention batchsize to be used for the current session along with a suggested value. What is the significance of batchsize while applying the patch?

Options:

A.

batchsize determines the number of parallel workers to be used during the autopatch session.

B.

batchsize determines the number of scripts that would be run in parallel during the autopatch session.

C.

batchsize determines the number of objects that would be compiled in parallel during the autopatch session.

D.

batchsize determines the number of rows that would be committed when certain scripts are run during the autopatch session.

Question 29

There was an error while applying a patch. The AutoPatch error message indicates that the FND_INSTALL_PROCESSES table already exists. AutoPatch asks if you want to drop the table. Which two steps need to be performed before dropping the table? (Choose two.)

Options:

A.

Shut down the concurrent managers process.

B.

The users need to log out of Oracle Applications.

C.

Determine if there are errors in the Patch log files.

D.

Determine if other users are running the AD Merge program.

E.

Check whether a previous patch session did not run to completion.

F.

Determine if AutoPatch or any other AD Utility is running in another session.

G.

The password for the APPS user is invalid. Confirm the password of the APPS user.

Question 30

Which directory structure is created by default when you install the Oracle Applications R12 file system ?

Options:

A.

db/apps_st/10.2.0

B.

apps/tech_st/10.2.0

C.

apps/tech_st/10.1.2

D.

apps/apps_st/common

Question 31

Which piece of information is captured as part of the Patch Impact Analysis of a particular patch?

Options:

A.

prerequisite patches that can be merged and applied

B.

objects that would be rendered invalid after applying the patch

C.

objects that would be dropped from the database during patch application

D.

prerequisite patches required by the patch along with the readme of each patch

Question 32

Andy has just finished applying a patch on his Oracle Applications system configured on a Windows platform by using the adpatch utility. He wants to inspect the log file and ensure that the patch is completed without any errors. Where can he find the log file?

Options:

A.

%AD_TOP%\admin\log

B.

%APPL_TOP%\admin\log

C.

%AD_TOP%\admin\\log

D.

%APPL_TOP%\admin\\log

E.

%INST_TOP%\admin\\log

Question 33

The Applications Context file has been accidentally deleted and was also lost accidentally. How do you restore the Applications Context file?

Options:

A.

Execute $ perl /clone/bin/adclonectx.pl retrieve on the application tier.

B.

Execute $ perl /clone/bin/adclonectx.pl retrieve on the application tier.

C.

Execute $ perl /appsutil/clone/bin/adclonectx.pl retrieve on the database tier.

D.

Execute $ perl /appsutil/clone/bin/adclonectx.pl retrieve on the application tier.

Demo: 33 questions
Total 225 questions