1Z0-238 R12 Oracle Install,Patch & Maintain Oracle APP Test Set 1

Identify the correct statement regarding the AutoPatch utility in R12.


Options are :

  • AutoPatch prompts the user for the SYSTEM and APPS passwords.
  • AutoPatch does not verify whether the concurrent programs are installed in the current APPL_TOP.
  • AutoPatch does not verify the APPL_TOP name.
  • AutoPatch does not verify if the system is in maintenance mode or not.

Answer : AutoPatch prompts the user for the SYSTEM and APPS passwords.

1Z0-969 Oracle Payroll Cloud 2017 Implementation Essentials Set 3

Identify the elements of a patch.


Options are :

  • patch metadata files
  • readme files
  • unified driver
  • All of the above

Answer : All of the above

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.


Options are :

  • adcfgclone.pl dbTechStack and adcfgclone.pl dbconfig .xml
  • adcfgclone.pl dbTechStack only
  • adcfgclone.pl database and adcfgclone.pl dbconfig .xml
  • adcfgclone.pl databaseTechStack only

Answer : adcfgclone.pl dbTechStack and adcfgclone.pl dbconfig .xml

You have successfully completed preclone on the application tier node. Which application tier file system needs to be copied from the source applications node to the target node for completing postclone successfully on the target node?

1 . <APPL_TOP>

2 . <INST_TOP>

3. <AS tools ORACLE_HOME>

4. <AS web IAS_ORACLE_HOME>

5. oraInventory


Options are :

  • 2, 3, 4
  • 1, 2 ,4
  • 1, 3, 4
  • 1, 3, 5

Answer : 1, 3, 4

Oracle 1Z0-207 Billing & Revenue Mgmt Pricing Practice Exam Set 2

You want to run preclone on database tier. You logged in to the database node and realized that the appsutil directory is missing. Identify the command you use to re-create appsutil.zip, so that the appsutil directory can be re-created.   


Options are :

  • perl /bin/admkappsutil.pl
  • perl /appl/bin/admkappsutil.pl
  • perl /bin/admkdbutil.pl
  • perl /appl/bin/admkappsutil.pl

Answer : perl /bin/admkappsutil.pl

What is true about editing and saving the .xml file by using the Oracle Applications Manager (OAM) Web page?


Options are :

  • When you make changes to the Context file on the OAM Web page and save the file, the changes are stored in the OAM database and the Context file is updated.
  • The Context file is edited and saved only to the file system. AutoConfig picks up the changes whenever it runs next after the update.
  • AutoConfig automatically starts and picks up the changes and propagates them when the Context file is saved on the OAM Web page.
  • After changes made to the Context file are saved on the OAM Web page, you must log out and log in again to OAM to apply and propagate the changes.

Answer : When you make changes to the Context file on the OAM Web page and save the file, the changes are stored in the OAM database and the Context file is updated.

Identify valid AD utilities for Oracle E-Business Suite R12.


Options are :

  • adjkey
  • adcontrol
  • adcfgclon
  • admail

Answer : adjkey

Oracle 12c SQL Certified Associate 1Z0-071 Real Exam 2019 Set 4

What are the  possible sequences og 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?


Options are :

  • No immediate action is required unless the job fails again.
  • Review the worker log file and resolve the error.
  • Restart the failed job and verify the worker status.
  • Resolve the error and restart the failed job.

Answer : No immediate action is required unless the job fails again.

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


Options are :

  • perl adcfgclone.pl addnode
  • perl adautocfg.pl
  • perl adaddnode.pl
  • perl adcfgclone.pl appsTier

Answer : perl adaddnode.pl

1Z0-330 Oracle Fusion Workforce Compensation Cloud Test Set 4

Identify the environmental variable that defines to which ORACLE schema the System Administration responsibility connects.


Options are :

  • GWYID
  • FNDNAM
  • FNDCPASS
  • DBNAM

Answer : FNDNAM

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. 


Options are :

  • adpatch option=nocopyportion, nogenerateportion
  • adpatch options=applydatabaseportion
  • adpatch options=nocopyportion,nogenerateportion
  • adpatch OPTIONS=NOCOPYPORTION,NOGENERATEPORTION

Answer : adpatch options=nocopyportion,nogenerateportion

In Oracle Applications R12, to which directory does the $OA_HTML environment variable point?


Options are :

  • $INST_TOP/html
  • $COMMON_TOP/webapps/oacore/html
  • $INST_TOP/webapps/oacore/html
  • $COMMON_TOP/html

Answer : $COMMON_TOP/webapps/oacore/html

1Z0-409 Oracle Linux Fundamentals Practice Exam Set 3

In Oracle Applications Release 12, you want to set up your X Display. After changing the value of the DISPLAY variable in the Context files of the database and application tiers, which adautocfg.sh files do you execute for these changes to take effect?


Options are :

  • /admin/scripts/adautocfg.sh
  • /admin/scripts/adautocfg.sh
  • /admin/scripts//adautocfg.sh
  • /admin/scripts/adautocfg.sh

Answer : /admin/scripts/adautocfg.sh

