New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Oracle 1z0-238 Dumps Questions Answers

Page: 1 / 8
Total 225 questions

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

Question 1

Identify five required post-installation tasks for Oracle Applications R12 E-Business Suite. (Choose five.)

Options:

A.

Set up a stage directory.

B.

Configure the client software.

C.

Review security practices.

D.

Install the latest Java Development Kit.

E.

Update the log and out PL/SQL directories.

F.

Configure database initialization parameters.

G.

Implement product- and country-specific functionalities.

Buy Now
Question 2

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 3

Identify the environment variable that points to the $COMMON_TOP/java directory in Oracle Applications R12.

Options:

A.

JDK_TOP

B.

JRE_TOP

C.

JAVA_TOP

D.

JAVA_BASE

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 Oracle Applications Release 12, what are the components used in Oracle Application Framework? (Choose three.)

Options:

A.

Web Listener

B.

Servlet Engine

C.

Metadata UI Definition

D.

Business Components for Java (BC4J)

E.

Application Object Library Java (AOL/J)

Question 6

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?

Options:

A.

Timing report

B.

Bug Fixes report

C.

Files Copied report

D.

Action Details report

E.

Patch Details report

F.

Action Summary report

Question 7

Which statement is true regarding AutoPatch in the Oracle Applications Release 12 environment?

Options:

A.

AutoPatch is platform-independent.

B.

There is a limit to the number of times AutoPatch can be restarted.

C.

If language translation patches need to be applied in addition to the patch you are applying, AutoPatch notifies you.

D.

If all the prerequisite patches have not been applied, AutoPatch lists the missing prerequisites and continues with applying the current patch.

E.

AutoPatch replaces the files in the product directory with the files in the patch directory in case the latter have the same version as the

former.

Question 8

What does the /resource directory contain in Oracle Applications?

Options:

A.

product-specific GIF files

B.

.pll files used by Oracle Reports

C.

.pll and .plx files used by Oracle Forms

D.

SQL scripts used by Oracle Applications products at run time

Question 9

All services of Oracle Applications R12 (application tier and database tier) are down. On which tier would the preclone finish successfully?

Options:

A.

none of the tiers

B.

database tier only

C.

application tier only

D.

both application and database tiers

Question 10

Which database user is the owner of FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables?

Options:

A.

ad

B.

fnd

C.

apps

D.

applsys

E.

applsyspub

Question 11

You run adcfgclone.pl on the target node. It completes with errors. Where can you locate the log files for the database and application tiers?

Options:

A.

On the database tier:

$INST_TOP/log//ApplyDBTier_.log

On the application tier:

$LOG_HOME/log/ApplyAppsTier_.log

B.

On the database tier:

RDBMS $ORACLE_HOME/appsutil/log/ApplyDBTier_.log

On the application tier:

$INST_TOP/log/ApplyAppsTier_.log

C.

On the database tier:

$INST_TOP/appsutil/log//ApplyDBTier_.log

On the application tier:

$LOG_HOME/admin/log/ApplyAppsTier_.log

D.

On the database tier:

RDBMS $ORACLE_HOME/appsutil/log//ApplyDBTier_.log

On the application tier:

$INST_TOP/admin/log/ApplyAppsTier_.log

Question 12

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

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

Options:

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

Question 15

Your system crashes while running an Application DBA (AD) utility. Which are the corrective actions you perform to synchronize the utility status and system status before restarting the utility? (Choose all that apply.)

Options:

A.

Start the AD patch.

B.

Start AD Controller.

C.

Tell the worker to quit.

D.

Tell the worker to restart a failed job.

E.

Tell the manager that a worker failed its job.

Question 16

Which command needs to be run to add a new node to an existing system?

Options:

A.

perl adautocfg.pl

B.

perl adaddnode.pl

C.

perl adcfgclone.pl addnode

D.

perl adcfgclone.pl appsTier

Question 17

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 18

Which two statements are correct about Rapid Clone? (Choose two.)

Options:

A.

Rapid Clone does not take care of oraInventory.

B.

Rapid Clone updates only site-level profile options.

C.

Rapid Clone itself does not start the application services automatically on the node.

