1Z0-238 - Oracle EBS R12: Install, Patch and Maintain Applications
Go back to Oracle
How many questions are there on the 1Z0-238 exam?
There are 75 questions on the 1Z0-238 exam to be completed in 90 minutes.
How long is the 1Z0-238 exam?
The 1Z0-238 exam is 90 minutes to complete 75 questions.
How much does the 1Z0-238 exam cost?
The 1Z0-238 exam is $245. The exam provider is Pearson Vue and you can register for the exam on their website.
What is the best way to study for the 1Z0-238 exam?
The best way to study for the 1Z0-238 exam is to practice at Exam.com.
All services of Oracle Applications R12 (application tier and database tier) are down. On which tier would the preclone finish successfully?
application tier only
Identify two reasons why all code objects (synonyms, views, triggers, and packages) for all products reside in the APPS schema. (Choose two.)
to facilitate central privilege access
to connect users to the APPS schema; if they are connected directly to product schemas such as INV, they would not have access to objects such as multiorganization views
Which table is used by AutoPatch as a staging area for the job information in parallel mode and needs to be dropped to start a new autopatch session if the earlier session failed?
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. Identify 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.
You want to apply a patch on your Oracle Applications system. Before doing this, you want to view the files that are new, changed, and ignored while applying the patch. Which feature of the Patch Wizard would help you accomplish this?
Patch Impact Analysis
You just brought the middle tier back after a hardware problem has been fixed. Oracle Applications now experience problems with an entire product group of forms (fnd), which includes the sign-on form. You decide that you will generate the forms files in AD Administration to see whether this will fix theproblem. You answered the prompts from the utility as follows: - Do you want to generate Oracle Forms using your current character set? (Yes) - Do you want to regenerate Oracle Forms PL/SQL library files? (Yes) - Do you want to regenerate Oracle Forms executable files? (Yes) - Do you want to regenerate Oracle Forms menu files? (Yes) - Enter the list of products, or enter 'all' [all]: (fnd) - Do you want to generate specific form objects for each selected product? (Yes) - Enter libraries and menus to generate, or enter 'all' [all]: (APPCORE.pll, the main library) - Enter forms to generate, or enter 'all' [all]: FNDSCSGN.fmx The utility finished with no errors in the log file. What is the outcome of running the adadmin utility?
All forms but one in the product group fnd now render with errors.
Which two statements are correct about multi-node cloning using Rapid Clone (adcfgclone.pl) for Oracle Applications R12? (Choose two.)
Rapid Clone can be used where the source system or the target system is a multi-node system.
One copy of the applications node files must be copied to the target system, regardless of whether a shared file system is being used on the source or the target system.
The concurrent manager log and output files are consolidated into a single directory across all products. Which environment variable identifies the top-level directory?
Identify the situations in which you would select a multi-node installation. (Choose all that apply.)
Data security is a concern and the application serves users on the Internet.
The number of concurrent requests may use up to 80% of the CPU on an all-time basis.
Identify three application-tier technology components used in Oracle Applications Release 12. (Choose three.)
Oracle Developer 10i
Application Server 10.1
Oracle HTTP Server/Apache 10.1.3
The Applications Context file has been accidentally deleted and was also lost accidentally. How do you restore the Applications Context file?
Execute $ perl /clone/bin/adclonectx.pl retrieve on the application tier.
You have a multi-node installation with Forms services and Batch Processing services configured on separate nodes. You attempt to update the Context variable on the batch processing node although Oracle Applications Manager (OAM) fails. What should you do to resolve the problem? (Choose two.)
Check whether the listener service is up on Forms services.
Enable the TNS listener service in the Application's Context file and run AutoConfig.
Identify the elements of a patch. (Choose all that apply.)
patch metadata files
How many times can AutoPatch be restarted?
Which two statements are correct about Rapid Clone? (Choose two.)
Rapid Clone updates only site-level profile options.
Rapid Clone automatically creates a control file and brings up the database on the database tier.
In Oracle Applications R12, where will you find information regarding minimum or required settings for database initialization parameters?
What is the version of the Java Oracle home in Oracle Applications Release 12?
Which three are the correct definitions of the objects in the Oracle Applications database? (Choose three.)
Hybrid objects contain materialized view objects, and store and process data.
Data objects contain table, index, and sequence and index-organized table objects.
Code objects contain trigger, PL/SQL package, Java-stored procedure, synonym, and view objects.
In AD Controller, when a job fails the first and second time, the manager automatically defers it to the end of the phase and assigns a new job to the worker. If the deferred job fails the third time, the job stays at the failed status and the worker waits. At this point, you must address the cause of the failure, and then restart the job using AD Controller. Choose two correct steps that would help you to troubleshoot the failure of the job and enable you to run the job to completion. (Choose two.)
Review the adworkXXX.log worker log file in $APPL_TOP/admin//log to find the error.
Review the file name and worker columns of the failed worker to find the name of the failed file and the worker number.
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 tablespace was dropped.
A custom schema was dropped.
A data file was added to the database.
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?
the devenv.env file
Postclone completed successfully both on the database tier and the application tier. All services started normally, but the login page was blank. Which action would you perform to fix this error?
In your Oracle Applications R12 E-Business Suite implementation, the database is corrupt. To resolve it, the database Java Virtual Machine (JVM) was reloaded. Identify the type of problem that may occur and the related correct solution.
Problem: All Oracle Applications Java classes are missing. Solution: Run the "Reload JAR files to the DB" task by using the adadmin utility.
Which statement holds true when AutoPatch is run in test mode?
AutoPatch runs AutoConfig in test mode.
You need to execute the adadmin utility. You log in as an applications user (applmgr). Which environment file should you run to execute adadmin successfully?
Which can be patched using the AutoPatch utility? (Choose all that apply.)
In an Oracle Applications Release 12 environment, where do you find the .xml file? (Choose two.)
What are the three benefits of the Applications Context file? (Choose three.)
It enables you to synchronize multiple nodes.
It avoids the need for repeated configuration information.
It supports shared APPL_TOP (single APPL_TOP distributed to multiple machines).
What are the two possible sequences of worker status while a job is being completed by a worker? (Choose two.)
Waiting => Assigned => Running => Completed
Waiting => Assigned => Running => Failed => Fixed, Restart => Restarted => Completed
Which command needs to be run to add a new node to an existing system?
Which statement is true regarding AutoPatch in the Oracle Applications Release 12 environment?
If language translation patches need to be applied in addition to the patch you are applying, AutoPatch notifies you.
What are the different AutoConfig scripts? (Choose three.)
You experience report-error problems in the Inventory module after applying a patch to the same module. You run the AD Administration utility, and select the Generate Application Files menu. Because you have report problems, you decide to run Generate Report Files. You answered the following questions during the utility run: - Do you want to generate Oracle report objects using the current character set? (You answer Yes.) - Do you want to regenerate the Oracle reports PL/SQL library files? (You answer No.) - Do you want to regenerate Oracle reports executable files? (You answer Yes.) - For which products do you want to generate Oracle report objects? (You answer "all reports in INV.") After you run the AD utilities, most reports in Inventory run with no errors. However, you still experience errors with two reports. Which two statements explain why the two reports still run with errors? (Choose two.)
You have reports with external library files.
Identify three modes in which AutoPatch can be run, in addition to the normal patch application mode. (Choose three.)
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?
Which are the two most common types of installations and node types? (Choose two.)
high-volume transaction environment -multi-node
training environment -single node
Identify two ways in which you validate the APPS schema in the Oracle Applications R12 E-Business Suite setup. (Choose two.)
Run the AD Administration utility in noninteractive mode with the default file having menu_option=VALIDATE_APPS.
Use SQL*PLUS / @$AD_TOP/admin/sql/advrfapp.sql .
What does the /resource directory contain in Oracle Applications?
pll and .plx files used by Oracle Forms
The Applications DBA is assigned to merge five patches without unzipping the automated release updates (ARUs), by running the AD Merge Patch. Which UNIX command has the correct arguments?
admgrpch -s -d \ -merge_name -manifest
Which Application DBA (AD) utility do you use to monitor the progress of a worker in the Oracle Applications Release 12 environment?
AD Controller utility
Which command-line argument is passed to admrgpch to name the merged driver file that is created as a result of merging multiple patches?
The Oracle Applications Release 12 processes on the application tier are started successfully. The Applications database administrator (DBA) must apply a patch while the users are still using Oracle Applications. According to the instructions from readme.txt of the patch to be applied, only the concurrent manager process must be shut down before applying the patch. After the patch is applied successfully, one should start the concurrent manager processes. The Applications DBA performs these steps to apply the patch on the application tier: Step 1: Logs in to the application tier as "applmgr" Step 2: Changes to the $INST_TOP/admin/scripts directory Step 3: Executes the adstpall.sh script Step 4: Applies the patch Step 5: Checks the log file of the patch for any errors Step 6: Runs the $INST_TOP/admin/scripts/adstrtal.sh script What do you conclude?
In the third step, the adstpall.sh script should not be used.
You were applying an Oracle Receivables patch to your Oracle Applications system. The patch failed. Now you want to revert to the older version of the files under the product AR using the backup copy, which AutoPatch creates, before making any changes to the existing files. Where would you find these files?
What are the three benefits of having the APPS schema in the Oracle Applications R12 database? (Choose three.)
By eliminating the need for cross-product grants and synonyms, the APPS schema improves reliability.
By using one APPS schema that can access all Oracle Applications objects, cross-product dependencies are eliminated.
By eliminating the need for cross-product grants and synonyms, the APPS schema reduces the time needed for installation, upgrade, and patching.
In Oracle Applications Release 12, what are the components used in Oracle Application Framework? (Choose three.)
Metadata UI Definition
Business Components for Java (BC4J)
Application Object Library Java (AOL/J)
According to readme.txt of the patch, the APPS schema must be recompiled and the AR forms must be regenerated after the patch is applied successfully. There would be several invalid objects in the database. Which is the correct step?
Run the AD Administration. Recompile the APPS schema and regenerate the AR Forms executables.
Which Oracle Applications environment file is used to compile and link custom Oracle Forms user exits and concurrent programs with Oracle Applications R12?
Where can you find the AutoConfig log files in the application tier and database tier? (Choose two.)
Which command can be used only with a single-node installation?
Identify three situations where relinking may be necessary. (Choose three.)
after the server libraries are updated
when executable programs become corrupted
when executable programs are accidentally deleted