Oracle R12 Oracle: install,Patch and Maintain Oracle Applications - 1Z0-238 Exam Practice Test
The Application Utilities (AU_TOP) directory contains _____.
Correct Answer: D
Vote an answer
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.
Correct Answer: E
Vote an answer
Which can be patched using the AutoPatch utility? (Choose all that apply.)
Correct Answer: A
Vote an answer
On a database server that uses a Windows platform, there are two ways to stop a database. One way is to go to the Windows Services window, and then click Stop. Which is the other way (on a Windows platform)?
Correct Answer: C
Vote an answer
There was an error while applying a patch. The AutoPatch error message indicates that the FND_INSTALL_PROCESSES table already exists. AutoPatch asks if you want to drop the table. Which two steps need to be performed before dropping the table? (Choose two.)
Correct Answer: B,F
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: E
Vote an answer
In Oracle Applications R12 configured on a UNIX operating system, where will you find the various application tier control scripts?
Correct Answer: C
Vote an answer
Identify four scenarios in the Oracle Applications R12 E-Business Suite environment in which you would need to run AutoConfig. (Choose four.)
Correct Answer: A,B,E,F
Vote an answer
Which two values must be set for changing the temporary directory for log and output files from the PL/SQL concurrent program? (Choose two.)
Correct Answer: A,B
Vote an answer
Applying a patch in Pre-Install mode performs which three actions only? (Choose three.)
Correct Answer: C,D,E
Vote an answer
Where can you find the generated report file after running the Validate APPS schema task in the Oracle Applications R12 E-Business Suite setup?
Correct Answer: E
Vote an answer
Which directory structure is created by default when you install the Oracle Applications R12 file system ?
Correct Answer: D
Vote an answer
Consider a situation where a worker failed with a core dump and cannot be restarted. Although the worker is listed as running in the adctrl utility, there is no operating system-level process for the erring worker.
In this situation, the only option is to restart the patch. What are the steps performed to restart the patch?
1.Tell the manager that a worker acknowledges quit.
2.Restart the patch.
3.Tell the manager that a worker failed its job.
4.Tell the worker to shut down or quit (all workers).
Identify the correct sequence in which you perform the task in the above scenario.
In this situation, the only option is to restart the patch. What are the steps performed to restart the patch?
1.Tell the manager that a worker acknowledges quit.
2.Restart the patch.
3.Tell the manager that a worker failed its job.
4.Tell the worker to shut down or quit (all workers).
Identify the correct sequence in which you perform the task in the above scenario.
Correct Answer: C
Vote an answer