D.

Rapid Clone automatically creates a control file and brings up the database on the database tier.

E.

Rapid Clone does not configure the source application printer configuration in the target system.

Question 19

As a database administrator (DBA), you have been trying to apply a maintenance patch, but it has failed to run successfully to completion. You check the AD Administration log file for an error. The log file reveals several entries that are generic errors about the inability of patch codes to have access to product packages from the GL product modules. You remember that one of the occasions when you should run the Recreate Grants and Synonyms AD Administration utility is if the patch and the administrative sessions fail to run successfully to completion. You have found one occasion to use this utility in the case above. Now choose three other occasions when you would run this process again. (Choose three.)

Options:

A.

after custom development

B.

when applying a patch to the operating system

C.

after applying a patch to the Applications technology stack

D.

in case of incomplete database migrations (exports or imports)

E.

when installing or maintaining underlying database components or options such as Replication

Question 20

Which two tasks can you perform with the Application DBA (AD) Controller utility? (Choose two.)

Options:

A.

Restart a failed patch.

B.

Review the worker status.

C.

Assign a job to the worker.

D.

Restart a completed worker.

E.

Restart a terminated worker.

Question 21

What is the default value of ?

Options:

A.

APPS_

B.

APPS_

C.

_

D.

_

E.

APPS_

Question 22

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?

Options:

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

Question 23

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 24

Which option is required when using the Applied Patches Advanced Search feature in OAM?

Options:

A.

Patch ID

B.

Language

C.

Server Type

D.

Applications System Name

E.

Product that owns the patch

F.

Applied From Date and To Date

G.

APPL_TOP where the patches were applied

Question 25

Which command needs to be run to add a new node to an existing system?

Options:

A.

perl adautocfg.pl

B.

perl adaddnode.pl

C.

perl adcfgclone.pl addnode

D.

perl adcfgclone.pl appsTier

Question 26

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

Options:

A.

ad_bugs

B.

fnd_bugs

C.

ad_patches

D.

ad_patches_applied

E.

ad_applied_patches

Question 27

Users are not able to view the output and the log file of the concurrent request after completion. There were no changes in the configuration of Oracle Applications. There were no patches applied. It was determined that not all application tier processes ran successfully. There was status 1 in one of the scripts. Which action should you take?

Options:

A.

Restart the Web server.

B.

Restart the Forms server.

C.

Restart the Report server.

D.

Restart the Fulfillment server.

E.

Restart the TCF Socket server.

F.

Restart the concurrent managers.

G.

Restart the Applications RPC listener.

Question 28

Identify the formula based on which AD utilities provide the default number of workers.

Options:

A.

2 * (the number of CPUs on the database server)

B.

2 + (the number of CPUs on the database server)

C.

2 * ( the parallel_max_servers initSID.ora parameter in the database)

D.

2 + (the parallel_max_servers initSID.ora parameter in the database)

Question 29

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 30

You have to patch an Oracle Applications environment configured on a UNIX node. To start an AutoPatch session, you log in to the application-tier server node as the applications file system owner. You enter adpatch at the command prompt and get the following error:

"-bash: adpatch: command not found"

On closer observation, you find that the applications environment is not set. Which file would you run to set the Oracle Applications environment?

Options:

A.

$APPL_TOP/APPS.env

B.

$APPL_TOP/APPS_.env

C.

$APPL_TOP/admin/APPS.env

D.

$APPL_TOP/admin/APPS_.env

Question 31

As part of the cloning process, the Applications DBA needs to copy the database tier file system to the target system. Which step is NOT a part of this cloning process?

Options:

A.

Perform a normal shutdown of the source system database.

B.

Copy the database files from the source to the target system.

C.

Log on to the source system application tier nodes as the oracle user.

D.

Copy the source 10.1.2 and RDBMS Oracle home directory to the target system.

Question 32

R12 Rapid Install sets the APPL_TOP directory value to _____.

Options:

A.

/APPL

B.

/APPL

C.

/APPL

D.

/apps/apps_st/appl

E.

/APPL

Question 33

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

Options:

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

Page: 1 / 8
Total 225 questions