Free Oracle 1Z1-238 Exam Dumps Questions & Answers

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 data file was resized.
• B.  A database was restarted
• C.  A custom schema was dropped.
• D.  A tablespace was dropped.
• E.  A data file was added to the database.

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.  adcrscrpts.sh
• B.  adrelink.sh
• C.  adautocfg.sh
• D.  adgensgn.sh
• E.  adcfginfo.sh

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

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

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.  %INST_TOP%\admin\<SID>\log
• B.  %AD_TOP%\admin\<SID>\log
• C.  %APPL_TOP%\admin\log
• D.  %AD_TOP%\admin\log
• E.  %APPL_TOP%\admin\<SID>\log

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

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