Oracle Oracle Certifications 1Z0-238 Questions & Answers

• Question 121:

  Which can be patched using the AutoPatch utility? (Choose all that apply.)

  A. Oracle Database

  B. Oracle Applications

  C. Oracle Application Server

  D. Oracle Development Tools

  Correct Answer: B

• Question 122:

  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?

  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.

  Correct Answer: D

• Question 123:

  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?

  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

  Correct Answer: D

• Question 124:

  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

  Correct Answer: ABE

• Question 125:

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

  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.

  Correct Answer: BCE

• Question 126:

  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

  Correct Answer: E

• Question 127:

  What kind of files can be found in the /admin directory?

  A. data merge files used to upgrade seed data

  B. driver files, which control AutoUpgrade processes

  C. product-specific files used by AutoUpgrade to upgrade that product

  D. object-description files used to create tables and other database objects

  Correct Answer: C

• Question 128:

  In Oracle Applications Release 12, what are the components used in Oracle Application Framework? (Choose three.)

  A. Web Listener

  B. Servlet Engine

  C. Metadata UI Definition

  D. Business Components for Java (BC4J)

  E. Application Object Library Java (AOL/J)

  Correct Answer: CDE

• Question 129:

  Identify four statements that correctly describe a schema. (Choose four.)

  A. A schema is a named collection of database objects.

  B. The database user and the schema never have the same name.

  C. A schema can allow another schema to use its objects by granting access.

  D. There is no one-to-one relationship between schemas and users in a database.

  E. An Oracle Application products database objects are divided between the product schema and the APPS schema.

  F. The concept of a database schema is directly tied to the concept of a database user, or a grant from the schema owner.

  Correct Answer: ACEF

• Question 130:

  Your Oracle Applications installation is configured on a Windows operating system. As the Applications DBA, you need to run the adadmin utility to carry out certain maintenance tasks on the system.dentify the steps you need to perform and their correct sequence to complete the task mentioned above.

  1.

  Log in to the application tier node as the owner of the database file system.

  2.

  Log in to the application tier node as the owner of the applications file system.

  3.

  Run %APPL_TOP%\APPS.cmd.

  4.

  Run %APPL_TOP%\envshell.cmd.

  5.

  Run the adadmin utility in the window in step 3.

  6.

  Run the adadmin utility from the window created in step 4.

  A. 1,3,5

  B. 2,3,5

  C. 2,4,6

  D. 1,4,6

  Correct Answer: C