21. In which three cases is it most effective to run validation on the APPS schema in the Oracle
Applications R12 E-Business Suite setup? (Choose three.)
A.before performing an export or import
B.after a patch or multiple patches are applied
C.immediately after an upgrade or after applying a maintenance pack
D.after converting to multiple organizations or multiple reporting currencies
E.whenever you receive a run-time error that suggests that a problem is caused by the AD_DDL package
Answer: BCE
22. 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 three causes are responsible for this? (Choose three.)
A.incomplete database migrations (exports or imports)
B.patch and administrative sessions that failed to run successfully to completion
The safer , easier way to help you pass any IT exams.
10 / 86
C.invoking PL/SQL routines to maintain multilingual tables by adding missing, untranslated rows
D.installing or maintaining Oracle Applications R12 E-Business Suite underlying database components or
options such as Replication
Answer: ABD
23. A report output file is generated when you run "Validate APPS schema" by using the adadmin utility in
the Oracle Applications R12 E-Business Suite environment.
If the report shows something similar to "GL_CODE_COMBINATIONS table does not exist or is an invalid
object," what is the first step that the database administrator (DBA) should perform to correct this issue?
A.Run the AD Relink utility and relink the GL product.
B.Use License Manager, and register the GL product.
C.Run Rapid Install to reinstall database components.
D.Run AutoPatch, and apply the GL latest available patch.
E.Run the "Recreate grants and synonyms for the APPS schema" task by using the adadmin utility.
Answer: E
24. Where can you find the generated report file after running the "Validate APPS schema" task in the
Oracle Applications R12 E-Business Suite setup?
A./admin/.lst
B./admin/out/.lst
C./admin/out/.lst
D./admin//out/.lst
E./admin//out/.lst
Answer: E
25. 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.
The safer , easier way to help you pass any IT exams.
11 / 86
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.)
A.after custom development
B.when applying a patch to the operating system
C.after applying a patch to the Applications technology stack
D.in case of incomplete database migrations (exports or imports)
E.when installing or maintaining underlying database components or options such as Replication
Answer: ADE
26. Which two statements are true if you choose the "Recreate grants and synonyms for APPS schema"
task option from the adadmin utility? (Choose two.)
A.This option re-creates grants on some packages from APPS to SYSTEM.
B.This option re-creates grants and synonyms for the APPLSYSPUB schema.
C.This option re-creates grants and synonyms for the code objects of the APPS schema to the base
product schemas.
D.This option spawns parallel workers to re-create grants and synonyms linking sequences and tables in
the base product schemas to the APPS schema.
Answer: BD
27. When does the FND_INSTALL_PROCESSES table get created in the Oracle Applications R12
E-Business Suite database?
A.whenever the AD Controller utility is used
B.when AutoPatch, AutoUpgrade, or AD Administration programs process jobs
C.during the upgrade to R12 E-Business Suite from the earlier version of Oracle Applications
D.when the R12 E-Business Suite database is created in a Real Application Clusters (RAC) setup
E.during the R12 E-Business Suite installation and, more specifically, at the time of the database APPS
schema creation
Answer: B
The safer , easier way to help you pass any IT exams.
12 / 86
28. The AD Administration task utility "Compile APPS Schema" is similar to the "Validate APPS Schema"
task, except that instead of just producing a list of invalid objects, it compiles invalid objects using multiple
workers in an attempt to move them back to the valid object state.
This task is most often run when custom packages are moved into the APPS schema, and during the
upgrade process.
The "Compile APPS Schema" task can be toggled to compile all objects or just the invalid objects.
Choose three correct benefits of using this task. (Choose three.)
A.increases run-time performance in the applications
B.corrects all corrupt schema package bodies and headers
C.finds truly invalid objects before users get a run-time error
D.allows new custom or patched packages to be immediately validated
Answer: ACD
29. 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.)
A.Compile the Menu information to restore Java menu files to the application forms.
B.Reload JAR files to the database because after reloading the JVM, the Java class files would be
missing.
C.Compile the APPS schema because after the JVM has been reloaded, APPS permissions need to be
reestablished.
D.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.
Answer: B
30. 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
The safer , easier way to help you pass any IT exams.
13 / 86
and the related correct solution.
A.Problem: Many invalid objects are found in the APPS schema.
Solution: Run the "Validate APPS schema" task by using the adadmin utility.
B.Problem: All Oracle Applications Java classes are missing.
Solution: Run the "Reload JAR files to the DB" task by using the adadmin utility.
C.Problem: The Application screen display does not come up with one of the installed language
characters.
Solution: Run the "Convert Character set" task by using the adadmin utility.
D.Problem: The Application window does not show any of the Accounts Receivables data.
Answer: B