Oracle Applications produces temporary PL/SQL output files used in concurrent processing. These files are written to a location on the database server node specified by the APPLPTMP environment setting. What would be the value of APPLPTMP in the environment setting?


Options are :

  • the last value defined for the UTL_FILE_DIR parameter in the init.ora file
  • the $COMMON_TOP/temp directory where the common files are located
  • the temporary directory used by the operating system
  • the first value defined for the UTL_FILE_DIR parameter in the init.ora file

Answer : the first value defined for the UTL_FILE_DIR parameter in the init.ora file

Which are the correct definitions of the objects in the Oracle Applications database?


Options are :

  • Data objects contain table, index, and sequence and index-organized table objects.
  • Hybrid objects contain materialized view objects, and store and process data.
  • All of the above
  • Code objects contain trigger, PL/SQL package, Java-stored procedure, synonym, and view objects.

Answer : All of the above

1Z0-518 Oracle EBS R12 Receivables Essentials Practice Exam Set 2

Identify the environment variable that points to the $COMMON_TOP/java directory in Oracle Applications R12.


Options are :

  • JAVA_BASE
  • JAVA_TOP
  • JRE_TOP
  • JDK_TOP

Answer : JAVA_BASE

Which statements about the Applications Context file are true?


Options are :

  • It is created by Rapid Install using Auto Config during installation and upgrade.
  • It can be downloaded from Oracle Applications Manager (OAM).
  • All of the above
  • It stores all information required to configure an Oracle Applications instance.

Answer : All of the above

Choose statements that are correct for Auto Patch running in Test Mode.


Options are :

  • It copies any files from the patch directory to the installation area.
  • It does not record patch history.
  • It generates any forms, reports, PL/SQL libraries, or menu files.
  • It relinks any executable.

Answer : It does not record patch history.

1Z0-521 Oracle E-Business Suite R12 Oracle Order Managment Set 1

In Oracle Applications R12, the Applications modules (packaged in the formsapp.ear file) are deployed to the OC4JForms instance. Identify the ORACLE_HOME used by this OC4J instance.


Options are :

  • 10.1.3
  • 8.1.7
  • 8.0.6
  • 10.1.2

Answer : 10.1.3

In Oracle Applications Release 12, what are the components used in Oracle Application Framework?


Options are :

  • All of the above
  • Metadata UI Definition
  • Business Components for Java (BC4J)
  • Application Object Library Java (AOL/J)

Answer : All of the above

Where is the AutoPatch executable located in Oracle Applications R12?


Options are :

  • $AD_TOP
  • $AU_TOP/bin
  • $AD_TOP/bin
  • $APPL_TOP/admin

Answer : $AD_TOP/bin

1Z0-517 Oracle EBS R12.1 Payables Essentials Practice Exam Set 5

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


Options are :

  • diagnostic
  • interoperability
  • new feature
  • translation

Answer : interoperability

The Oracle Applications R12 database administrator (DBA) runs the "Recreate grants and synonyms for APPS schema" task by using the adadmin utility when grants or synonyms are missing from the database. Which causes are responsible for this?


Options are :

  • installing or maintaining Oracle Applications R12 E-Business Suite underlying database components or options such as Replication
  • incomplete database migrations (exports or imports)
  • patch and administrative sessions that failed to run successfully to completion
  • All of the above

Answer : All of the above

Your patch was applied and finished without encountering any error during the process. Which is NOT a correct part of the postpatch process?


Options are :

  • updating the MLS
  • restarting all server processes
  • using the Change Maintenance Mode option of AD Administration to enable maintenance mode
  • removing any obsolete files

Answer : using the Change Maintenance Mode option of AD Administration to enable maintenance mode

1Z0-516 Oracle EBS R12 General Ledger Essentials Exam Set 2

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?


Options are :

  • Copy the source 10.1.2 and RDBMS Oracle home directory to the target system.
  • Perform a normal shutdown of the source system database.
  • Copy the database files from the source to the target system.
  • Log on to the source system application tier nodes as the oracle user.

Answer : Copy the source 10.1.2 and RDBMS Oracle home directory to the target system.

Identify scenarios in the Oracle Applications R12 E-Business Suite environment in which you would need to run AutoConfig.


Options are :

  • after restoring a previous configuration
  • after registering products and languages
  • All of the above
  • after using AD Splicer to add a product to the existing stack

Answer : All of the above

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


Options are :

  • 10.1.3
  • 10.2
  • 8.1.7
  • 8.0.6

Answer : 10.1.3

1Z0-497 Oracle Database 12c Essentials Certification Exam Set 5

What are the benefits of the Oracle Applications Tablespace Model?


Options are :

  • uses locally managed tablespaces, and enables more control over unused space
  • simplifies maintenance and recovery by using fewer tablespaces
  • makes best use of the restricted number of raw devices available in Real Application Clusters (RAC) and other environments
  • All of the above

Answer : All of the above

Which can be patched using the AutoPatch utility?


Options are :

  • Oracle Database
  • Oracle Applications
  • Oracle Development Tools
  • Oracle Application Server

Answer : Oracle Applications

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions