Oracle R12 Oracle: install,Patch and Maintain Oracle Applications - 1Z1-238 Exam Practice Test
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?
Correct Answer: B
Vote an answer
Identify three facts that you should consider when planning a shared APPL_TOP Oracle Applications installation. (Choose three.)
Correct Answer: C,E,G
Vote an answer
Identify the correct statement regarding the AutoPatch utility in R12.
Correct Answer: A
Vote an answer
A patch was applied successfully last night to the Oracle Applications environment to fix a bug. To check the bug fix, the Applications DBA accessed the "Bug Fixes Report." There are 1,000 files displayed in the report. The intended file for the bug fix does not appear. What should the Applications DBA do next?
Correct Answer: E
Vote an answer
Which can be patched using the AutoPatch utility? (Choose all that apply.)
Correct Answer: C
Vote an answer
Which piece of information is captured as part of the Patch Impact Analysis of a particular patch?
Correct Answer: B
Vote an answer
Identify three application-tier technology components used in Oracle Applications Release
12. (Choose three.)
12. (Choose three.)
Correct Answer: B,C,D
Vote an answer
Your patch was applied and finished without encountering any error during the process. Which is NOT a correct part of the postpatch process?
Correct Answer: C
Vote an answer
One of the special AD Controller utilities, Show Worker Status, collects worker status information from the FND_INSTALL_PROCESSES temp table. It tracks multiple workers for five categories: Worker, Code, Context, File Name, and Status.
The seven statuses are:
1.Failed
2.Completed
3.Waiting
4.Fixed/Restart
5.Running
6.Assigned
7.Restarted
Choose the sequence that would place the process statuses in the proper flow order when an in-processing error is received.
The seven statuses are:
1.Failed
2.Completed
3.Waiting
4.Fixed/Restart
5.Running
6.Assigned
7.Restarted
Choose the sequence that would place the process statuses in the proper flow order when an in-processing error is received.
Correct Answer: B
Vote an answer
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? (Choose all that apply.)
Correct Answer: A
Vote an answer
As a database administrator (DBA), you have been trying to apply a maintenance patch, but it has failed to run successfully to completion. You check the AD Administration log file for an error. The log file reveals several entries that are generic errors about the inability of patch codes to have access to product packages from the GL product modules. You remember that one of the occasions when you should run the Recreate Grants and Synonyms AD Administration utility is if the patch and the administrative sessions fail to run successfully to completion. You have found one occasion to use this utility in the case above. Now choose three other occasions when you would run this process again. (Choose three.)
Correct Answer: A,B,D
Vote an answer
Your system crashes while running an Application DBA (AD) utility. Which are the corrective actions you perform to synchronize the utility status and system status before restarting the utility? (Choose all that apply.)
Correct Answer: B,D,E
Vote an answer
Identify the environment variable that points to the $COMMON_TOP/java directory in Oracle Applications R12.
Correct Answer: D
Vote an answer
Praveen performed a single-node installation of Oracle Applications R12 on a Linux server. After a few days, he got one more server with the HP operating system. To use resources of both the servers, he decided to move the database tier to the new HP server. Identify the correct sequence of steps that he needs to perform to successfully move the database tier.
1.Start up the database and listener.
2.Shut down only application tier services.
3.Export the database from the Linux server by using the exp utility.
4.Install fresh 10g software on the HP server.
5.Create an empty database on the HP server.
6.Import data into empty database on HP server using the imp utility.
7.Copy only the $ORACLE_HOME database from the Linux server to the HP server.
8.Run AutoConfig on the database tier after changing the $CONTEXT_FILE.
9.Shut down all services of Oracle Applications R12.
10.
Enable database for AutoConfig.
11.
Copy the data files and $ORACLE_HOME database from the Linux server to the HP server.
12.
Run AutoConfig on the application tier after changing the $CONTEXT_FILE.
1.Start up the database and listener.
2.Shut down only application tier services.
3.Export the database from the Linux server by using the exp utility.
4.Install fresh 10g software on the HP server.
5.Create an empty database on the HP server.
6.Import data into empty database on HP server using the imp utility.
7.Copy only the $ORACLE_HOME database from the Linux server to the HP server.
8.Run AutoConfig on the database tier after changing the $CONTEXT_FILE.
9.Shut down all services of Oracle Applications R12.
10.
Enable database for AutoConfig.
11.
Copy the data files and $ORACLE_HOME database from the Linux server to the HP server.
12.
Run AutoConfig on the application tier after changing the $CONTEXT_FILE.
Correct Answer: D
Vote an answer
Which patch establishes the compatibility of the current version of Oracle Applications with the newer version of the database or technology stack component?
Correct Answer: C
Vote an answer