L'avènement de la certification Oracle pratique d'examen 1Z1-238 questions et réponses

Les produits de Pass4Test a une bonne qualité, et la fréquence de la mise à jour est bien impressionnée. Si vous avez déjà choisi la Q&A de Pass4Test, vous n'aurez pas le problème à réussir le test Oracle 1Z1-238.

Si vous êtes intéressé par l'outil formation Oracle 1Z1-238 étudié par Pass4Test, vous pouvez télécharger tout d'abord le démo. Le service de la mise à jour gratuite pendant un an est aussi offert pour vous.

Pour l'instant, vous pouvez télécharger le démo gratuit de Q&A Oracle 1Z1-238 dans Pass4Test pour se former avant le test Oracle 1Z1-238.

L'équipe de Pass4Test se composant des experts dans le domaine IT. Toutes les Q&As sont examinées par nos experts. Les Q&As offertes par Pass4Test sont réputées pour sa grande couverture ( presque 100%) et sa haute précision. Vous pouvez trouver pas mal de sites similaires que Pass4Test, ces sites peut-être peuvent vous offrir aussi les guides d'études ou les services en ligne, mais on doit admettre que Pass4Test peut être la tête de ces nombreux sites. La mise à jour, la grande couverture des questions, la haute précision des réponses nous permettent à augmenter le taux à réussir le test Certification Oracle 1Z1-238. Tous les points mentionnés ci-dessus seront une assurance 100% pour votre réussite de test Certification Oracle 1Z1-238.

Le test Oracle 1Z1-238 est le premier pas pour promouvoir dans l'Industrie IT, mais aussi la seule rue ramenée au pic de succès. Le test Oracle 1Z1-238 joue un rôle très important dans cette industrie. Et aussi, Pass4Test est un chaînon inevitable pour réussir le test sans aucune doute.

Code d'Examen: 1Z1-238

Nom d'Examen: Oracle (R12 Oracle: install,Patch and Maintain Oracle Applications)

Questions et réponses: 223 Q&As

La Q&A Oracle 1Z1-238 est étudiée par les experts de Pass4Test qui font tous effort en profitant leurs connaissances professionnelles. La Q&A de Pass4Test est ciblée aux candidats de test IT Certification. Vous voyez peut-être les Q&As similaires dansn les autres site web, mais il n'y a que Pass4Test d'avoir le guide d'étude plus complet. C'est le meilleur choix à s'assurer le succès de test Certification Oracle 1Z1-238.

Maintenant, beaucoup de professionnels IT prennent un même point de vue que le test Oracle 1Z1-238 est le tremplin à surmonter la pointe de l'Industrie IT. Beaucoup de professionnels IT mettent les yeux au test Certification Oracle 1Z1-238.

1Z1-238 Démo gratuit à télécharger: http://www.pass4test.fr/1Z1-238.html

NO.1 You discover that you will be applying an application patch on your APPL_TOP by using AutoPatch,
which
contains a compatible feature, the prereq line.
To ensure that the automatic, prerequisite patch-checking feature operates during the application of the
patch, you must run AD Administration, Maintain Snapshot Information, then perform some key tasks, and
then AutoPatch.
Select four key Maintain Snapshot Information tasks or combination of tasks that will ensure that the
prerequisite patch-checking feature operates during the application of the patch. (Choose four.)
A.Update a current view snapshot, or create a named snapshot.
B.Export a snapshot to a file, and then delete the named snapshot.
C.Import an up-to-date snapshot from a file from a different APPL_TOP.
D.List snapshots, delete the named snapshot, and create a named snapshot.
E.Copy the existing snapshot, delete the named snapshot, and then create a named snapshot.
Answer: ACDE

Oracle examen   1Z1-238   certification 1Z1-238   1Z1-238   certification 1Z1-238

NO.2 As part of the cloning process, the Applications DBA needs to copy the application tier file system to the
target system.
Which step is NOT a part of this process?
A.Shut down the application tier server processes.
B.Log on to the target system application tier nodes as the oracle user.
C.Copy the APPL_TOP directory from the source node to the target node.
D.Copy the directory from the source node to the target node.
E.Copy the directory from the source node to the target node.
F.Copy the directory from the source node to the target node.
G.Copy the <806 ORACLE_HOME> directory from the source node to the target node.
Answer: B

Oracle   1Z1-238   1Z1-238 examen

NO.3 What are the two occasions when it is appropriate to run "Compile APPS schema" by using the AD
Administration utility in the Oracle Applications R12 E-Business Suite environment? (Choose two.)
A.during the Oracle Applications R12 E-Business Suite upgrade process
B.when custom packages are moved to the APPS schema and need to be compiled
C.after enabling the multiple reporting currencies in the Oracle Applications R12 E-Business Suite
environment
D.after enabling the multiorganization functionality in the Oracle Applications R12 E-Business Suite
environment
E.when encountering invalid objects in the SYS and SYSTEM schemas in the Oracle Applications R12
E-Business Suite database
Answer: AB

Oracle examen   1Z1-238 examen   certification 1Z1-238   1Z1-238 examen

NO.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?
A.Patch Filters
B.Patch Impact Analysis
C.Recommended Patches
D.Patch Information Bundle
Answer: B

certification Oracle   1Z1-238 examen   1Z1-238   1Z1-238 examen

NO.5 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:
1. Do you want to generate Oracle Forms using your current character set? (Yes)
2. Do you want to regenerate Oracle Forms PL/SQL library files? (Yes)
3. Do you want to regenerate Oracle Forms executable files? (Yes)
4. Do you want to regenerate Oracle Forms menu files? (Yes)
5. Enter the list of products, or enter 'all' [all]: (fnd)
6. Do you want to generate specific form objects for each selected product? (Yes)
7. Enter libraries and menus to generate, or enter 'all' [all]: (APPCORE.pll, the main library)
8. 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?
A.All forms in the product group fnd now render with errors.
B.All forms in the product group fnd now render without errors.
C.All forms but one in the product group fnd now render with errors.
D.All forms but one in the product group fnd now render without errors.
Answer: C

certification Oracle   1Z1-238   1Z1-238   1Z1-238   certification 1Z1-238

NO.6 Before you apply a patch, you read the readme.txt file.
One of the areas of Oracle Applications to which the patch will be applied is JAVA_TOP.
The readme file mentions that you may need to generate product JAR files in the AD Administration
utilities after the patch is applied.
When generating product JAR files, the AD Administration utility will prompt you with the question: Do you
want to force the generation of all JAR files?
What are the three occasions when you need to force the generation of all JAR files? (Choose three.)
A.after changing your digital signature
B.after updating to a new Java version
C.if you find you have missing or out-of-date JAR files
D.if you are upgrading the Oracle Developer technology stack
Answer: ABD

Oracle   1Z1-238   1Z1-238

NO.7 Which command can be used only with a single-node installation?
A.rapidwiz -restart
B.rapidwiz -techstack
C.rapidwiz -servername
D.rapidwiz -silent -config
Answer: C

Oracle   1Z1-238   certification 1Z1-238   certification 1Z1-238   1Z1-238 examen

NO.8 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?
A.FND_JOBS
B.FND_PROCESSES
C.FND_INSTALL_PROCESSES
D.FND_INSTALLED_PROCESSES
Answer: C

Oracle examen   1Z1-238 examen   1Z1-238

NO.9 While working with Web forms an application user sometimes comes across a performance issue. The
initial screen takes too long to appear with the Web form screen, showing the status "Downloading JAR
files..." for a long time.
Identify the reasons for this. (Choose two.)
A.It always takes time to load the Web forms.
B.An older version of Sun J2SE plug-in is installed on the Desktop tier.
C.JAR files for the Forms client applet are downloaded automatically the first time it is used.
D.The browser will automatically retrieve new JAR files if they have changed on the application tier.
E.The Internet Explorer browser security level should be set as "Low" for the zone that contains the
Oracle Application Release 12 Web pages.
Answer: CD

certification Oracle   1Z1-238   1Z1-238

NO.10 Identify the files that are changed when you run AutoConfig. (Choose all that apply.)
A./listener.ora
B./.env
C./admin/adconfig.txt
D./.env
E./appl/admin/.xml
Answer: ABD

Oracle   1Z1-238   1Z1-238

NO.11 If the patch is running in Pre-Install mode, where would the patch history files be stored in Oracle
Applications R12 configured on a UNIX operating system?
A.$AD_TOP/admin
B.$APPL_TOP/admin
C.$TEMP/runInstaller
D.$APPL_TOP/admin/
E.$COMMON_TOP/admin/
Answer: D

certification Oracle   1Z1-238   certification 1Z1-238   1Z1-238   certification 1Z1-238

NO.12 What is the default value of ?
A.APPS_
B.APPS_
C._
D._
E.APPS_
Answer: D

Oracle   1Z1-238 examen   1Z1-238 examen

NO.13 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?
A.the context file
B.the devenv.env file
C.the fndenv.env file
D.the adovars.env file
E.the adconfig.txt file
Answer: B

certification Oracle   1Z1-238 examen   1Z1-238   1Z1-238 examen

NO.14 What are the two possible sequences of worker status while a job is being completed by a worker?
(Choose two.)
A.Waiting => Assigned => Running => Completed
B.Assigned => Waiting => Running => Completed
C.Waiting => Assigned => Running => Failed => Fixed, Restart => Restarted => Completed
D.Assigned => Waiting => Running => Failed => Fixed, Restart => Restarted => Completed
E.Waiting => Assigned => Running => Failed => Fixed, Restart => Restarted => Running => Completed
Answer: AC

certification Oracle   certification 1Z1-238   1Z1-238   certification 1Z1-238

NO.15 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:
1. Do you want to generate Oracle report objects using the current character set? (You answer Yes.)
2. Do you want to regenerate the Oracle reports PL/SQL library files? (You answer No.)
3. Do you want to regenerate Oracle reports executable files? (You answer Yes.)
4. 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.)
A.You have reports in a different language.
B.You have reports with external library files.
C.You have custom reports in a custom directory.
D.You have reports from a different module being referenced on the Inventory report menu.
Answer: B

Oracle examen   certification 1Z1-238   1Z1-238   1Z1-238 examen

NO.16 Identify the patch that you apply to upgrade the Oracle Applications system from the 11.5.5 version to
the 11.5.10 version.
A.diagnostic patch
B.stand-alone patch
C.maintenance pack
D.product family release update pack
Answer: C

Oracle   1Z1-238 examen   1Z1-238   1Z1-238

NO.17 During installation, the Rapid Install process creates ______ that are used to start and stop the server
processes on the database tier.
A.JServer load balancers
B.cost-based optimizers
C.database resource managers
D.session-persistent load balancers
E.database-tier server process scripts
Answer: E

Oracle   1Z1-238 examen   1Z1-238

NO.18 Identify two ways in which you validate the APPS schema in the Oracle Applications R12 E-Business
Suite setup. (Choose two.)
A.Run the /appsutil/scripts//advrfapp.sh script.
B.Run the AD Administration utility in noninteractive mode with the default file having
menu_option=VALIDATE_APPS.
C.Run the AD Administration utility in interactive mode, and then select Compile/Reload Applications
Database Entities menu > Compile APPS Schema option.
D. Use SQL*PLUS / @$AD_TOP/admin/sql/advrfapp.sql .
Answer: BD

certification Oracle   certification 1Z1-238   1Z1-238   1Z1-238   1Z1-238   1Z1-238

NO.19 AD Administration contains a utility named Maintain Snapshot Information. Which statements
correctly describe the functionality of this utility? (Choose all that apply.)
A.You can create a copy of an existing snapshot.
B.You can delete the current view snapshot.
C.You can create a list of the current view and named snapshots stored in your system.
D.You can export an existing snapshot to a file for storage or to another system.
E.You can update the current view snapshot with any changes to the snapshot since the last update.
Answer: ACDE

certification Oracle   1Z1-238   1Z1-238 examen   1Z1-238   certification 1Z1-238

NO.20 You run the AD Administration utility and select the Relink Applications programs.
You answered the following questions during the utility run:
Do you wish to proceed with the relink [Yes]? (You answer Yes.)
Enter the list of products to link ("all" for all products) [all]? (You answer "ad." )
Do you want to generate specific executables for each selected product [No]? (You answer Yes.)
AD Administration can relink your Oracle Applications programs with debug
information. Oracle recommends that you do not relink your programs
with debug information unless asked to do so by Oracle Support Services.
Do you want to relink with debug information [No]? (You answer No.)
What is the next question asked by adadmin?
A.It gives you a list of all executables to choose from.
B.It gives you the list of "ad" executables to choose from.
C.It gives you the list of all executables except "ad" to choose from.
D.It asks no question. It displays the message "Review the messages above, then press [Return] to
continue."
Answer: D

Oracle   certification 1Z1-238   1Z1-238   certification 1Z1-238

Beaucoup de gens trouvent difficile à passer le test Oracle 1Z1-238, c'est juste parce que ils n'ont pas bien choisi une bonne Q&A. Vous penserez que le test Oracle 1Z1-238 n'est pas du tout autant dur que l'imaginer. Le produit de Pass4Test non seulement comprend les Q&As qui sont impressionnées par sa grande couverture des Questions, mais aussi le service en ligne et le service après vendre.

Le plus récent matériel de formation examen Oracle 1Z0-146 de certification

Selon les feedbacks les professionnels bien réputés dans l'Industrie IT, Pass4Test est un bon catalyseur de leurs succès. L'outil de formation offert par Pass4Test leur aide d'économiser le temps et l'argent, le plus important est qu'ils aient passé le test Oracle 1Z0-146 avec succès. Pass4Test est un fournissur fiable. Vous allez réaliser votre rêve avec l'aide de Pass4Test.

Le test simulation offert par Pass4Test est bien proche du test réel. Vous pouvez apprendre tous essences d'un test réel à courte terme avec l'aide de Pass4Test. Pass4Test peut vous assurer le succès 100% de test Oracle 1Z0-146.

Aujoud'hui, c'est une société de l'informatique. Beaucoup d'organisations peut provider l'outil de se former pour le test Certification Oracle 1Z0-146. Mais on doit admettre que ces site n'ont pas la capacité à offrir une bonne Q&A, elles sont généralement très vagues et sans les points. C'est loin d'attirer les attentions des candidats.

Pass4Test est un site particulier à offrir les guides de formation à propos de test certificat IT. La version plus nouvelle de Q&A Oracle 1Z0-146 peut répondre sûrement une grande demande des candidats. Comme tout le monde le connait, le certificat Oracle 1Z0-146 est un point important pendant l'interview dans les grandes entreprises IT. Ça peut expliquer un pourquoi ce test est si populaire. En même temps, Pass4Test est connu par tout le monde. Choisir le Pass4Test, choisir le succès. Votre argent sera tout rendu si malheureusement vous ne passe pas le test Oracle 1Z0-146.

Pass4Test est un site d'offrir l'outil de formation convenable pour les candidats de test Certification IT. Le produit de Pass4Test peut aider les candidats à économiser les temps et les efforts. L'outil de formation est bien proche que test réel. Vous allez réussir le test 100% avec l'aide de test simulation de Pass4Test. C'est une bonne affaire à prendre le Certificat IT en coûtant un peu d'argent. N'hésitez plus d'ajouter l'outil de formation au panier.

Le test Certification Oracle 1Z0-146 est une chance précieuse à augmenter vos connaissances de technologie informatique dans l'industrie IT. Il attire beaucoup de professionls à participer ce test. Pass4Test peut vous offrir les outils de formation particuliers à propos de test Oracle 1Z0-146. Vous réaliserez plus tôt votre rêve avec la Q&A écrite par l'équipe professionnelle de Pass4Test. Pass4Test se contribue à vous donner un coup de main pour réussir le test Oracle 1Z0-146.

Code d'Examen: 1Z0-146

Nom d'Examen: Oracle (Oracle database 11g:advanced pl/sql)

Questions et réponses: 136 Q&As

1Z0-146 Démo gratuit à télécharger: http://www.pass4test.fr/1Z0-146.html

NO.1 In a user session, tracing is enabled as follows:
SQL> EXECUTE
DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_LINES);
PL/SQL procedure successfully completed.
You executed the procedure as follows:
SQL> EXECUTE PROC10
PL/SQL procedure successfully completed.
When you examine the PLSQL_TRACE_EVENTS table, you find that no trace information was
written into it.
View the Exhibit.
What is the reason for this?
A. The PROC10 procedure is created with the invoker's right.
B. The PROC10 procedure is not compiled with the DEBUG option.
C. Tracing is not enabled with the TRACE_ENABLED_CALLS option.
D. The TRACE_ENABLED parameter is set to FALSE for the session.
Answer: B

Oracle examen   1Z0-146   1Z0-146 examen

NO.2 DATA_FILES is a directory object that contains the DETAILS.TXT text file.
You have the required permissions to access the directory object.
You create a table using the following command:
CREATE TABLE clob_tab(col2 CLOB);
View the Exhibit and examine the PL/SQL block that you execute for loading the external text file into the
table that currently has no rows. The PL/SQL block results in an error.
What correction must be done to ensure the PL/SQL block executes successfully?
A. The L_OUT variable must be initialized to an empty locator.
B. The L_OUT variable has to be declared as a temporary LOB.
C. The A_CLOB variable has to be declared as a temporary LOB.
D. The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly
initialize the locator.
Answer: D

Oracle   1Z0-146   1Z0-146 examen   certification 1Z0-146   1Z0-146   certification 1Z0-146

NO.3 Which statement describes the purpose of the plshprof command?
A. It produces HTML output from raw profiler output.
B. It produces HTML output from profiler tables in the database.
C. It populates profiler tables in the database from raw profiler output.
D. It populates profiler tables in the database from raw profiler output.
Answer: A

Oracle   1Z0-146 examen   1Z0-146 examen   1Z0-146 examen

NO.4 Which two statements are true about SecureFile LOB options? (Choose two.)
A. The COMPRESSION HIGH option can be enabled only for CLOBs.
B. The COMPRESSION HIGH option can be enabled for all internal LOBs.
C. The DECRYPT option can be used to remove encryption only if the LOB column is empty.
D. The DECRYPT option can be used to remove encryption from LOB columns that are empty or contain
data.
Answer: BD

certification Oracle   certification 1Z0-146   certification 1Z0-146   certification 1Z0-146

NO.5 Examine the commands:
CREATE TYPE typ_course_tab IS VARRAY(5) OF VARCHAR2(20)
/
CREATE TYPE typ_course_nst
AS TABLE OF typ_course_tab
/
CREATE TABLE faculty
( faculty_id NUMBER(5),
faculty_name VARCHAR2(30),
courses typ_course_nst)
NESTED TABLE courses STORE AS course_stor_tab
/
INSERT INTO faculty
VALUES (101, 'Jones', NULL);
UPDATE (SELECT courses FROM faculty WHERE faculty_id=101) SET courses =
typ_course_nst(11,'Oracle');
Which statement is true about the execution of these commands?
A. All the commands execute successfully.
B. Only the first two commands execute successfully.
C. Only the first four commands execute successfully.
D. Only the first three commands execute successfully.
Answer: C

Oracle   1Z0-146   1Z0-146

NO.6 Which two types of metadata can be retrieved by using the various procedures in the
DBMS_METADATA PL/SQL package.? (Choose two.)
A. report of invalidated objects in a schema
B. report of statistics of an object in the database
C. DDL for all object grants on a table in the database
D. data definition language (DDL) for all objects in a schema
Answer: CD

Oracle examen   1Z0-146   1Z0-146   1Z0-146 examen   1Z0-146 examen

NO.7 Which two statements correctly describe the features of SecureFiles? (Choose two.)
A. Compression does not entail table or index compression and vice-versa.
B. Encryption stores the encryption keys for the LOB columns inside the database.
C. Encryption stores the encryption keys for the LOB columns outside the database.
D. Compression stores identical data occurring two or more times in the same LOB column as a single
copy for the table.
Answer: AC

Oracle   1Z0-146   1Z0-146 examen   1Z0-146 examen   1Z0-146

NO.8 Examine the code in the following PL/SQL block:
DECLARE
TYPE NumList IS TABLE OF INTEGER;
List1 NumList := NumList(11,22,33,44);
BEGIN
List1.DELETE(2);
DBMS_OUTPUT.PUT_LINE
( 'The last element# in List1 is ' || List1.LAST ||
' and total of elements is '||List1.COUNT);
List1.EXTEND(4,3);
END;
/
Which two statements are true about the above code? (Choose two.)
A. LAST and COUNT give different values.
B. LAST and COUNT give the same values.
C. The four new elements that are added contain the value 33.
D. The four new elements that are added contain the value 44.
Answer: AC

Oracle   1Z0-146 examen   1Z0-146   1Z0-146   1Z0-146

NO.9 View the Exhibit and examine the structure of the EMPLOYEES table.
Examine the following PL/SQL block:
DECLARE
TYPE EmpList
IS VARRAY(2) OF employees.employee_id%TYPE NOT NULL;
v_employees EmpList := EmpList();
BEGIN
DBMS_OUTPUT.PUT_LINE(v_employees.COUNT);
v_employees.EXTEND;
v_employees(1) := 30;
END;
/
Which statement is true about the outcome on executing the above PL/SQL block?
A. It executes successfully and displays the value 2.
B. It executes successfully and displays the value 0.
C. It generates an error because EXTEND cannot be used for varrays.
D. It generates an error because the declaration of the varray is not valid.
Answer: B

Oracle examen   1Z0-146 examen   1Z0-146 examen   certification 1Z0-146   certification 1Z0-146   1Z0-146

NO.10 The database instance was recently started up. Examine the following parameter settings for the
database instance:
NAME TYPE VALUE
------------------------------------ ----------- ----------------------------
result_cache_max_result integer 5
result_cache_max_size big integer 0
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
.........
You reset the value for the result_cache_max_size parameter by issuing the following command:
SQL> ALTER SYSTEM SET result_cache_max_size = 1056k SCOPE = BOTH;
System altered.
Which statement is true in this scenario?
A. 1056 KB is allocated for the result cache and the result cache is enabled.
B. 1056 KB is allocated for the result cache, but the result cache is disabled.
C. The results for only the queries that have the RESULT_CACHE hint are cached.
D. The results for all the queries except those having the NO_RESULT_CACHE hint are cached.
Answer: B

certification Oracle   1Z0-146   certification 1Z0-146   1Z0-146   1Z0-146

NO.11 View the Exhibit and examine the procedure to create a trigger name based on the table name supplied
to the procedure.
Which three statements are appropriate for protecting the code in the procedure from SQL injection?
(Choose three.)
A. Explicitly validate the identifier length limit.
B. Add AUTHID DEFINER to the definition of the procedure.
C. Use PRAGMA RESTRICT_REFERENCES in the procedure.
D. Filter out control characters in user-supplied identifier names.
E. Use the object ID of the table from the data dictionary to build the trigger name.
Answer: ADE

certification Oracle   1Z0-146 examen   1Z0-146   1Z0-146

NO.12 Which two statements are true about associative arrays and varrays? (Choose two.)
A. Only varrays must start with the subscript 1.
B. Only varrays can be used as column types in database tables.
C. Both associative arrays and varrays must start with the subscript 1.
D. Both associative arrays and varrays can be used as column types in database tables.
Answer: AB

Oracle   1Z0-146 examen   1Z0-146

NO.13 Examine the structure of the EMPLOYEES table in the SCOTT schema.
Name Null? Type
----------------------- --------------- ---------------
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
SALARY NOT NULL NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
DEPARTMENT_ID NUMBER(4)
View the Exhibit and examine the code for the EMP_TOTSAL procedure created by user SCOTT.
Which statement is true regarding the EMP_TOTSAL procedure?
A. It is created successfully, but displays the correct output message only for existent employee IDs.
B. It is created successfully and displays the correct output message for both existent and nonexistent
employee IDs.
C. It generates an error because the %NOTFOUND attribute cannot be used in
combination with a SELECT INTO statement
D. It generates an error because a user-defined exception has to be included whenever
the %NOTFOUND attribute is used in combination with a SELECT INTO statement.
Answer: A

Oracle examen   1Z0-146 examen   1Z0-146 examen   1Z0-146

NO.14 View the Exhibit to examine the PL/SQL code for the GET_METADATA function. Which statement is
true about the metadata gathered by the function?
A. The end result is the creation of DDL for the TIMECARDS table with all instances of the HR schema
changed to SCOTT.
B. The end result is the creation of an XML document for all tables with all physical, storage, logging, and
other segment attributes.
C. The end result is the creation of DDL for all tables with all instances of the HR schema changed to
SCOTT along with all physical, storage, logging, and other segment attributes.
D. The end result is the creation of DDL for all tables and associated indexes with all instances of the HR
schema changed to SCOTT along with all physical, storage, logging, and other segment attributes.
Answer: A

Oracle examen   certification 1Z0-146   1Z0-146 examen   certification 1Z0-146   certification 1Z0-146   1Z0-146

NO.15 Examine the structure of the DEPARTMENTS table.
Name Null? Type
----------------------------- ------------ ----------
DEPARTMENT_ID NOT NULL NUMBER(4)
DEPARTMENT_NAME NOT NULL VARCHAR2(30)
LOCATION_ID NUMBER(4)
View the Exhibit and examine the code that you plan to use for creating a package to obtain the
details of an employee using a host variable on the client side.
In SQL*Plus, you plan to use the following commands:
SQL> VARIABLE x REFCURSOR
SQL> EXECUTE emp_data.get_emp(195,:x)
SQL> PRINT x
Which statement is true about the above scenario?
A. The package executes successfully and passes the required data to the host variable.
B. The package specification gives an error on compilation because cursor variable types cannot be
defined in the specification.
C. The package specification gives an error on compilation because the cursor variable parameter was
specified before you defined it.
D. The package executes successfully, but does not pass the required data to the host variable because
the cursor is closed before the PRINT statement runs.
Answer: D

Oracle   1Z0-146   certification 1Z0-146   1Z0-146   1Z0-146

Si vous êtes intéressé par l'outil formation Oracle 1Z0-146 étudié par Pass4Test, vous pouvez télécharger tout d'abord le démo. Le service de la mise à jour gratuite pendant un an est aussi offert pour vous.

Pass4Test offre une formation sur Oracle 1Z0-238 matériaux examen

Le Pass4Test est un site qui peut offrir les facilités aux candidats et aider les candidats à réaliser leurs rêve. Si vous êtes souci de votre test Certification, Pass4Test peut vous rendre heureux. La haute précision et la grande couverture de la Q&A de Pass4Test vous aidera pendant la préparation de test. Vous n'aurez aucune raison de regretter parce que Pass4Test réalisera votre rêve.

Beaucoup de travailleurs dans l'Industrie IT peut obenir un meilleur travail et améliorer son niveau de vie à travers le Certificat Oracle 1Z0-238. Mais la majorité des candidats dépensent beaucoup de temps et d'argent pour préparer le test, ça ne coûte pas dans cette société que le temps est tellement précieux. Pass4Test peut vous aider à économiser le temps et l'effort pendant le cours de la préparation du test Oracle 1Z0-238. Choisir le produit de Pass4Test particulier pour le test Certification Oracle 1Z0-238 vous permet à réussir 100% le test. Votre argent sera tout rendu si malheureusement vous ne passez pas le test.

Pour vous laisser savoir mieux que la Q&A Oracle 1Z0-238 produit par Pass4Test est persuadante, le démo de Q&A Oracle 1Z0-238 est gratuit à télécharger. Sous l'aide de Pass4Test, vous pouvez non seulement passer le test à la première fois, mais aussi économiser vos temps et efforts. Vous allez trouver les questions presque même que lesquels dans le test réel. C'est pourquoi tous les candidats peuvent réussir le test Oracle 1Z0-238 sans aucune doute. C'est aussi un symbole d'un meilleur demain de votre carrière.

On doit faire un bon choix pour passer le test Oracle 1Z0-238. C'est une bonne affaire à choisir la Q&A de Pass4Test comme le guide d'étude, parce que vous allez obtenir la Certification Oracle 1Z0-238 en dépensant d'un petit invertissement. D'ailleur, la mise à jour gratuite pendant un an est aussi gratuite pour vous. C'est vraiment un bon choix.

Code d'Examen: 1Z0-238

Nom d'Examen: Oracle (R12 Oracle: install,Patch and Maintain Oracle Applications)

Questions et réponses: 165 Q&As

Si vous voulez ne se soucier plus à passer le test Oracle 1Z0-238, donc vous devez prendre la Q&A de Pass4Test comme le guide d'étude pendant la préparation de test Oracle 1Z0-238. C'est une bonne affaire parce que un petit invertissement peut vous rendre beaucoup. Utiliser la Q&A Oracle 1Z0-238 offerte par Pass4Test peut vous assurer à réussir le test 100%. Pass4Test a toujours une bonne réputation dans l'Industrie IT.

Dans cette époque glorieuse, l'industrie IT est devenue bien intense. C'est raisonnable que le test Oracle 1Z0-238 soit un des tests plus populaires. Il y a de plus en plus de gens qui veulent participer ce test, et la réussite de test Oracle 1Z0-238 est le rêve pour les professionnels ambitieux.

Dans cette société, il y a plein de gens talentueux, surtout les professionnels de l'informatique. Beaucoup de gens IT se battent dans ce domaine pour améliorer l'état de la carrière. Le test 1Z0-238 est lequel très important dans les tests de Certification Oracle. Pour être qualifié de Oracle, on doit obtenir le passport de test Oracle 1Z0-238.

1Z0-238 Démo gratuit à télécharger: http://www.pass4test.fr/1Z0-238.html

NO.1 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?
A.FND_JOBS
B.FND_PROCESSES
C.FND_INSTALL_PROCESSES
D.FND_INSTALLED_PROCESSES
Answer: C

Oracle examen   1Z0-238   certification 1Z0-238   certification 1Z0-238

NO.2 What is the default value of ?
A.APPS_
B.APPS_
C._
D._
E.APPS_
Answer: D

Oracle   1Z0-238 examen   1Z0-238   1Z0-238

NO.3 Identify two ways in which you validate the APPS schema in the Oracle Applications R12 E-Business
Suite setup. (Choose two.)
A.Run the /appsutil/scripts//advrfapp.sh script.
B.Run the AD Administration utility in noninteractive mode with the default file having
menu_option=VALIDATE_APPS.
C.Run the AD Administration utility in interactive mode, and then select Compile/Reload Applications
Database Entities menu > Compile APPS Schema option.
D. Use SQL*PLUS / @$AD_TOP/admin/sql/advrfapp.sql .
Answer: BD

Oracle   1Z0-238   certification 1Z0-238

NO.4 Identify the files that are changed when you run AutoConfig. (Choose all that apply.)
A./listener.ora
B./.env
C./admin/adconfig.txt
D./.env
E./appl/admin/.xml
Answer: ABD

certification Oracle   1Z0-238   1Z0-238 examen   1Z0-238 examen   1Z0-238

NO.5 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.
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

Oracle   1Z0-238 examen   1Z0-238   certification 1Z0-238

NO.6 You discover that you will be applying an application patch on your APPL_TOP by using AutoPatch,
which
contains a compatible feature, the prereq line.
To ensure that the automatic, prerequisite patch-checking feature operates during the application of the
patch, you must run AD Administration, Maintain Snapshot Information, then perform some key tasks, and
then AutoPatch.
Select four key Maintain Snapshot Information tasks or combination of tasks that will ensure that the
prerequisite patch-checking feature operates during the application of the patch. (Choose four.)
A.Update a current view snapshot, or create a named snapshot.
B.Export a snapshot to a file, and then delete the named snapshot.
C.Import an up-to-date snapshot from a file from a different APPL_TOP.
D.List snapshots, delete the named snapshot, and create a named snapshot.
E.Copy the existing snapshot, delete the named snapshot, and then create a named snapshot.
Answer: ACDE

Oracle   1Z0-238   1Z0-238 examen   1Z0-238   1Z0-238

NO.7 During installation, the Rapid Install process creates ______ that are used to start and stop the server
processes on the database tier.
A.JServer load balancers
B.cost-based optimizers
C.database resource managers
D.session-persistent load balancers
E.database-tier server process scripts
Answer: E

Oracle   1Z0-238   1Z0-238   1Z0-238 examen   1Z0-238 examen   certification 1Z0-238

NO.8 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:
1. Do you want to generate Oracle report objects using the current character set? (You answer Yes.)
2. Do you want to regenerate the Oracle reports PL/SQL library files? (You answer No.)
3. Do you want to regenerate Oracle reports executable files? (You answer Yes.)
4. 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.)
A.You have reports in a different language.
B.You have reports with external library files.
C.You have custom reports in a custom directory.
D.You have reports from a different module being referenced on the Inventory report menu.
Answer: B

certification Oracle   1Z0-238   1Z0-238   1Z0-238 examen   1Z0-238 examen

NO.9 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

Oracle examen   1Z0-238   1Z0-238   certification 1Z0-238   1Z0-238

NO.10 If the patch is running in Pre-Install mode, where would the patch history files be stored in Oracle
Applications R12 configured on a UNIX operating system?
A.$AD_TOP/admin
B.$APPL_TOP/admin
C.$TEMP/runInstaller
D.$APPL_TOP/admin/
E.$COMMON_TOP/admin/
Answer: D

Oracle   certification 1Z0-238   1Z0-238   1Z0-238

NO.11 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

Oracle   1Z0-238   certification 1Z0-238   certification 1Z0-238

NO.12 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:
1. Do you want to generate Oracle Forms using your current character set? (Yes)
2. Do you want to regenerate Oracle Forms PL/SQL library files? (Yes)
3. Do you want to regenerate Oracle Forms executable files? (Yes)
4. Do you want to regenerate Oracle Forms menu files? (Yes)
5. Enter the list of products, or enter 'all' [all]: (fnd)
6. Do you want to generate specific form objects for each selected product? (Yes)
7. Enter libraries and menus to generate, or enter 'all' [all]: (APPCORE.pll, the main library)
8. 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?
A.All forms in the product group fnd now render with errors.
B.All forms in the product group fnd now render without errors.
C.All forms but one in the product group fnd now render with errors.
D.All forms but one in the product group fnd now render without errors.
Answer: C

Oracle examen   1Z0-238   certification 1Z0-238   1Z0-238

NO.13 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

Oracle examen   1Z0-238 examen   1Z0-238   1Z0-238 examen   1Z0-238 examen

NO.14 What are the two occasions when it is appropriate to run "Compile APPS schema" by using the AD
Administration utility in the Oracle Applications R12 E-Business Suite environment? (Choose two.)
A.during the Oracle Applications R12 E-Business Suite upgrade process
B.when custom packages are moved to the APPS schema and need to be compiled
C.after enabling the multiple reporting currencies in the Oracle Applications R12 E-Business Suite
environment
D.after enabling the multiorganization functionality in the Oracle Applications R12 E-Business Suite
environment
E.when encountering invalid objects in the SYS and SYSTEM schemas in the Oracle Applications R12
E-Business Suite database
Answer: AB

Oracle examen   1Z0-238 examen   1Z0-238   1Z0-238 examen   certification 1Z0-238   1Z0-238

NO.15 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

Oracle   1Z0-238 examen   1Z0-238

NO.16 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

Oracle   1Z0-238   1Z0-238 examen

NO.17 AD Administration contains a utility named Maintain Snapshot Information. Which statements
correctly describe the functionality of this utility? (Choose all that apply.)
A.You can create a copy of an existing snapshot.
B.You can delete the current view snapshot.
C.You can create a list of the current view and named snapshots stored in your system.
D.You can export an existing snapshot to a file for storage or to another system.
E.You can update the current view snapshot with any changes to the snapshot since the last update.
Answer: ACDE

Oracle examen   1Z0-238   1Z0-238 examen

NO.18 Which command can be used only with a single-node installation?
A.rapidwiz -restart
B.rapidwiz -techstack
C.rapidwiz -servername
D.rapidwiz -silent -config
Answer: C

certification Oracle   1Z0-238   certification 1Z0-238   1Z0-238   1Z0-238

NO.19 You run the AD Administration utility and select the Relink Applications programs.
You answered the following questions during the utility run:
Do you wish to proceed with the relink [Yes]? (You answer Yes.)
Enter the list of products to link ("all" for all products) [all]? (You answer "ad." )
Do you want to generate specific executables for each selected product [No]? (You answer Yes.)
AD Administration can relink your Oracle Applications programs with debug
information. Oracle recommends that you do not relink your programs
with debug information unless asked to do so by Oracle Support Services.
Do you want to relink with debug information [No]? (You answer No.)
What is the next question asked by adadmin?
A.It gives you a list of all executables to choose from.
B.It gives you the list of "ad" executables to choose from.
C.It gives you the list of all executables except "ad" to choose from.
D.It asks no question. It displays the message "Review the messages above, then press [Return] to
continue."
Answer: D

Oracle   1Z0-238   1Z0-238 examen   1Z0-238   1Z0-238

NO.20 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

certification Oracle   certification 1Z0-238   certification 1Z0-238   1Z0-238   1Z0-238   1Z0-238

NO.21 Before you apply a patch, you read the readme.txt file.
One of the areas of Oracle Applications to which the patch will be applied is JAVA_TOP.
The readme file mentions that you may need to generate product JAR files in the AD Administration
utilities after the patch is applied.
When generating product JAR files, the AD Administration utility will prompt you with the question: Do you
want to force the generation of all JAR files?
What are the three occasions when you need to force the generation of all JAR files? (Choose three.)
A.after changing your digital signature
B.after updating to a new Java version
C.if you find you have missing or out-of-date JAR files
D.if you are upgrading the Oracle Developer technology stack
Answer: ABD

Oracle   1Z0-238 examen   certification 1Z0-238   1Z0-238 examen   1Z0-238 examen

NO.22 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?
A.the context file
B.the devenv.env file
C.the fndenv.env file
D.the adovars.env file
E.the adconfig.txt file
Answer: B

Oracle examen   certification 1Z0-238   1Z0-238 examen   1Z0-238 examen   certification 1Z0-238

NO.23 Identify the patch that you apply to upgrade the Oracle Applications system from the 11.5.5 version to
the 11.5.10 version.
A.diagnostic patch
B.stand-alone patch
C.maintenance pack
D.product family release update pack
Answer: C

certification Oracle   1Z0-238   1Z0-238 examen   certification 1Z0-238   1Z0-238

NO.24 What are the two possible sequences of worker status while a job is being completed by a worker?
(Choose two.)
A.Waiting => Assigned => Running => Completed
B.Assigned => Waiting => Running => Completed
C.Waiting => Assigned => Running => Failed => Fixed, Restart => Restarted => Completed
D.Assigned => Waiting => Running => Failed => Fixed, Restart => Restarted => Completed
E.Waiting => Assigned => Running => Failed => Fixed, Restart => Restarted => Running => Completed
Answer: AC

