oracle 1Z0-238 Exam Questions

Questions for the 1Z0-238 were updated on : Jul 20 ,2024

Page 1 out of 11. Viewing questions 1-15 out of 156

Question 1 Topic 1, Section A

Which three are the correct definitions of the objects in the Oracle Applications database?
(Choose three.)

  • A. Hybrid objects contain materialized view objects, and store and process data.
  • B. Code objects contain index, PL/SQL package, and Java-stored procedure objects.
  • C. Data objects contain table, index, and sequence and index-organized table objects.
  • D. Hybrid objects contain PL/SQL package and Java-stored procedure, and process data objects.
  • E. Code objects contain trigger, PL/SQL package, Java-stored procedure, synonym, and view objects.
Answer:

A C E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 2 Topic 1, Section A

The AD Administration task utility Compile APPS Schema is similar to the "Validate APPS Schema" task, except that instead
of just producing a list of invalid objects, it compiles invalid objects using multiple workers in an attempt to move them back
to the valid object state. This task is most often run when custom packages are moved into the APPS schema, and during
the upgrade process. The "Compile APPS Schema" task can be toggled to compile all objects or just the invalid objects.
Choose three correct benefits of using this task. (Choose three.)

  • A. increases run-time performance in the applications
  • B. corrects all corrupt schema package bodies and headers
  • C. finds truly invalid objects before users get a run-time error
  • D. allows new custom or patched packages to be immediately validated
Answer:

A C D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3 Topic 1, Section A

Which three statements about the Applications Context file are true? (Choose three.)

  • A. It is a system configuration file.
  • B. It must be edited manually using a text editor.
  • C. It is stored in an Oracle Applications Manager (OAM) schema.
  • D. It can be downloaded from Oracle Applications Manager (OAM).
  • E. It is created by Rapid Install using AutoConfig during installation and upgrade.
  • F. It stores all information required to configure an Oracle Applications instance.
Answer:

D E F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 4 Topic 1, Section A

Choose two statements that are correct for AutoPatch running in Test Mode. (Choose two.)

  • A. It Relinks any executables.
  • B. It does not record patch history.
  • C. It reads and validates the patch driver's file.
  • D. It generates any forms, reports, PL/SQL libraries, or menu files.
  • E. It copies any files from the patch directory to the installation area.
Answer:

B C

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 5 Topic 1, Section A

What is the version of the Java Oracle home in Oracle Applications Release 12?

  • A. 10.2
  • B. 8.1.7
  • C. 8.0.6
  • D. 10.1.3
  • E. 10.1.2
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 6 Topic 1, Section A

What are the two possible sequences of worker status while a job is being completed by a worker? (Choose two.)

  • A. Waiting => Assigned => Running => Completed
  • B. Assigned => Waiting => Running => Completed
  • C. Waiting => Assigned => Running => Failed => Fixed, Restart => Restarted => Completed
  • D. Assigned => Waiting => Running => Failed => Fixed, Restart => Restarted => Completed
  • E. Waiting => Assigned => Running => Failed => Fixed, Restart => Restarted => Running => Completed
Answer:

A C

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 7 Topic 1, Section A

What is contained in the FND_APPLICATION_TL table found in the Oracle Applications R12 database?

  • A. table list of all Oracle Application Object Library (AOL) objects
  • B. transaction-load statistics of Application Object Library usage
  • C. trigger logic for all Application Object Library (AOL)-related tables
  • D. language-translated information about all applications registered with Application Object Library
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8 Topic 1, Section A

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

A B E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 9 Topic 1, Section A

You decide to bring up the database manually while cloning Oracle E-Business Suite R12. Identify the options of
adcfgclone.pl that you would choose to successfully complete the clone on the database tier.

  • A. adcfgclone.pl dbTechStack only
  • B. adcfgclone.pl databaseTechStack only
  • C. adcfgclone.pl database and adcfgclone.pl dbconfig .xml
  • D. adcfgclone.pl dbTechStack and adcfgclone.pl dbconfig .xml
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10 Topic 1, Section A

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

B

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 11 Topic 1, Section A

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?

  • 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/.
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12 Topic 1, Section A

What is the default value of ?

  • D. _
  • E. APPS_
Answer:

D

User Votes:
D
50%
E
50%
Discussions
vote your answer:
D
E
0 / 1000

Question 13 Topic 1, Section A

Which patch establishes the compatibility of the current version of Oracle Applications with the newer version of the
database or technology stack component?

  • A. diagnostic
  • B. translation
  • C. new feature
  • D. intraoperability
  • E. interoperability
Answer:

E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 14 Topic 1, Section A

Before you apply a patch, you read the readme.txt file.
One of the areas of Oracle Applications to which the patch will be applied is JAVA_TOP. The readme file mentions that you
may need to generate product JAR files in the AD Administration utilities after the patch is applied.
When generating product JAR files, the AD Administration utility will prompt you with the question: Do you want to force the
generation of all JAR files?
What are the three occasions when you need to force the generation of all JAR files? (Choose three.)

  • A. after changing your digital signature
  • B. after updating to a new Java version
  • C. if you find you have missing or out-of-date JAR files
  • D. if you are upgrading the Oracle Developer technology stack
Answer:

A B D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15 Topic 1, Section A

Which command can be used only with a single-node installation?

  • A. rapidwiz -restart
  • B. rapidwiz -techstack
  • C. rapidwiz -servername
  • D. rapidwiz -silent -config
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2