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

Which AutoPatch option is used to run a noninteractive autopatch session?


Options are :

  • defaultsfile
  • default_file
  • defaultfile
  • defaults_file

Answer : defaultsfile

Applying a patch in Pre-Install mode performs which actions only? 


Options are :

  • generates JAR files
  • reads product drivers file
  • relinks all the executables
  • performs file copy actions

Answer : performs file copy actions

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

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


Options are :

  • object-description files used to create tables and other database objects
  • driver files, which control AutoUpgrade processes
  • product-specific files used by AutoUpgrade to upgrade that product
  • data merge files used to upgrade seed data

Answer : product-specific files used by AutoUpgrade to upgrade that product

AD Administration contains a utility named Maintain Snapshot Information. Which statements correctly describe the functionality of this utility?


Options are :

  • You can export an existing snapshot to a file for storage or to another system.
  • You can create a copy of an existing snapshot.
  • All of the above
  • You can create a list of the current view and named snapshots stored in your system.

Answer : All of the above

After the successful installation of Oracle Applications Release 12, environment files are created. Which environment file is used to identify and describe third-party and custom applications linked with Oracle Applications?


Options are :

  • the devenv.env file
  • the fndenv.env file
  • the adovars.env file
  • the context file

Answer : the devenv.env file

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

Which option is required when using the Applied Patches Advanced Search feature in OAM?


Options are :

  • Server Type
  • Patch ID
  • Applications System Name
  • Language

Answer : Applications System Name

Identify  facts that you should consider when planning a shared APPL_TOP Oracle Applications installation.


Options are :

  • All of the above
  • Administrative tasks, such as patch application, need to be carried out only once.
  • It provides for utilization of distributed AD, improving patch application efficiency.
  • It can maximize system availability and meet additional usage requirements.

Answer : All of the above

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?


Options are :

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

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

1Z0-208 Oracle Comm Billing & Revenue Mgmt Server Developer Set 1

All services of Oracle Applications R12 (application tier and database tier) are down. On which tier would the preclone finish successfully?  


Options are :

  • database tier only
  • both application and database tiers
  • none of the tiers
  • application tier only

Answer : application tier only

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.


Options are :

  • A custom schema was dropped.
  • A data file was added to the database.
  • All of the above
  • A tablespace was dropped.

Answer : All of the above

The Application Utilities (AU_TOP) directory contains _____.


Options are :

  • files and scripts used by AutoUpgrade during upgrade
  • a consolidated set of all product files
  • consolidated logs and output directories used by concurrent processing
  • utilities such as AutoUpgrade and AutoPatch

Answer : a consolidated set of all product files

1Z0-520 Oracle EBS R12.1 Purchasing Essentials Practice Test Set 8

When you choose Search Patches from Oracle Applications Manager Site Map, it defaults to the Applied Patches Simple Search page. What can you do from this Applied Patches home page?


Options are :

  • Click the Calendar button to view the patches applied on a specific date.
  • Go to other OAM functionality by selecting it from the option buttons.
  • Click the Family Pack button to view all applied family pack patches.
  • Click the Advanced Search button to access the Applied Patches Advanced Search page.

Answer : Click the Advanced Search button to access the Applied Patches Advanced Search page.

You have done a single-node installation of Oracle Applications R12 on node 1. Because of some resource issues, you move only DB_ORACLE_HOME(10.2.0.2) and the database (.dbf files) to a new server (node 2). Which statement is correct about uXXXXXX.drv being applied to node 1 and node 2?


Options are :

  • uXXXXXX.drv only on node 2
  • uXXXXXX.drv on node 2, and then on node 1
  • uXXXXXX.drv only on node 1
  • uXXXXXX.drv on node 1, and then on node 2

Answer : uXXXXXX.drv only on node 1

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=nocopyportion,nogenerateportion
  • adpatch OPTIONS=NOCOPYPORTION,NOGENERATEPORTION
  • adpatch options=applydatabaseportion

Answer : adpatch options=nocopyportion,nogenerateportion

1Z0-520 Oracle EBS R12.1 Purchasing Essentials Practice Test Set 8

Identify the formula based on which AD utilities provide the default number of workers.


Options are :

  • 2 + (the number of CPUs on the database server)
  • 2 * ( the parallel_max_servers initSID.ora parameter in the database)
  • 2 + (the parallel_max_servers initSID.ora parameter in the database)
  • 2 * (the number of CPUs on the database server)

Answer : 2 * (the number of CPUs on the database server)

Identify the elements of a patch.


Options are :

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

Answer : All of the above

Your Oracle Applications system is reporting some problem and the solution is to apply a patch. Before applying the patch, you want to check the effects this new patch would have on your system. Which command would help you achieve this?


Options are :

  • adpatch preinstall=y
  • adpatch test=y
  • adpatch
  • adpatch apply=n

Answer : adpatch apply=n

1Z0-520 Oracle EBS R12.1 Purchasing Essentials Practice Test Set 7

Which piece of information is captured as part of the Patch Impact Analysis of a particular patch? 


