Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-238

Free Oracle 1Z0-238 Exam Braindumps (page: 2)

Page 2 of 41
PDF with 225 Questions

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

  1. Hybrid objects contain materialized view objects, and store and process data.
  2. Code objects contain index, PL/SQL package, and Java-stored procedure objects.
  3. Data objects contain table, index, and sequence and index-organized table objects.
  4. Hybrid objects contain PL/SQL package and Java-stored procedure, and process data objects.
  5. Code objects contain trigger, PL/SQL package, Java-stored procedure, synonym, and view objects.

Answer(s): A,C,E



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?

  1. Oracle Enterprise Manager
  2. Oracle Applications Manager
  3. Oracle Discoverer reporting tool
  4. Oracle Business Intelligence products
  5. SQL*Plus program to access the FND tables
  6. Oracle Applications concurrent request (System Administrator) reports

Answer(s): B



Which Oracle Applications environment file compiles and links custom Oracle Forms user exits and concurrent programs with Oracle Applications R12?

  1. fndenv.env
  2. devenv.env
  3. adovars.env
  4. <CONTEXT_NAME>.env
  5. APPS_<CONTEXT_NAME>.env

Answer(s): B



One of the special AD Controller utilities, Show Worker Status, collects worker status information from the FND_INSTALL_PROCESSES temp table. It tracks multiple workers for five categories:

Worker, Code, Context, File Name, and Status. The seven statuses are:

1. Failed
2. Completed
3. Waiting
4. Fixed/Restart
5. Running
6. Assigned
7. Restarted

Choose the sequence that would place the process statuses in the proper flow order when an in-processing error is received.

  1. 5, 1, 4, 6, 7, 3, 2
  2. 1, 3, 4, 6, 7, 5, 2
  3. 3, 6, 5, 1, 4, 7, 2
  4. 7, 3, 6, 5, 4, 1, 2
  5. 6, 1, 4, 3, 5, 7, 2

Answer(s): C






Post your Comments and Discuss Oracle 1Z0-238 exam prep with other Community members:

1Z0-238 Exam Discussions & Posts