Oracle   1Z0-238   certification 1Z0-238

NO.25 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?
A.Patch Filters
B.Patch Impact Analysis
C.Recommended Patches
D.Patch Information Bundle
Answer: B

Oracle   1Z0-238 examen   1Z0-238

NO.26 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.)
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

certification Oracle   1Z0-238 examen   certification 1Z0-238   1Z0-238 examen   1Z0-238

NO.27 While working with Web forms an application user sometimes comes across a performance issue. The
initial screen takes too long to appear with the Web form screen, showing the status "Downloading JAR
files..." for a long time.
Identify the reasons for this. (Choose two.)
A.It always takes time to load the Web forms.
B.An older version of Sun J2SE plug-in is installed on the Desktop tier.
C.JAR files for the Forms client applet are downloaded automatically the first time it is used.
D.The browser will automatically retrieve new JAR files if they have changed on the application tier.
E.The Internet Explorer browser security level should be set as "Low" for the zone that contains the
Oracle Application Release 12 Web pages.
Answer: CD

Oracle   1Z0-238 examen   1Z0-238   1Z0-238   certification 1Z0-238

NO.28 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
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

Oracle examen   1Z0-238   1Z0-238 examen   certification 1Z0-238   1Z0-238 examen

NO.29 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

Oracle examen   1Z0-238   certification 1Z0-238   1Z0-238   1Z0-238

NO.30 As part of the cloning process, the Applications DBA needs to copy the application tier file system to the
target system.
Which step is NOT a part of this process?
A.Shut down the application tier server processes.
B.Log on to the target system application tier nodes as the oracle user.
C.Copy the APPL_TOP directory from the source node to the target node.
D.Copy the directory from the source node to the target node.
E.Copy the directory from the source node to the target node.
F.Copy the directory from the source node to the target node.
G.Copy the <806 ORACLE_HOME> directory from the source node to the target node.
Answer: B

Oracle examen   1Z0-238 examen   1Z0-238

Aujourd'hui, c'est une société pleine de gens talentueux, la meilleure façon de suivre et assurer la place dans votre carrière est de s'améliorer sans arrêt. Si vous n'augmentez pas dans votre carrière, vous êtes juste sous-développé parce que les autres sont meilleurs que vous. Pour éviter ce cas, vous devez vous former successivement.

Pass4Test offre de Oracle 1Z0-054 matériaux d'essai

Aujoud'hui, dans cette indutrie IT de plus en plus concurrentiel, le Certificat de Oracle 1Z0-054 peut bien prouver que vous avez une bonne concurrence et une space professionnelle plus grande à atteindre. Dans le site Pass4Test, vous pouvez trouver un outil de se former très pratique. Nos IT experts vous offrent les Q&As précises et détaillées pour faciliter votre cours de préparer le test Oracle 1Z0-054 qui vous amenera le succès du test Oracle 1Z0-054, au lieu de traivailler avec peine et sans résultat.

Les experts de Pass4Test ont fait sortir un nouveau guide d'étude de Certification Oracle 1Z0-054, avec ce guide d'étude, réussir ce test a devenu une chose pas difficile. Pass4Test vous permet à réussir 100% le test Oracle 1Z0-054 à la première fois. Les questions et réponses vont apparaître dans le test réel. Pass4Test peut vous donner une Q&A plus complète une fois que vous choisissez nous. D'ailleurs, la mise à jour gratuite pendant un an est aussi disponible pour vous.

Pass4Test, où vous pouvez trouver les conseils et les documentations de test Certification Oracle 1Z0-054, est un siteweb remarquable offrant les données à préparer le test IT. Les documentations partiels et les mis en nouveau sont offerts gratuitement dans le site de Pass4Test. D'ailleurs, nos experts profitent de leurs expériences et leurs efforts à lancer sans arrêts les Q&A plus proches au test réel. Vous allez passer votre examen plus facile.

Code d'Examen: 1Z0-054

Nom d'Examen: Oracle (Oracle Database 11g: Performance Tuning)

Questions et réponses: 192 Q&As

Vous pouvez s'exercer en Internet avec le démo gratuit. Vous allez découvrir que la Q&A de Pass4Test est laquelle le plus complète. C'est ce que vous voulez.

Dans ce monde d'informatique, l'industrie IT est suivi par de plus en plus de ges. Dans ce domaine demandant beaucoup de techniques, il faut des Certificat à se preuver les techniques professionnelle. Les Certificats IT sont improtant pour un interviewé pendant un entretien. C'est pas facile à passer le test Oracle 1Z0-054, donc c'est pourquoi beaucoup de professionnels qui choisissent ce Certificat pour se preuver.

La grande couverture, la bonne qualité et la haute précision permettent le Pass4Test à avancer les autre sites web. Donc le Pass4Test est le meilleur choix et aussi l'assurance pour le succès de test Oracle 1Z0-054.

1Z0-054 Démo gratuit à télécharger: http://www.pass4test.fr/1Z0-054.html

NO.1 Which three factors influence the optimizer's behavior while choosing an optimization approach and
goal for a SQL statement? (Choose three.)
A.parsing of a SQL statement
B.operating system (OS) statistics
C.object statistics in the data dictionary
D.the OPTIMIZER_MODE initialization parameter
E.optimizer SQL hints for changing the query optimizer goal
ANSWER: CDE

Oracle   1Z0-054   certification 1Z0-054   1Z0-054 examen   1Z0-054   1Z0-054 examen

NO.2 You are working on a decision support system (DSS). The index is available on the COUNTRY_ID
column of the CUSTOMERS table.
View the Exhibit and examine the parameter settings and the query execution plan.
Why is the query using a full table scan instead of an index scan?
A. because the histogram statistics for the COUNTRY_ID column are not updated
B. because the index statistics for the index on the COUNTRY_ID column are not current
C. because the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a higher value
D. because the optimizer predicts that most of the blocks in the table are accessed. Therefore, it uses a
full table scan, even though indexes are available.
ANSWER: D

Oracle   1Z0-054   1Z0-054 examen

NO.3 View the Exhibit exhibit1 to examine the series of SQL commands and parameter settings.
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline.
The first plan (in red) is created when OPTIMIZER_MODE is set to ALL_ROWS and the second plan (in
blue) is created when OPTIMIZER_MODE is set to FIRST_ROWS.
Which SQL plan baseline would be used if the SQL query in exhibit1 is executed again when the value of
OPTIMIZER_MODE is set to FIRST_ROWS?
A. the second plan, because it is a fixed plan
B. the first plan, because it is an accepted plan
C. the second plan, because it is the latest generated plan in FIRST_ROW mode
D. A new plan, because the second plan in FIRST_ROW mode is not an accepted plan
ANSWER: B

certification Oracle   certification 1Z0-054   1Z0-054   1Z0-054 examen   certification 1Z0-054

NO.4 The columns CUST_CITY, CUST_STATE_PROVINCE, and COUNTRY_ID are frequently used
together in the WHERE clause of the queries. The CUSTOMERS table is a big table with 20 GB of data.
You notice that the selectivity for these three columns varies from the selectivity that the optimizer
calculates.
What would you recommend to influence the selectivity calculated by the optimizer?
A. creating function-based indexes by concatenating all the columns
B. updating histogram statistics for these columns by using the DBMS_STATS.GATHER_TABLE_STATS
procedure
C. using the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and create
index on the virtual column
D. using the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and the
DBMS_STATS.GATHER_TABLE_STATS procedure to collect statistics on the virtual column
ANSWER: D

Oracle   1Z0-054   1Z0-054   1Z0-054

NO.5 After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the
SPA output. Identify the two actions that you would suggest for these regressed SQL statements.
(Choose two.)
A.Running SQL Access Advisor
B.Adding them to SQL Plan Baseline
C.Submitting them to SQL Tuning Advisor
D.Running Automatic Database Diagnostic Monitor (ADDM)
ANSWER: BC

Oracle   1Z0-054 examen   1Z0-054   1Z0-054   1Z0-054

NO.6 Examine the initialization parameter values for the instance given below:
NAME TYPE VALUE
------------------------------------ ----------- ------------------
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 11.1.0.6
optimizer_index_caching integer 0
optimizer_index_cost_adj integer 100
optimizer_mode string ALL_ROWS
db_file_multiblock_read_count integer 64
You notice that the one of the queries is using a full table scan (view Exhibit1) instead of index unique
scan (view Exhibit2). The index is present on the column that is accessed in the WHERE clause of the
query. The cost for a full table scan is more than that for an index unique scan.
Why would the optimizer choose full table scan over index unique scan? (Choose all that apply.)
A. The OPTIMIZER_INDEX_COST_ADJ initialization parameter is set to a low value.
B. The OPTIMIZER_INDEX_COST_ADJ initialization parameter is set to a high value.
C. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a low value.
D. The statistics for the table and all the indexes associated with the table are not current.
ANSWER: BD

Oracle   1Z0-054   certification 1Z0-054   1Z0-054

NO.7 You are working on an online transaction processing (OLTP) system. You detected free buffer waits
events for your database instance running in a machine that has multiple CPUs. You increased the
database buffer cache size as the first step. After a few hours of work on the database, further
investigation shows that the same event is being recorded.
What would be your next step to avoid this event in future?
A. Decrease the value of the DBWR_IO_SLAVES parameter.
B. Set the USE_INDIRECT_DATA_BUFFERS parameter to TRUE.
C. Increase the value of the DB_WRITER_PROCESSES parameter.
D. Increase the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter.
ANSWER: C

Oracle examen   certification 1Z0-054   1Z0-054 examen   certification 1Z0-054   1Z0-054

NO.8 Identify two correct statements about the Active Session History (ASH) data. (Choose two.)
A.A part of SGA memory is used to store ASH data as rolling buffer.
B.The ASH data can be analyzed between any two small time intervals.
C.All ASH data in memory are flushed to disk by MMON in every 3 seconds.
D.All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.
ANSWER: AB

Oracle examen   1Z0-054 examen   1Z0-054   1Z0-054   1Z0-054

NO.9 View Exhibit1 to examine the description of the CUSTOMERS table.
You observed that optimizer selectivity is not accurate when the CUST_STATE_PROVINCE and
COUNTRY_ID columns are used together in the WHERE clause of a query.
View Exhibit2 to examine the query execution plan and the commands executed to gather the statistics.
The optimizer predicts that 20 rows will be processed rather than the 3,341 rows, which is the actual
number of rows returned from the table.
What can you do to make the optimizer detect the actual number of rows?
A. Set the STATISTICS_LEVEL parameter to ALL.
B. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
C. Create extended statistics for the CUST_STATE_PROVINCE and COUNTRY_ID columns.
D. Increase the STALE_PERCENT value for the CUSTOMERS table by using the
DBMS_STATS.SET_TABLE_PREFS procedure.
ANSWER: C

Oracle   1Z0-054   1Z0-054   1Z0-054   1Z0-054

NO.10 You observed that some of the queries are performing poorly on the SALES_RECORDS table in your
database.
On further investigation, you find that at the end of each day the contents of the SALES_RECORDS table
are transferred to the SALES table and deleted from the SALES_RECORDS table. The deleted
operations cause the table to be sparsely populated.
You decided to use the ALTER TABLE...SHRINK SPACE COMPACT command to shrink the table.
Why would you choose this method? (Choose all that apply.)
A. because it can be used during peak hours
B. because it avoids unnecessary cursor invalidation
C. because it adjusts the high-water mark (HWM) immediately
D. because you have long-running queries that might span the shrink operation
E. because it does not allow any data manipulation language (DML) operations, thereby making the
shrink
operation faster
ANSWER: ABD

Oracle examen   1Z0-054   1Z0-054 examen   1Z0-054 examen

NO.11 View Exhibit1 to examine the description of the CUSTOMERS table.
The CUSTOMERS table has been updated heavily today. In a frequently used SQL statement, you notice
that estimated rows and the actual number of rows fetched differ greatly. The COUNTRY_ID column has
an index.
View Exhibit2 and examine the query execution plan.
What would you recommend to improve the optimizer's estimation?
A. setting the STATISTICS_LEVEL parameter to ALL
B. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE
C. creating extended statistics for the CUST_LAST_NAME, CUST_ID, and CUST_TOTAL columns
D. updating the statistics for the CUSTOMERS table by using the
DBMS_STATS.GATHER_TABLE_STATS
procedure
ANSWER: D

Oracle   1Z0-054   1Z0-054 examen   1Z0-054   1Z0-054

NO.12 You are working on a development database that was upgraded to Oracle Database 11g from Oracle
Database 9i. An ADDM finding in this database says that the shared pool is inadequately sized, as shown
in the Exhibit.
You diagnosed that this is due to different kinds of workloads and this occurs only during peak hours. You
tried to resize this by shrinking the database buffer cache but that caused inadequate buffer cache
problems. The following are the related parameter settings:
SQL> show parameter sga
NAME TYPE VALUE
------------------------------ --------------- -----------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 300M
sga_target big integer 0
SQL> show parameter target
NAME TYPE VALUE
------------------------------ --------------- -----------------
.....
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
pga_aggregate_target big integer 100M
sga_target big integer 0
You want to balance the memory between the System Global Area (SGA) components within SGA
without affecting the size of the Program Global Area (PGA).
Which action would solve this problem?
A. Set the SGA_TARGET parameter to 300M.
B. Set the SGA_MAX_SIZE parameter to 400M.
C. Set the MEMORY_TARGET parameter to 100M.
D. Set the MEMORY_MAX_TARGET parameter to 300M.
ANSWER: A

Oracle   1Z0-054 examen   1Z0-054   1Z0-054 examen   1Z0-054

NO.13 A batch workload that historically completed in the maintenance window between 10:00 PM and
midnight is currently showing poor performance and completing at 2 AM.
To help in the diagnosis of the performance degradation, the senior DBA in your organization asks you to
execute the awrddrpt.sql script to produce a Compare Periods report.
Which two statements are true about the report produced by this script? (Choose two.)
A. It is refreshed automatically based on the moving window baseline.
B. It compares details between any two selected time periods of the same duration.
C. It normalizes the statistics by the amount of time spent on the database for each time period.
D. It compares details between two consecutive time periods of the same or different durations and is
refreshed every 60 minutes.
ANSWER: BC

Oracle   1Z0-054 examen   1Z0-054   1Z0-054

NO.14 You plan to use adaptive thresholds as part of the performance tuning activity. You decide to increase
the window size of the default moving window baseline for all metric observations and comparisons in
your database. The following error occurs when you try to increase the window size through Enterprise
Manager:
Failed to commit: ORA-13541: system moving window baseline size (1296000) greater than retention
(1036800) ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 601 ORA-06512: at line 2
Which action would allow you to perform the preceding task successfully?
A. increasing the flashback retention period
B. increasing the retention period for SQL Management Base
C. increasing the undo retention period for the database instance
D. increasing the Automatic Workload Repository (AWR) retention period
ANSWER: D

certification Oracle   1Z0-054   1Z0-054 examen   1Z0-054 examen

NO.15 A user in a session executed the following SQL statement to set the optimizer mode:
ALTER SESSION SET OPTIMIZER_MODE = ALL_ROWS
What impact would it have on the goal of the optimizer for that session? (Choose all that apply.)
A. Statement level OPTIMIZER_MODE hints take precedence over the session-level setting.
B. The OPTIMIZER_MODE parameter set at instance level takes precedence over the session-level
value.
C. The optimizer uses a cost-based approach, regardless of the presence of statistics; it optimizes with a
goal of best response time.
D. The optimizer uses a cost-based approach for all SQL statements in the session, regardless of the
presence of statistics; it optimizes with a goal of best throughput.
ANSWER: AD

Oracle examen   1Z0-054 examen   certification 1Z0-054   1Z0-054

NO.16 You are working on an online transaction processing (OLTP) system. By day most of the application
users perform queries accessing the most recently added or modified rows. The applications have most
of the queries based on multiple tables. But at night, some batch processing is also done.
Which two actions would you recommend to choose a goal for the optimizer based on the needs of your
application? (Choose two.)
A.setting the OPTIMIZER_MODE parameter to ALL_ROWS at the instance level
B.setting the OPTIMIZER_MODE parameter to FIRST_ROWS_n at the instance level
C.asking the developer to add a hint /*ALL_ROWS*/ in the long-running batch processing queries
D.asking the developer to add a hint /*FIRST_ROWS_n*/ in the long-running batch processing queries
ANSWER: BC

Oracle examen   certification 1Z0-054   1Z0-054

NO.17 Examine the initialization parameter values for the instance given below:
NAME TYPE VALUE
------------------------------------ ----------- ------------------
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 11.1.0.6
optimizer_index_caching integer 0
optimizer_index_cost_adj integer 100
optimizer_mode string ALL_ROWS
db_file_multiblock_read_count integer 64
The index created on the column used in the WHERE clause of the query. You notice that the query is not
using the index. Instead of an index scan, a full table scan is used.
View the Exhibit and examine the autotrace output for a query.
What could be the reason for it? (Choose all that apply.)
A. The OPTIMIZER_INDEX_COST_ADJ initialization parameter has a low value.
B. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter has a low value.
C. The statistics for the table and all the indexes associated with the table are not current.
D. The table has less than DB_FILE_MULTIBLOCK_READ_COUNT blocks under the high-water mark.
ANSWER: CD

certification Oracle   1Z0-054 examen   1Z0-054

NO.18 You work as a DBA for a company and you have the responsibility of managing one of its online
transaction processing (OLTP) systems. The database encountered performance-related problems and
you generated an Automatic Workload Repository (AWR) report to investigate it further.
View the Exhibits and examine the AWR report.
What could be the problem in this database?
A.Java pool is not configured.
B.The CPU in the system is slow.
C.The shared pool size is inadequate.
D.The database buffer cache is inadequate.
E.The OPEN_CURSORS parameter is set to a small value.
ANSWER: C

Oracle examen   1Z0-054   certification 1Z0-054

NO.19 View Exhibit1 and examine the indexes on the CUSTOMERS table.
The statistics for the CUSTOMERS table have been updated recently by using the following command:
SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS('SH','CUSTOMERS',method_opt=>'FOR ALL
INDEXED COLUMNS SIZE AUTO');
View Exhibit2 to examine a query plan. Even though the index is present on the COUNTRY_ID and
CUST_GENDER columns, the query uses a full table scan. What could be the reason?
A. because the histogram statistics for the COUNTRY_ID column are not updated
B. because the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a high value
C. because the optimizer calculates the cost of accessing blocks by using a full table scan to be less as
compared to index scans, even though indexes are available
D. because indexes on CUST_GENDER and COUNTRY_ID columns are of different types, the index on
the CUST_GENDER column is bitmap index, and on COUNTRY_ID columns is btree index.
ANSWER: C

Oracle examen   1Z0-054   1Z0-054 examen   1Z0-054   1Z0-054

NO.20 View the Exhibit and examine a portion of the output obtained from the following query:
SQL> SELECT * FROM v$sys_time_model;
Select three correct interpretations of the time model statistics. (Choose three.)
A. DB time includes the wait time of all the nonidle and idle user sessions.
B. SQL execute elapsed time includes the time spent in performing fetches of query results.
C. DB CPU includes the CPU time spent on database user-level calls and background CPU time.
D. SQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed time.
E. DB time includes the connection management call elapsed time excluding the background process
time.
ANSWER: BDE

certification Oracle   1Z0-054 examen   1Z0-054   certification 1Z0-054   1Z0-054   1Z0-054

Pass4Test est un site web qui vous donne plus de chances à passer le test de Certification Oracle 1Z0-054. Le résultat de recherche sortis par les experts de Pass4Test peut assurer que ce sera vous ensuite qui réussirez le test Oracle 1Z0-054. Choisissez Pass4Test, choisissez le succès. L'outil de se former de Pass4Test est bien efficace. Parmi les gens qui ont déjà passé le test, la majorité a préparé le test avec la Q&A de Pass4Test.

Oracle 1Z0-516, de formation et d'essai

Le guide d'étude sorti de Pass4Test comprend les expériences résumées par nos experts, les matériaux et les Q&As à propos de test Certification Oracle 1Z0-516. Notre bonne réputation dans l'industrie IT sera une assurance 100% à réussir le test Oracle 1Z0-516. Afin de vous permettre de choisir Pass4Test, vous pouvez télécharger gratuitement le démo de Q&A tout d'abord.

Tant que vous avez besion de participer l'examen, nous pouvons toujours mettre à jour de matériaux à propos de test Certification Oracle 1Z0-516. Le guide d'étude de Pass4Test comprend les excercices de Oracle 1Z0-516 et la Q&A qui peut vous permetrre à réussir 100% le test Oracle 1Z0-516. Vous pouvez faire une meilleure préparation pour le test. D'ailleurs, la mise à jour pendant un an après vendre est gratuite pour vous.

La Q&A Oracle 1Z0-516 de Pass4Test est liée bien avec le test réel de Oracle 1Z0-516. La mise à jour gratuite est pour vous après vendre. Nous avons la capacité à vous assurer le succès de test Oracle 1Z0-516 100%. Si malheureusement vous échouerez le test, votre argent sera tout rendu.

Pass4Test est un site à offrir particulièrement la Q&A Oracle 1Z0-516, vous pouvez non seulement aprrendre plus de connaissances professionnelles, et encore obtenir le Passport de Certification Oracle 1Z0-516, et trouver un meilleur travail plus tard. Les documentations offertes par Pass4Test sont tout étudiés par les experts de Pass4Test en profitant leurs connaissances et expériences, ces Q&As sont impresionnées par une bonne qualité. Il ne faut que choisir Pass4Test, vous pouvez non seulement passer le test Oracle 1Z0-516 et même se renforcer vos connaissances professionnelles IT.

Pass4Test possède une grande équipe composée des experts IT qui travaillent dur avec leurs riches expériences et connaissances pour produire un bon outil de formation. Selon les anciens test, le test simulation de Pass4Test est bien lié avec le test réel. Pass4Test peut vous assurer à réussir le test. Maintenant vous ajoutez votre outil de formation au panier, et votre rêve réalisera bien tôt.

Code d'Examen: 1Z0-516

Nom d'Examen: Oracle (Oracle EBS R12.1 General Ledger Essentials)

Questions et réponses: 773 Q&As

Vous n'avez besoin que de faire les exercices à propos du test Oracle 1Z0-516 offertes par Pass4Test, vous pouvez réussir le test sans aucune doute. Et ensuite, vous aurez plus de chances de promouvoir avec le Certificat. Si vous ajoutez le produit au panier, nous vous offrirons le service 24h en ligne.

1Z0-516 Démo gratuit à télécharger: http://www.pass4test.fr/1Z0-516.html

NO.1 Which report would provide information about the processing type (parallel or sequential) that may be
defined for reports?
A. Report Detail Listing
B. Content Set Summary Listing
C. Row Set Summary Listing
Answer: B

Oracle   1Z0-516 examen   1Z0-516   1Z0-516

NO.2 ABC.com has offices around the world, spread across different legal entities. ABC.com is
implementing Oracle General Ledger. Its accounting department wants to know how to reduce the burden
of elimination entries. What do you recommend?
A. Mass Allocation
B. ADI Journals
C. Recurring Journals
D. Summary Journals
E. Intercompany Journals
Answer: C

Oracle   1Z0-516 examen   1Z0-516   1Z0-516 examen   1Z0-516 examen

NO.3 ABC.com has many Financial Statement Generator reports created to produce Profit & Loss
statements and Balance Sheet reports. Occasionally ABC.com has a need to run a report that is slightly
different than the standard ones that are already created. Which two types of changes could XYZ make
using the Row Order feature? (Choose two.)
A. display segment values and descriptions
B. add a new calculation
C. change how rounding options are performed
D. sort based on column values
Answer: A,D

Oracle   1Z0-516 examen   1Z0-516 examen

NO.4 After you determine your needs and organize your summary account structure, which General Ledger
tools can you use to define parent-child values and rollup groups?
A. Analyzer Hierarchies, Account Hierarchy Manager or Account Hierarchy Editor (provided Applications
Desktop Integrator is installed).
B. Mass Maintenance, Analyzer Hierarchies, or Account Hierarchy Manager
C. Mass Maintenance or Account Hierarchy Manager
D. Mass Maintenance or Account Hierarchy Editor (provided Applications Desktop Integrator is installed).
E. Account Hierarchy Manager or Account Hierarchy Editor (provided Applications Desktop Integrator is
installed).
Answer: E

Oracle examen   certification 1Z0-516   certification 1Z0-516   1Z0-516

NO.5 Identify the two setups that control the defaulting of Tax Information on a journal entry. (Choose two.)
A. Set of Books
B. Journal categories
C. Account
Answer: A,C

Oracle   1Z0-516 examen   certification 1Z0-516   certification 1Z0-516

NO.6 After creating a number of Financial Statement Generator reports, ABC.com wants a list of the
definitions for one specific account. Which report should be run to provide that information?
A. FSG: Content Set Detail Listing
B. FSG: Report Detail Listing
C. FSG: Where Used Report
Answer: C

Oracle examen   certification 1Z0-516   1Z0-516 examen   1Z0-516

NO.7 What are the possible posting options in Oracle General Ledger?
A. Post Journal batches individually Post multiple batches Use AutoPost
B. Post Journal batches individually Post multiple journals
C. Post multiple batches
Post batches that meet specific criteria by submitting a concurrent request
D. Post Journal batches individually Post multiple batches Post batches that meet specific criteria by
submitting a concurrent request and using Journal Approval
Answer: A

Oracle   1Z0-516   1Z0-516   1Z0-516

NO.8 ABC.com, the GL accountant, comes to you and says that he has defined the budget, and budget
amounts have been entered and approved by management. After approval he wants his assistant
accountants to NOT be able to update this budget. What is your response?
A. If the client wants to do this, then customization of workflow is the only option.
B. If the client wants to do this, then the budget status should be Current.
C. If the client wants to do this, then the budget status should be Frozen.
D. Oracle GL budget functionality cannot satisfy this requirement.
Answer: C

Oracle   1Z0-516   1Z0-516   1Z0-516

NO.9 Which two are true statements regarding elimination? (Choose two.)
A. You must specify an elimination company in the Elimination Sets window.
B. You can define balancing options for eliminating entries.
C. You can define an elimination set to contain a single elimination entry.
D. Currency is an optional component when defining an elimination set.
Answer: A,D

Oracle   1Z0-516 examen   1Z0-516   1Z0-516

NO.10 ABC.com wants to define a consolidation process for its enterprise.
It has two sets of books: Set of Books A and Set of Books B.
Both sets of books will use Oracle General Ledger.
Set of Books A has three companies with the same calendar and chart of accounts as Set of Books B. Set
of Books A has USD as its currency.
Set of Books B has four companies with the same chart of accounts and calendar as Set of Books
A. Set of Books B has GPD as its currency. Select the consolidation method.
A. Interface Data Transformer
B. Global Intercompany System
C. Oracle Financial Analyzer
D. Financial Statement Generator
Answer: D

Oracle   1Z0-516 examen   1Z0-516   1Z0-516   1Z0-516

NO.11 During a period, several preapproved batches of miscellaneous transactions were entered and
released. The project manager informs you that he is unable to view the accounting in the expenditure
inquiry form. Which process was likely omitted?
A. streamline costs
B. distribute costs
C. interface costs
D. tieback costs
Answer: B

Oracle   certification 1Z0-516   1Z0-516 examen

NO.12 Oracle General Ledger provides a variety of ways to get information from reports and queries. What
can you do using standard reports that you cannot do using on-line queries? (Choose all that apply.)
A. group reports into report sets
B. review T-Accounts
C. view non-financial information
Answer: A,C

Oracle   1Z0-516 examen   1Z0-516   1Z0-516   1Z0-516

NO.13 Which statement is correct about the differences between the functionalities of parent accounts and
summary accounts?
A. Summary accounts speed up the posting process, whereas parent accounts require additional time for
the posting process.
B. Summary accounts use the summing segment type for mass allocations, whereas parent accounts use
the looping segment type.
C. Summary accounts cannot be used in budget formulas, whereas parent accounts can be used in
budget formulas.
D. Summary accounts balances can be viewed in the Account Inquiry form, whereas parent accounts
balances cannot be viewed in that form.
E. Summary accounts slow down the generation of Financial Statement Generators, whereas parent
accounts will help generate quicker results.
Answer: D

Oracle examen   1Z0-516   1Z0-516   1Z0-516 examen

NO.14 ABC.com is a $2 million company operating from the U.S., and has one set of books. It is spinning off
from its parent company and will be operating as an independent company. It is considering implementing
Oracle Financials but wants the product to work exactly in the same way as its legacy systems from its
parent company. What considerations should be presented to ABC in order for it to make a well-informed
decision? (Choose all that apply.)
A. Patching is simplified on a non-customized Oracle implementation.
B. Adding customizations to replicate the legacy system could increase cost of future upgrades.
C. Integration issues between modules are reduced when there are no customizations.
D. No information can be interfaced from the legacy system to the product.
Answer: A,B,C

Oracle examen   1Z0-516   1Z0-516 examen   1Z0-516

NO.15 To review available Financial Statement Generator elements, which two reports would be helpful?
(Choose two.)
A. Column Set Detail Listing, Report Detail Listing
B. Content Set Detail Listing, Report Set Detail Listing
C. Column Set Summary Listing, Row Set Detail Listing
D. Content Set Detail listing, Chart of Accounts - Rollup Detail Listing
Answer: C

Oracle   1Z0-516   certification 1Z0-516   1Z0-516   certification 1Z0-516   1Z0-516

NO.16 You are implementing Oracle General Ledger at ABC.coms site. ABC.com is based in the US but has a
global presence in many countries worldwide, and has transactions in multiple currencies.
The implementation team decides that GL multi currency setup will be part of the implementation.
The GL accountant approaches you to discuss multiple reporting currencies (MRC); he wants to
implement MRC and link the primary set of books with the reporting set of books. Additionally, he says
that the primary and reporting sets of books all have different calendars but share the same chart of
accounts. What response do you provide?
A. The primary and reporting set of books must share the same calendar and chart of accounts.
B. There is no problem in satisfying this requirement.
C. The primary and reporting set of books must share the same currency and chart of accounts.
D. The primary and reporting set of books must share the same calendar, currency and chart of
accounts.
Answer: A

Oracle   1Z0-516   certification 1Z0-516

NO.17 All of the manual journal entries are defaulting to a non current period. Which step was omitted from
the accounting cycle?
A. Post Journal Entries
B. Update Period
C. Consolidate Financials
D. Translated Foreign Balances
E. Reverse Journal Entries
Answer: B

Oracle   1Z0-516   1Z0-516   1Z0-516 examen   certification 1Z0-516   1Z0-516 examen

NO.18 .ABC.com has two diverse business operations in retail stores and services. It has five legal entities in
Canada and five in the United States for both operations. The fiscal year end is the same for all the legal
entities with 12 monthly periods. However, ABC.com wants to use a 4-5-4 accounting calendar for its retail
operations and a calendar-month accounting calendar for the services operations. ABC.com also wants to
use a single chart of accounts structure. Which five items must ABC.com define to meet the minimum
setup steps that are required for the sets of books for all legal entities? (Choose five.)
A. two accounting calendars
B. four sets of books
C. three sets of books
D. two sets of books
E. chart of accounts structure
F. period types or use seeded ones
G. one accounting calendar
H. enable seeded CAD and USD currencies
I. account combinations
Answer: A,B,E,F,H

Oracle examen   1Z0-516   1Z0-516   certification 1Z0-516

NO.19 ABC.com has offices around the world, spread across different legal entities. ABC.com is
implementing Oracle General Ledger. Its accounting department wants to know how to reduce the burden
of elimination entries. What do you recommend?
A. Summary Journals
B. ADI Journals
C. Intercompany Journals
D. Recurring Journals
E. Mass Allocation
Answer: D

certification Oracle   1Z0-516   1Z0-516 examen

NO.20 For each subledger there should be one _____.
A. Account Type
B. Journal Category
C. Journal Type
D. Journal Source
Answer: D

certification Oracle   1Z0-516   certification 1Z0-516   1Z0-516   certification 1Z0-516

NO.21 You are implementing Oracle General Ledger at a ABC.com site. ABC.com is based in the US but has
a presence in many countries worldwide, and has transactions in multiple currencies. The implementation
team decides that GL multi currency setup will be part of the implementation. John, a junior consultant
helping you in the implementation effort, comes to you and says that he is testing the system and entering
journals in US dollars, yen and euros. He says that he is able to enter the journals in US dollars and euros,
but cannot enter the journals in Japanese yen. What possible explanation can you provide to John for
this?
A. Workflow needs to be customized for journals to be entered in yen.
B. Yen currency has not been enabled.
C. Daily rates have not been entered for yen.
D. Rate types have not been defined for yen.
Answer: B

Oracle   certification 1Z0-516   1Z0-516 examen   1Z0-516 examen

NO.22 Jason, the corporate controller of ABC.com where you are implementing Oracle General Ledger,
Accounts Payable, an Accounts Receivable, is very excited about the Global Intercompany System (GIS).
He wrote some notes from a conversation with his accounting manager about GIS. He wants you to
validate which points he has written down about GIS are true. Identify Jason's three correct points. ?
(Choose three.)
A. GIS enables intercompany transactions to be approved after transfer from AP and AR.
B. Unlike intercompany accounting within the same set of books, GIS only works between sets of books
but not within the same set of books.
C. Intercompany journals are created automatically as soon as they are approved.
D. You can set up GIS so that the sender's transactions do not need to be approved by the
receiver.
E. If a sender approves the transaction but the receiver rejects it, the transaction is recalled.
F. Each company that uses GIS must be set up as a subsidiary that is associated with a balancing
segment value.
G. You can optionally send notifications to a defined user or responsibility when an intercompany
transaction is initiated.
Answer: D,F,G

certification Oracle   1Z0-516   1Z0-516   1Z0-516   1Z0-516

NO.23 When you enter a journal, the journals in that batch _____.
A. should share the same period
B. should share both the same period and currency
C. should share the same accounting date
D. can have different periods, currencies, and accounting dates
E. should share the same currency
Answer: A

Oracle examen   1Z0-516 examen   1Z0-516 examen

NO.24 One of your ABC.com co-workers, Tim, is working to define and develop Financial Statement Generator
reports where the budget amounts and actual amounts would display on the report per period. Tim comes
to you and says that he has defined an FSG report according to the client's requirements; the actual
amounts are correctly shown, but the problem is that budget amounts are not showing up on the report.
What is your response?
A. Budget status is Frozen.
B. The budget name needs to be associated with the row set through control values.
C. There is some issue with the assignment of accounts to the budget organization.
D. The first fiscal year of the budget was never opened.
E. The last fiscal year of the budget is Closed.
Answer: B

Oracle   1Z0-516   1Z0-516 examen

NO.25 Exhibit:
You work as a DBA for ABC.com. Please study the exhibit carefully.
GL Consolidation: Preserve Journal Batching is set to Yes.
GL Consolidation: Preserve Journal Effective Date is set to Yes.
What would the result be?
A. 1, 3, 4
B. 2, 3, 4
C. 3, 4, 5
D. 5, 1, 2
E. 5, 3, 2,
Answer: A

Oracle examen   1Z0-516   1Z0-516   certification 1Z0-516

NO.26 ABC.com is a national company with five divisions that share the same set of books. Select the
statement that best describes the consolidation process for ABC Corporation.
A. Run translations, transfer data and run financial reports.
B. Run revaluation, translation, and eliminations; transfer data and run financial reports.
C. Run revaluation and translation, transfer data and run financial reports.
D. Transfer data and run financial reports.
E. Enter eliminating journals and run financial reports.
Answer: E

certification Oracle   certification 1Z0-516   certification 1Z0-516   1Z0-516   1Z0-516

NO.27 What is the effect of summary accounts on the efficiency of the posting process?
A. There is no effect, because summary accounts do not use the posting process to accumulate values.
B. Use of summary accounts decreases the efficiency of the posting process.
C. Use of summary accounts neither increases nor decreases the efficiency of the posting
process.
D. Use of summary accounts increases the efficiency of the posting process.
Answer: B

Oracle examen   1Z0-516   1Z0-516   1Z0-516   certification 1Z0-516

NO.28 The Consolidation Workbench enables you to _____, _____, and _____. (Choose three.)
A. access the State Controller
B. create consolidations sets, which launch multiple consolidations in a single step
C. create multilevel hierarchies, which you can view using the graphical Consolidation Hierarchy Viewer
D. change the chart of accounts
Answer: A,B,C

certification Oracle   certification 1Z0-516   1Z0-516

NO.29 One of ABC.com's clients wants the ability to report with Financial Statements Generator (FSG) and
perform account inquiry at the summary (business unit) level of its Cost Center segment. A business unit
is a group of cost centers and a business unit manager typically has several cost centers under his or her
responsibility. Which option will meet the client's requirements?
A. Define parent cost centers and a hierarchy of parent-child cost centers. Define Rollup Groups for the
parent cost centers, and Summary Accounts. Create FSG based on the parent cost center values or
Summary Accounts.
B. Define parent cost centers and a hierarchy of parent-child cost centers. Define Rollup Groups for the
parent cost centers. Create FSG based on the Rollup Groups.
C. Define parent cost centers and a hierarchy of parent-child cost centers. Create Summary Accounts
based on the parent cost centers. Create FSG based on the parent cost center values.
D. Define parent cost centers and a hierarchy of parent-child cost centers. Define Rollup Groups for the
parent cost centers. Create FSG based on the parent cost center values.
E. Define parent cost centers and a hierarchy of parent-child cost centers. Define Summary Accounts for
the parent cost centers. Create FSG based on the parent cost center values or Summary Accounts.
Answer: A

certification Oracle   1Z0-516 examen   1Z0-516   1Z0-516   certification 1Z0-516

NO.30 Which two statements correctly describe the translation process? (Choose two.)
A. The translation process allows you to translate only year-to-date amounts.
B. If you rerun the translation process, the process adds the additional data to the previous translated
amounts.
C. You can rerun the translation process more than once per period.
D. Translation for a subsidiary can be initiated from the parent using the State Controller Translate button.
Answer: C,D

Oracle   1Z0-516 examen   1Z0-516   certification 1Z0-516   1Z0-516   certification 1Z0-516

Dans cette société de plus en plus intense, nous vous proposons à choisir une façon de se former plus efficace : moins de temps et d'argent dépensé. Pass4Test peut vous offrir une bonne solution avec une plus grande space à développer.