1Z0-238 Real Exam Questions and Verified Answers

Question 1 Single choice

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.

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

Show answer and explanation

Correct answer: D

Question 2 Single choice

The Applications Context file has been accidentally deleted and <INST_TOP> was also lost accidentally.

How do you restore the Applications Context file?

A
Execute $ perl <INST_TOP>/clone/bin/adclonectx.pl retrieve on the application tier.
B
Execute $ perl <COMMON_TOP>/clone/bin/adclonectx.pl retrieve on the application tier.
C
Execute $ perl <ORACLE_HOME>/appsutil/clone/bin/adclonectx.pl retrieve on the database tier.
D
Execute $ perl <ORACLE_HOME>/appsutil/clone/bin/adclonectx.pl retrieve on the application tier.

Show answer and explanation

Correct answer: B

Question 3 Multiple choice

There was an error while applying a patch. The AutoPatch error message ndicates 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.)

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.

Show answer and explanation

Correct answers: E, F

Question 4 Single choice

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

A
perl adautocfg.pl
B
perl adaddnode.pl
C
perl adcfgclone.pl addnode
D
perl adcfgclone.pl appsTier

Show answer and explanation

Correct answer: B

Question 5 Single choice

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?

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.

Show answer and explanation

Correct answer: D

Question 6 Single choice

As an Oracle Applications DBA, you are asked to bring up the Oracle Applications R12 environment, which is restored from backup. You try to start the services and find that the startup scripts adapcctl.sh, adalnctl.sh, and adcmctl.sh are missing.
Identity which utility you will use to re-create these scripts?

A
adrelink.sh
B
adgensgn.sh
C
adautocfg.sh
D
adcfginfo.sh
E
adcrscrpts.sh

Show answer and explanation

Correct answer: C

Question 7 Single choice

In which scenario does the Applications DBA need to run the Rapid Clone utility?

A
There are two systems (Test and Production) for XYZ company. There are invalid objects being
encountered in the Production system. The errors are not happening on the Test system.The Applications DBA plans to run the Oracle utility on the Production system to fix the invalid objects.
B
ABC company has three systems: Development, Test, and Production. Testing of the Oracle
Applications patches are being done on the Test system and being promoted to Development for further testing. After the patches are tested in the Test and Development systems without any issues, they would be promoted to the Production system. The Applications DBA plans to run the Oracle utility for the promotion of the patch.
C
There was a hardware disk failure on the Development server. The Development system was being
used to test the application patches. The POIUY company has only two systems: Development and Production. As soon as the hardware disk failure is resolved on the Development server, there is a need to rebuild that Development system. The Applications DBA plans to run the Oracle utility to rebuild the Development system.
D
There is a need for another Oracle Applications system to test the patches to be applied on the
Production system. Currently, QWERT company has five Oracle Applications systems including
Production. The Production and Test systems are on Release 12.2.10 and the remaining systems are on Release 12.2.9. The Applications DBA plans to run the Oracle utility on the Test system to test the patch.

Show answer and explanation

Correct answer: C

Question 8 Multiple choice

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

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.

Show answer and explanation

Correct answers: B, C, E, F, G

Question 9 Single choice

Which statement regarding the Oracle Applications R12 technology stack is correct?

A
The frmweb executable is invoked from the 10.1.2 ORACLE_HOME.
B
JServ is one of the components of the Oracle Applications R12 technology stack.
C
The Applications modules (packaged in the formsapp.ear file) are deployed in the OC4J Forms instance running in the 10.1.2 ORACLE_HOME.
D
The Application Server 10.1.3 ORACLE_HOME replaces the 8.0.6 ORACLE_HOME provided by Oracle9i Application Server 1.0.2.2.2 in Release 11i.
E
The Application Server 10.1.2 ORACLE_HOME replaces the 8.1.7-based ORACLE_HOME provided by Oracle9i Application Server 1.0.2.2.2 in Release 11i.

Show answer and explanation

Correct answer: A

Question 10 Single choice

The Applications DBA needs to clone the Production system. Examine the list of steps that the Applications DBA is considering.

A
Verify the source and target nodes' software versions.
B
Apply the Rapid Clone patch.
C
Run AutoConfig on the application tier.
D
Set up Rapid Clone on the database tier.
E
Prepare the source system.
F
Copy the source system to the target system.
G
Configure the target system.
H
Perform the finishing tasks.
I
Test the target system.
J
Back up the target system.
Which step is NOT a part of the cloning process?
A. step A
B. step B
C. step C
D. step D
E. step F
F. step G
G. step J

Show answer and explanation

Correct answer: G