Options are :

  • objects that would be rendered invalid after applying the patch
  • prerequisite patches required by the patch along with the readme of each patch
  • objects that would be dropped from the database during patch application
  • prerequisite patches that can be merged and applied

Answer : prerequisite patches required by the patch along with the readme of each patch

What are the different AutoConfig scripts?


Options are :

  • All of the above
  • adautocfg.sh/cmd
  • adconfig.pl
  • adconfig.sh/cmd

Answer : All of the above

The Application Utilities (AU_TOP) directory contains _____.


Options are :

  • utilities such as AutoUpgrade and AutoPatch
  • files and scripts used by AutoUpgrade during upgrade
  • a consolidated set of all product files
  • consolidated logs and output directories used by concurrent processing

Answer : a consolidated set of all product files

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

What is true about the worker process in the Oracle Applications R12 environment? 


Options are :

  • As long as the total run time is less than 10 minutes, the manager defers the job to retry at the end of the current phase, even if that job failed the previous three times.
  • When a worker runs a job for the second time, if the job fails and the total run time is 15 minutes, then the status of the job stays at failed and the worker starts the next job.
  • When a worker runs a job for the first time, if the job fails, the manager automatically defers the job to retry at a later time.
  • When a worker runs a job for the third time, if the job fails, the status of the job stays at failed and the worker starts the next job.

Answer : When a worker runs a job for the first time, if the job fails, the manager automatically defers the job to retry at a later time.

The connection between the client and Oracle Applications R12 E-Business Suite forms is provided through _____.


Options are :

  • Net8
  • Java Database Connectivity (JDBC)
  • An applet
  • SQL*Net

Answer : An applet

A company has implemented Oracle Applications Release 12. It wants to configure a system that sends emails to key database administrators (DBAs) when a tablespace in the Oracle Applications database does not have adequate free space. Identify which component in the Oracle Applications technology layer performs this task.


Options are :

  • Oracle Alert
  • Oracle Workflow
  • Oracle Applications Framework
  • Oracle E-mail Notification

Answer : Oracle Alert

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

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


Options are :

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

Answer : perl adaddnode.pl

Which can be patched using the AutoPatch utility?


Options are :

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

Answer : Oracle Applications

You have to patch an Oracle Applications environment configured on a UNIX node. To start an AutoPatch session, you log in to the application-tier server node as the applications file system owner. You enter adpatch at the command prompt and get the following error: "-bash: adpatch: command not found" On closer observation, you find that the applications environment is not set. Which file would you run to set the Oracle Applications environment?


Options are :

  • $APPL_TOP/admin/APPS.env
  • $APPL_TOP/APPS.env
  • $APPL_TOP/APPS_.env
  • $APPL_TOP/admin/APPS_.env

Answer : $APPL_TOP/APPS.env

1Z0-409 Oracle Linux Fundamentals Practice Exam Set 1

You downloaded an HRMS patch from Oracle MetaLink, and you run AutoPatch to apply it to the Oracle Applications R12 test setup in your company. If AutoPatch shows an error in one of the workers' jobs, how do you determine the source of the error?


Options are :

  • Review adworkxxx.log in $APPL_TOP/admin//log.
  • Check the AutoPatch log file for the source of the error.
  • Search the Oracle MetaLink Web site for the worker control number.
  • Use the AD Controller utility, and choose the Review worker status.

Answer : Review adworkxxx.log in $APPL_TOP/admin//log.

You suddenly start receiving errors indicating that there are numerous Java files in the database that are corrupted and cannot be run. You determined that you must reload the Java Virtual Machine (JVM) to fix the errors. In addition to reloading the JVM, what Oracle database utilities, if any, do you need to run and why?


Options are :

  • Reload JAR files to the database because after reloading the JVM, the Java class files would be missing.
  • Compile the APCompile the APPS schema because after the JVM has been reloaded, APPS permissions need to be reestablished.PS schema because after the JVM has been reloaded, APPS permissions need to be reestablished.
  • None of the Oracle database utilities need to be run because by reloading the JVM, all corrected Java files are corrected with the new files loaded during this process.
  • Compile the Menu information to restore Java menu files to the application forms.

Answer : Reload JAR files to the database because after reloading the JVM, the Java class files would be missing.

Which statement regarding the Oracle Applications R12 technology stack is correct?


Options are :

  • JServ is one of the components of the Oracle Applications R12 technology stack.
  • . The frmweb executable is invoked from the 10.1.2 ORACLE_HOME.
  • The Applications modules (packaged in the formsapp.ear file) are deployed in the OC4J Forms instance running in the 10.1.2 ORACLE_HOME.
  • The Application Server 10.1.3 ORACLE_HOME replaces the 8.0.6 ORACLE_HOME provided by Oracle9i Application Server 1.0.2.2.2 in Release 11i.

Answer : . The frmweb executable is invoked from the 10.1.2 ORACLE_HOME.

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

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 :

  • 8.0.6
  • 10.1.2
  • 10.1.3
  • 8.1.7

Answer : 10.1.3

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions