Dernières Oracle 1Z0-242 examen pratique questions et réponses

Vous choisissez l'aide de Pass4Test, Pass4Test fait tous effort à vous aider à réussir le test. De plus, la mise à jour de Q&A pendant un an est gratuite pour vous. Vous n'avez plus raison à hésiter. Pass4Test est une meilleure assurance pour le succès de test Oracle 1Z0-242. Ajoutez la Q&A au panier.

Est-ce que vous vous souciez encore de réussir le test Oracle 1Z0-242? Est-ce que vous attendez plus le guide de formation plus nouveaux? Le guide de formation vient de lancer par Pass4Test peut vous donner la solution. Vous pouvez télécharger la partie de guide gratuite pour prendre un essai, et vous allez découvrir que le test n'est pas aussi dur que l'imaginer. Pass4Test vous permet à réussir 100% le test. Votre argent sera tout rendu si vous échouez le test.

Pour vous laisser savoir mieux que la Q&A Oracle 1Z0-242 produit par Pass4Test est persuadante, le démo de Q&A Oracle 1Z0-242 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-242 sans aucune doute. C'est aussi un symbole d'un meilleur demain de votre carrière.

Le test Oracle 1Z0-242 peut bien examnier les connaissances et techniques professionnelles. Pass4Test est votre raccourci amené au succès de test Oracle 1Z0-242. Chez Pass4Test, vous n'avez pas besoin de dépenser trop de temps et d'argent juste pour préparer le test Oracle 1Z0-242. Travaillez avec l'outil formation de Pass4Test visé au test, il ne vous demande que 20 heures à préparer.

Pass4Test est un bon catalyseur du succès pour les professionnels IT. Beaucoup de gens passer le test Oracle 1Z0-242 avec l'aide de l'outil formation. Les experts profitent leurs expériences riches et connaissances à faire sortir la Q&A Oracle 1Z0-242 plus nouvelle qui comprend les exercices de pratiquer et le test simulation. Vous pouvez passer le test Oracle 1Z0-242 plus facilement avec la Q&A de Pass4Test.

Code d'Examen: 1Z0-242
Nom d'Examen: Oracle (PeopleSoft Application Developer II: App Engine and Integration)
Questions et réponses: 102 Q&As

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

NO.1 A Process Scheduler process is configured to run an Application Engine program. You need to modify
the process to use parameters entered by the user at run time. Which four additional steps do you need to
take? (Choose four.)
A. Create a process type for the new process.
B. Add bind variables to the command-line parameters.
C. Write a PeopleCode program to pass the parameters.
D. Create a state record with fields to pass input parameters.
E. Create a run control page with fields to enter the input parameters.
F. Create a run control record with fields to store the input parameters.
G. Modify the Application Engine program to retrieve the input parameters.
Answer: DEFG

certification Oracle   1Z0-242   certification 1Z0-242

NO.2 How do you configure Process Scheduler to initiate an Application Engine trace for SQL and Step?
A. Add %%TRACE%% %%SQL%% %%STEP%% to the parameter list for the Process Type.
B. On the Run Control page, select the SQL Trace and Step Trace check boxes.
C. On the Process Monitor page, select the SQL Trace and Step Trace check boxes.
D. On the Process Definition Override Options page, for Parameter List, select Append and enter
-TRACE 3.
E. On the Process Definition Override Options page, for Parameter List, select Append and enter -TRACE
SQL STEP.
F. On the Process Definition Override Options page, for Parameter List, select Append and
enter %%TRACE%% %%SQL%% %%STEP%%.
Answer: D

certification Oracle   certification 1Z0-242   1Z0-242 examen

NO.3 You modify an Application Engine program to use parallel processing with temporary tables.
The Application Engine program includes this code snippet, which is part of a SQL statement that inserts
rows into a temporary table.
INSERT INTO PS_CRS_FULL_TMP
What changes do you need to make to the code so that the Application Engine program will implement
parallel processing properly?
A. No changes to the code are needed as long as the temporary table has been properly configured for
parallel processing.
B. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO PS_CRS_FULL_TMP so that the
meta-SQL resolves to the correct state record at run time.
C. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO %Table(CRS_FULL_TMP) so that
the system variables resolve to the correct syntax at run time.
D. Replace INSERT INTO PS_CRS_FULL_TMP with INSERT INTO %Table(CRS_FULL_TMP) so that
the meta-SQL resolves to the correct temporary table instance at run time.
E. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO %Temp(CRS_FULL_TMP) so that
the meta-SQL resolves to the correct syntax and temporary table instance at run time.
Answer: D

Oracle   1Z0-242   1Z0-242 examen   1Z0-242   1Z0-242 examen   1Z0-242

NO.4 An Application Engine program uses a Do Select action. What occurs when the Select statement is
executed?
A. Each row returned by the Select statement is stored in the state record. The Select statement
continues until no more rows are returned. Then, the control passes to the calling section.
B. All rows returned by the Select statement are stored in a cursor. Then, the control is passed to the
calling section.
C. All rows returned by the Select statement are stored in the state record. Then, the control is passed to
the next section in the program.
D. All rows returned by the Select statement are stored in a cursor. The first row is stored in the state
record. Then, the remaining actions in the step are processed sequentially. Thereafter, the control returns
to the Do Select to fetch another row, until no more rows are returned.
E. When a row is returned, the remaining steps in the section execute and control returns to the calling
step.
F. When a row is returned, it is stored in the state record. Then, the control is passed to the calling section.
Answer: D

Oracle   1Z0-242 examen   1Z0-242

NO.5 You want to see exactly when a PeopleCode program fires in the context of the Component Processor
flow. Which two methods will work? (Choose two.)
A. Insert a Print() statement in the program.
B. Insert a WinMessage() statement in the program.
C. Insert a MessageCatalog() statement in the program.
D. Run the PeopleCode Debugger and insert a breakpoint on the program.
E. Run the PeopleCode Debugger and select Debug, View Component Buffers.
Answer: BD

Oracle examen   1Z0-242   1Z0-242 examen   1Z0-242 examen   1Z0-242   1Z0-242 examen

NO.6 View the Exhibit.
A PeopleCode program at level 0 checks the values for Percent Available (PCT_AVAILABLE) at level 1.
Analyze this code snippet.
Local Rowset &RS_Level0, &RS_Level1;
Local Row &Row_Level0, &Row_Level1;
Local Record &Rec_TaskRsrc;
Local Field & Fld_PctAvail ;
&RS_Level0 = GetLevel0();
&Row_Level0 = &RS_Level0.GetRow(1);
&RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC);
&Row_Level1 = &RS_Level1.GetRow(1);
&Rec_TaskRsrc = &Row_Level1.GetRecord(Record.PSU_Task_RSRC);
&Fld_PctAvail = &Rec_TaskRsrc.GetField(Field.PCT_AVAILABLE);
&Pct = &Fld_PctAvail.Value;
Select the correct option.
A. The program will produce the expected results.
B. The program is missing a loop to process each row in the level 1 rowset.
C. The program is missing a loop to process each rowset in the level 1 row.
D. The program can be simplified to:
&Pct = &RS_Level0.PSU_Task_RSRC.PCT_AVAILABLE.Value;
E. This line of code is not needed:
&RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC);
F. The &RS_Level0 = GetLevel0(); function is missing the Level 0 scroll name.
Answer: B

certification Oracle   1Z0-242   1Z0-242 examen   certification 1Z0-242   1Z0-242

NO.7 An Application Engine program requires a loop that will exit after 1000 rows have been processed.
The COUNTER field in the state record is incremented in each iteration of the loop. Which option contains
code that could be used in a Do While action to test for COUNTER?
A. Do While %Bind(Counter) < 1000
B. %SELECT (COUNTER)
FROM PS_INSTALLATION
Where COUNTER < 1000
C. If %Bind(Counter) >= 1000 then
Exit;
D. %Select(COUNTER)
FROM PS_STATE_AET
Where COUNTER < 1000
E. %Select(COUNTER)
SELECT 'X'
FROM PS_INSTALLATION
WHERE %Bind(COUNTER) < 1000;
Answer: E

Oracle examen   1Z0-242   certification 1Z0-242   certification 1Z0-242

NO.8 Evaluate this PeopleCode snippet.
Local Array of Number &MyArray;
Local Any &Len, &Result;
&MyArray = CreateArray(3);
&MyArray[1] = 100;
&MyArray[2] = 200;
&MyArray[3] = 300;
&Result = &MyArray.POP();
&Len = &MyArray.LEN;
&End = &MyArray[&Len];
What are the correct values for &Result and &End?
A. &Result is 300
&End is 200
B. &Result is 300
&End is Null
C. &Result is 300
&End is 300
D. &Result is Null
&End is 300
E. &Result is 100
&End is 300
Answer: A

certification Oracle   1Z0-242 examen   1Z0-242 examen   certification 1Z0-242

NO.9 The Customer Orders page uses data from the ITEM table to perform price calculations. You decide to
write a PeopleCode program to create a stand-alone rowset that will load data from the ITEM table into
the data buffer. Select three PeopleCode statements that can be used with stand-alone rowsets. (Choose
three.)
A. &RS_Item = GetRowSet(SCROLL.ITEM);
B. &RS_Item = CreateRowSet(RECORD.ITEM);
C. &Price = &RS_Item(&i).ITEM.PRICE.Value;
D. &RS_Item.Select("Where ITEM = :1", CUST_ORDER.ITEM);
E. &RS_Item.Fill("Where CUST_TYPE = :1", CUST_ORDER.TYPE);
F. &RS_Item = ScrollSelect(1,Scroll.ITEM, Record.ITEM, ("Where CUST_TYPE = :1", CUST_ORDER.
CUST_TYPE);
Answer: BCE

Oracle examen   1Z0-242   1Z0-242

NO.10 Select three Application Engine action types that can be used to control program flow. (Choose three.)
A. Log Message
B. Call Section
C. XSLT
D. PeopleCode
E. Do While
F. Evaluate
Answer: BDE

Oracle examen   1Z0-242 examen   1Z0-242   1Z0-242   1Z0-242   1Z0-242

NO.11 The Get Student Enrollments page uses a PeopleCode program to select and display rows based on
user input. When the user clicks Refresh, FieldChange PeopleCode populates a stand-alone rowset
using a Select method. When you test the program, the new rows are appended to the previous rows
instead of replacing them. How do you fix this problem?
A. Use a work scroll instead of a stand-alone rowset.
B. Add &Rowset.Flush(); after the Select method.
C. Use an Update method instead of a Select method.
D. Add &Rowset.Flush(); before the Select method.
E. Add &Rowset.Refresh (); after the Select method.
F. Add &Rowset.Refresh(); before the Select method.
Answer: D

certification Oracle   1Z0-242   certification 1Z0-242

NO.12 View the Exhibit.
This run control page executes an Application Engine program that updates the Course table using the
parameters entered by a user.
In addition to the run control page, which three elements must be in place? (Choose three.)
A. A state record with fields to hold input parameters
B. Component variables to pass the input parameters
C. A data buffer object to retrieve the input parameters
D. Application Engine SQL to retrieve the input parameters
E. A PeopleCode record object to update the Course table
F. A Process Instance table to store run control parameters
G. A run control record with fields to store the input parameters
Answer: ADG

Oracle   certification 1Z0-242   certification 1Z0-242   1Z0-242 examen

NO.13 An Application Engine program inserts rows into PS_VENDOR.
The program encounters an error and abends (ends abnormally).
You correct the error, but now PS_VENDOR is in an unknown state.
Select the correct statement.
A. If Log File was enabled in Configuration Manager, a script file was created that you use to return the
database to its original state. After you correct the error, you can run the program again.
B. If Recover was enabled for the program, the changes to PS_VENDOR are rolled back. After you
correct the error, you can run the program again.
C. If Restart was enabled for the program, a checkpoint was saved with the last commit. After you correct
the error, you can restart the program and processing will resume from the point of the last commit.
D. If Resume was enabled in PeopleSoft Process Scheduler, the program automatically resumes
processing after the condition that caused the error is corrected.
E. If a state record was defined for the program, PS_VENDOR is restored based on parameters that were
written to the state record. Then you can restart the program using the same run control parameters.
Answer: C

Oracle   certification 1Z0-242   1Z0-242 examen   certification 1Z0-242   1Z0-242

NO.14 You add a dynamic call to an Application Engine program following these steps:
1. Add the fields AE_APPLID and AE_SECTION to the state record if they are not already present.
2. Build the state record.
3. Verify that the state record is the default state record for the Application Engine program.
4. In a PeopleCode action, use a conditional test to populate the fields AE_APPLID and AE_SECTION
with an Application Engine program name and section name, respectively.
5. Following the PeopleCode action, add a Call Section action.
Select the correct statement.
A. The Application Engine program will execute as expected.
B. Step 2 is not needed for dynamic call.
C. Step 3 is not needed.
D. Add a step after step 5 to insert a SQL action that will use the values in the state record to populate the
Program and Section fields of the Application Engine Call Section action.
E. Add a step after step 5 to select the Dynamic Call check box in the Call Section action.
F. Step 4 is wrong. The PeopleCode program should use the AESection class to issue the dynamic call.
Answer: E

certification Oracle   certification 1Z0-242   certification 1Z0-242   1Z0-242   1Z0-242

NO.15 View the Exhibit.
On the Employee Review page, you have a business rule with these requirements:
1. If Review Type is Supervisor, then the prompt for Reviewer ID returns only supervisors.
2. If Review Type is Peer or Performance, then the prompt for Reviewer ID returns all employees.
Select the three steps required to implement this business rule. (Choose three.)
A. Associate the REVIEWER_ID field with REVIEWER_VW.
B. Create REVIEWER_VW as a dynamic view of the EMPLOYEE table.
C. Add the DERIVED.EDITTABLE field to the page and make it invisible.
D. Set the prompt table edit for the REVIEWER_ID field to REVIEWER_VW.
E. Set the prompt table edit for the REVIEWER_ID field to DERIVED.%EDITTABLE.
F. Use a SQL Select statement in PeopleCode to populate the REVIEWER_VW view.
G. Use a conditional statement in PeopleCode to populate the DERIVED.EDITTABLE field.
Answer: CEG

Oracle examen   1Z0-242   1Z0-242   1Z0-242   certification 1Z0-242

NO.16 View the Exhibit.
Your client is upgrading its purchasing application to use object-oriented PeopleCode to incorporate the
benefits of application classes.
The PeopleCode for the Purchase Order application is now encapsulated in an Application Package
called PSU_PO. The assign_order_nbr function is now ORDER_NBR, a method of the ORDER class.
You are tasked with modifying this program to call the new ORDER_NBR method.
Which four PeopleCode statements will you use in the new program? (Choose four.)
A. Class PSU_PO:ORDER;
B. &New.ORDER_NBR(PSU_PO_HDR.ORDER_NBR);
C. Import PSU_PO:ORDER;
D. Declare method PSU_PO:ORDER:ORDER_NBR;
E. &New = Create Order();
F. Local ORDER &New;
G. Method ORDER_NBR (&ORDER_NBR As Field out);
Answer: BCEF

Oracle examen   1Z0-242   1Z0-242   certification 1Z0-242   1Z0-242   1Z0-242 examen

NO.17 Examine the join in this Select statement:
SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE A.TASK = B.TASK
AND A.RESOURCE = B.RESOURCE
Select the equivalent Select statement.
A. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Join(A.TASK, B.RESOURCE)
B. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Common(PROJECT A, EFFORT B)
C. SELECT A.TASK , B.EFFORT_AMT
FROM %Common(KEYS, PROJECT A, EFFORT B)
D. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Join(COMMON_KEYS, TASK A, EFFORT_AMT B)
E. SELECT A.TASK , B.EFFORT_AMT
FROM %Join(COMMON_KEYS, PROJECT A, EFFORT B)
Answer: E

Oracle examen   1Z0-242   1Z0-242 examen   certification 1Z0-242

NO.18 You want to examine the component buffer for the Customer Orders (PSU_CUST_ORDER )
component. Which four steps are necessary? (Choose four.)
A. Start the PeopleCode Debugger and set a breakpoint.
B. Access the Structure view on the PSU_CUST_ORDER component.
C. In Application Designer, select Component Buffers.
D. Access the Customer Orders component in the browser and trigger the breakpoint. Return to
PeopleSoft Application Designer when the breakpoint triggers.
E. Open, or create, a PeopleCode program that will execute while Customer Orders is running in the
browser.
F. Drill down through the component hierarchy in the Structure view on the PSU_CUST_ORDER
component.
G. In Application Designer, select Debug, View Component Buffers.
Answer: ADEG

Oracle examen   1Z0-242   1Z0-242   1Z0-242

NO.19 View the Exhibit.
An object-oriented PeopleCode program traverses the data buffer to get the value for Session Number
(SESSION_NBR) in the Session Details record (PSU_CRS_SESSN) on the Course Sessions page.
The program uses a built-in function to instantiate the Level 0 object, then uses object methods to
instantiate the remaining data buffer objects.
Select the option that represents the order in which the program instantiates the data buffer objects.
A. &Row_Level0, &Row _Level1, &Record, &Field
B. &Rowset_Level0, &Row_Level1, &Record, &Field
C. &Rowset_Level0, &Rowset_Level1, &Row_Level1, &Record, &Field
D. &Rowset_Level0, &Row _Level0, &Rowset_Level1, &Row _Level1, &Record, &Field
Answer: D

Oracle   1Z0-242   1Z0-242 examen   1Z0-242 examen   1Z0-242

NO.20 Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.
&SQL = CreateSQL("Select EFFORT_AMT from PS_PSU_TASK_EFFORT where TASK= :1",
PSU_TASK_TBL.TASK);
&Var1 = &SQL.Fetch(&Var2);
Select the two correct statements. (Choose two.)
A. &Var2 specifies which row to fetch.
B. &Var2 specifies which field to fetch.
C. &Var1 is populated with TRUE if a row is fetched.
D. &Var1 is populated with the number of rows returned.
E. &Var2 is populated with EFFORT_AMT from the row fetched.
F. &Var1 is populated with EFFORT_AMT from the row fetched.
G. &Var1 is populated with EFFORT_AMT from the first row returned.
Answer: CE

Oracle examen   1Z0-242   1Z0-242   certification 1Z0-242

Le test Oracle 1Z0-242 est populaire dans l'Industrie IT. Il y a beaucoup de professionnels IT veulent ce passport de IT. Votre vie et salaire sera améliorée avec ce Certificat. Vous aurez une meilleure assurance.

Les meilleures Oracle 1Z0-242 examen pratique questions et réponses

Les produits de Pass4Test sont préparés pour le test Certification Oracle 1Z0-242, y compris les formations et les informations ciblées au test Oracle 1Z0-242. D'ailleurs, la Q&A de Pass4Test qui est impressionnée par la grande couverture des questions et la haute précision des réponses vous permet à réussir le test avec une haute note.

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 1Z0-242.

Le programme de formation Oracle 1Z0-242 offert par Pass4Test comprend les exercices et les test simulation. Vous voyez aussi les autres sites d'offrir l'outil de formation, mais c'est pas difficile à découvrir une grand écart de la qualité entre Pass4Test et les autres fournisseurs. Celui de Pass4Test est plus complet et convenable pour la préparation dans une courte terme.

Code d'Examen: 1Z0-242
Nom d'Examen: Oracle (PeopleSoft Application Developer II: App Engine and Integration)
Questions et réponses: 102 Q&As

Est-que vous s'inquiétez encore à passer le test Certification 1Z0-242 qui demande beaucoup d'efforts? Est-que vous travaillez nuit et jour juste pour préparer le test de Oracle 1Z0-242? Si vous voulez réussir le test Oracle 1Z0-242 plus facilement? N'hésitez plus à nous choisir. Pass4Test vous aidera à réaliser votre rêve.

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

NO.1 An Application Engine program uses a Do Select action. What occurs when the Select statement is
executed?
A. Each row returned by the Select statement is stored in the state record. The Select statement
continues until no more rows are returned. Then, the control passes to the calling section.
B. All rows returned by the Select statement are stored in a cursor. Then, the control is passed to the
calling section.
C. All rows returned by the Select statement are stored in the state record. Then, the control is passed to
the next section in the program.
D. All rows returned by the Select statement are stored in a cursor. The first row is stored in the state
record. Then, the remaining actions in the step are processed sequentially. Thereafter, the control returns
to the Do Select to fetch another row, until no more rows are returned.
E. When a row is returned, the remaining steps in the section execute and control returns to the calling
step.
F. When a row is returned, it is stored in the state record. Then, the control is passed to the calling section.
Answer: D

Oracle   1Z0-242 examen   1Z0-242

NO.2 You add a dynamic call to an Application Engine program following these steps:
1. Add the fields AE_APPLID and AE_SECTION to the state record if they are not already present.
2. Build the state record.
3. Verify that the state record is the default state record for the Application Engine program.
4. In a PeopleCode action, use a conditional test to populate the fields AE_APPLID and AE_SECTION
with an Application Engine program name and section name, respectively.
5. Following the PeopleCode action, add a Call Section action.
Select the correct statement.
A. The Application Engine program will execute as expected.
B. Step 2 is not needed for dynamic call.
C. Step 3 is not needed.
D. Add a step after step 5 to insert a SQL action that will use the values in the state record to populate the
Program and Section fields of the Application Engine Call Section action.
E. Add a step after step 5 to select the Dynamic Call check box in the Call Section action.
F. Step 4 is wrong. The PeopleCode program should use the AESection class to issue the dynamic call.
Answer: E

Oracle   1Z0-242   1Z0-242 examen   1Z0-242

NO.3 The Get Student Enrollments page uses a PeopleCode program to select and display rows based on
user input. When the user clicks Refresh, FieldChange PeopleCode populates a stand-alone rowset
using a Select method. When you test the program, the new rows are appended to the previous rows
instead of replacing them. How do you fix this problem?
A. Use a work scroll instead of a stand-alone rowset.
B. Add &Rowset.Flush(); after the Select method.
C. Use an Update method instead of a Select method.
D. Add &Rowset.Flush(); before the Select method.
E. Add &Rowset.Refresh (); after the Select method.
F. Add &Rowset.Refresh(); before the Select method.
Answer: D

Oracle   1Z0-242   1Z0-242 examen   1Z0-242

NO.4 Examine the join in this Select statement:
SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE A.TASK = B.TASK
AND A.RESOURCE = B.RESOURCE
Select the equivalent Select statement.
A. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Join(A.TASK, B.RESOURCE)
B. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Common(PROJECT A, EFFORT B)
C. SELECT A.TASK , B.EFFORT_AMT
FROM %Common(KEYS, PROJECT A, EFFORT B)
D. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Join(COMMON_KEYS, TASK A, EFFORT_AMT B)
E. SELECT A.TASK , B.EFFORT_AMT
FROM %Join(COMMON_KEYS, PROJECT A, EFFORT B)
Answer: E

Oracle   1Z0-242   certification 1Z0-242   1Z0-242

NO.5 An Application Engine program inserts rows into PS_VENDOR.
The program encounters an error and abends (ends abnormally).
You correct the error, but now PS_VENDOR is in an unknown state.
Select the correct statement.
A. If Log File was enabled in Configuration Manager, a script file was created that you use to return the
database to its original state. After you correct the error, you can run the program again.
B. If Recover was enabled for the program, the changes to PS_VENDOR are rolled back. After you
correct the error, you can run the program again.
C. If Restart was enabled for the program, a checkpoint was saved with the last commit. After you correct
the error, you can restart the program and processing will resume from the point of the last commit.
D. If Resume was enabled in PeopleSoft Process Scheduler, the program automatically resumes
processing after the condition that caused the error is corrected.
E. If a state record was defined for the program, PS_VENDOR is restored based on parameters that were
written to the state record. Then you can restart the program using the same run control parameters.
Answer: C

Oracle   1Z0-242 examen   certification 1Z0-242

NO.6 An Application Engine program requires a loop that will exit after 1000 rows have been processed.
The COUNTER field in the state record is incremented in each iteration of the loop. Which option contains
code that could be used in a Do While action to test for COUNTER?
A. Do While %Bind(Counter) < 1000
B. %SELECT (COUNTER)
FROM PS_INSTALLATION
Where COUNTER < 1000
C. If %Bind(Counter) >= 1000 then
Exit;
D. %Select(COUNTER)
FROM PS_STATE_AET
Where COUNTER < 1000
E. %Select(COUNTER)
SELECT 'X'
FROM PS_INSTALLATION
WHERE %Bind(COUNTER) < 1000;
Answer: E

Oracle   1Z0-242   1Z0-242   1Z0-242

NO.7 You want to examine the component buffer for the Customer Orders (PSU_CUST_ORDER )
component. Which four steps are necessary? (Choose four.)
A. Start the PeopleCode Debugger and set a breakpoint.
B. Access the Structure view on the PSU_CUST_ORDER component.
C. In Application Designer, select Component Buffers.
D. Access the Customer Orders component in the browser and trigger the breakpoint. Return to
PeopleSoft Application Designer when the breakpoint triggers.
E. Open, or create, a PeopleCode program that will execute while Customer Orders is running in the
browser.
F. Drill down through the component hierarchy in the Structure view on the PSU_CUST_ORDER
component.
G. In Application Designer, select Debug, View Component Buffers.
Answer: ADEG

Oracle examen   certification 1Z0-242   1Z0-242   certification 1Z0-242   1Z0-242   1Z0-242

NO.8 Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.
&SQL = CreateSQL("Select EFFORT_AMT from PS_PSU_TASK_EFFORT where TASK= :1",
PSU_TASK_TBL.TASK);
&Var1 = &SQL.Fetch(&Var2);
Select the two correct statements. (Choose two.)
A. &Var2 specifies which row to fetch.
B. &Var2 specifies which field to fetch.
C. &Var1 is populated with TRUE if a row is fetched.
D. &Var1 is populated with the number of rows returned.
E. &Var2 is populated with EFFORT_AMT from the row fetched.
F. &Var1 is populated with EFFORT_AMT from the row fetched.
G. &Var1 is populated with EFFORT_AMT from the first row returned.
Answer: CE

Oracle   certification 1Z0-242   1Z0-242 examen   1Z0-242

NO.9 View the Exhibit.
This run control page executes an Application Engine program that updates the Course table using the
parameters entered by a user.
In addition to the run control page, which three elements must be in place? (Choose three.)
A. A state record with fields to hold input parameters
B. Component variables to pass the input parameters
C. A data buffer object to retrieve the input parameters
D. Application Engine SQL to retrieve the input parameters
E. A PeopleCode record object to update the Course table
F. A Process Instance table to store run control parameters
G. A run control record with fields to store the input parameters
Answer: ADG

Oracle   certification 1Z0-242   1Z0-242   1Z0-242

NO.10 View the Exhibit.
On the Employee Review page, you have a business rule with these requirements:
1. If Review Type is Supervisor, then the prompt for Reviewer ID returns only supervisors.
2. If Review Type is Peer or Performance, then the prompt for Reviewer ID returns all employees.
Select the three steps required to implement this business rule. (Choose three.)
A. Associate the REVIEWER_ID field with REVIEWER_VW.
B. Create REVIEWER_VW as a dynamic view of the EMPLOYEE table.
C. Add the DERIVED.EDITTABLE field to the page and make it invisible.
D. Set the prompt table edit for the REVIEWER_ID field to REVIEWER_VW.
E. Set the prompt table edit for the REVIEWER_ID field to DERIVED.%EDITTABLE.
F. Use a SQL Select statement in PeopleCode to populate the REVIEWER_VW view.
G. Use a conditional statement in PeopleCode to populate the DERIVED.EDITTABLE field.
Answer: CEG

Oracle examen   1Z0-242   1Z0-242 examen

NO.11 View the Exhibit.
Your client is upgrading its purchasing application to use object-oriented PeopleCode to incorporate the
benefits of application classes.
The PeopleCode for the Purchase Order application is now encapsulated in an Application Package
called PSU_PO. The assign_order_nbr function is now ORDER_NBR, a method of the ORDER class.
You are tasked with modifying this program to call the new ORDER_NBR method.
Which four PeopleCode statements will you use in the new program? (Choose four.)
A. Class PSU_PO:ORDER;
B. &New.ORDER_NBR(PSU_PO_HDR.ORDER_NBR);
C. Import PSU_PO:ORDER;
D. Declare method PSU_PO:ORDER:ORDER_NBR;
E. &New = Create Order();
F. Local ORDER &New;
G. Method ORDER_NBR (&ORDER_NBR As Field out);
Answer: BCEF

certification Oracle   1Z0-242   1Z0-242   1Z0-242   1Z0-242

NO.12 How do you configure Process Scheduler to initiate an Application Engine trace for SQL and Step?
A. Add %%TRACE%% %%SQL%% %%STEP%% to the parameter list for the Process Type.
B. On the Run Control page, select the SQL Trace and Step Trace check boxes.
C. On the Process Monitor page, select the SQL Trace and Step Trace check boxes.
D. On the Process Definition Override Options page, for Parameter List, select Append and enter
-TRACE 3.
E. On the Process Definition Override Options page, for Parameter List, select Append and enter -TRACE
SQL STEP.
F. On the Process Definition Override Options page, for Parameter List, select Append and
enter %%TRACE%% %%SQL%% %%STEP%%.
Answer: D

certification Oracle   1Z0-242 examen   1Z0-242   1Z0-242   1Z0-242

NO.13 View the Exhibit.
A PeopleCode program at level 0 checks the values for Percent Available (PCT_AVAILABLE) at level 1.
Analyze this code snippet.
Local Rowset &RS_Level0, &RS_Level1;
Local Row &Row_Level0, &Row_Level1;
Local Record &Rec_TaskRsrc;
Local Field & Fld_PctAvail ;
&RS_Level0 = GetLevel0();
&Row_Level0 = &RS_Level0.GetRow(1);
&RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC);
&Row_Level1 = &RS_Level1.GetRow(1);
&Rec_TaskRsrc = &Row_Level1.GetRecord(Record.PSU_Task_RSRC);
&Fld_PctAvail = &Rec_TaskRsrc.GetField(Field.PCT_AVAILABLE);
&Pct = &Fld_PctAvail.Value;
Select the correct option.
A. The program will produce the expected results.
B. The program is missing a loop to process each row in the level 1 rowset.
C. The program is missing a loop to process each rowset in the level 1 row.
D. The program can be simplified to:
&Pct = &RS_Level0.PSU_Task_RSRC.PCT_AVAILABLE.Value;
E. This line of code is not needed:
&RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC);
F. The &RS_Level0 = GetLevel0(); function is missing the Level 0 scroll name.
Answer: B

certification Oracle   1Z0-242   1Z0-242   1Z0-242   1Z0-242 examen

NO.14 View the Exhibit.
An object-oriented PeopleCode program traverses the data buffer to get the value for Session Number
(SESSION_NBR) in the Session Details record (PSU_CRS_SESSN) on the Course Sessions page.
The program uses a built-in function to instantiate the Level 0 object, then uses object methods to
instantiate the remaining data buffer objects.
Select the option that represents the order in which the program instantiates the data buffer objects.
A. &Row_Level0, &Row _Level1, &Record, &Field
B. &Rowset_Level0, &Row_Level1, &Record, &Field
C. &Rowset_Level0, &Rowset_Level1, &Row_Level1, &Record, &Field
D. &Rowset_Level0, &Row _Level0, &Rowset_Level1, &Row _Level1, &Record, &Field
Answer: D

Oracle examen   1Z0-242 examen   1Z0-242 examen   1Z0-242

NO.15 You modify an Application Engine program to use parallel processing with temporary tables.
The Application Engine program includes this code snippet, which is part of a SQL statement that inserts
rows into a temporary table.
INSERT INTO PS_CRS_FULL_TMP
What changes do you need to make to the code so that the Application Engine program will implement
parallel processing properly?
A. No changes to the code are needed as long as the temporary table has been properly configured for
parallel processing.
B. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO PS_CRS_FULL_TMP so that the
meta-SQL resolves to the correct state record at run time.
C. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO %Table(CRS_FULL_TMP) so that
the system variables resolve to the correct syntax at run time.
D. Replace INSERT INTO PS_CRS_FULL_TMP with INSERT INTO %Table(CRS_FULL_TMP) so that
the meta-SQL resolves to the correct temporary table instance at run time.
E. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO %Temp(CRS_FULL_TMP) so that
the meta-SQL resolves to the correct syntax and temporary table instance at run time.
Answer: D

certification Oracle   1Z0-242 examen   1Z0-242 examen   1Z0-242

NO.16 Select three Application Engine action types that can be used to control program flow. (Choose three.)
A. Log Message
B. Call Section
C. XSLT
D. PeopleCode
E. Do While
F. Evaluate
Answer: BDE

Oracle examen   certification 1Z0-242   1Z0-242

NO.17 You want to see exactly when a PeopleCode program fires in the context of the Component Processor
flow. Which two methods will work? (Choose two.)
A. Insert a Print() statement in the program.
B. Insert a WinMessage() statement in the program.
C. Insert a MessageCatalog() statement in the program.
D. Run the PeopleCode Debugger and insert a breakpoint on the program.
E. Run the PeopleCode Debugger and select Debug, View Component Buffers.
Answer: BD

Oracle   certification 1Z0-242   1Z0-242   1Z0-242 examen

NO.18 A Process Scheduler process is configured to run an Application Engine program. You need to modify
the process to use parameters entered by the user at run time. Which four additional steps do you need to
take? (Choose four.)
A. Create a process type for the new process.
B. Add bind variables to the command-line parameters.
C. Write a PeopleCode program to pass the parameters.
D. Create a state record with fields to pass input parameters.
E. Create a run control page with fields to enter the input parameters.
F. Create a run control record with fields to store the input parameters.
G. Modify the Application Engine program to retrieve the input parameters.
Answer: DEFG

Oracle   certification 1Z0-242   1Z0-242   1Z0-242   1Z0-242

NO.19 Evaluate this PeopleCode snippet.
Local Array of Number &MyArray;
Local Any &Len, &Result;
&MyArray = CreateArray(3);
&MyArray[1] = 100;
&MyArray[2] = 200;
&MyArray[3] = 300;
&Result = &MyArray.POP();
&Len = &MyArray.LEN;
&End = &MyArray[&Len];
What are the correct values for &Result and &End?
A. &Result is 300
&End is 200
B. &Result is 300
&End is Null
C. &Result is 300
&End is 300
D. &Result is Null
&End is 300
E. &Result is 100
&End is 300
Answer: A

Oracle   1Z0-242 examen   1Z0-242

NO.20 The Customer Orders page uses data from the ITEM table to perform price calculations. You decide to
write a PeopleCode program to create a stand-alone rowset that will load data from the ITEM table into
the data buffer. Select three PeopleCode statements that can be used with stand-alone rowsets. (Choose
three.)
A. &RS_Item = GetRowSet(SCROLL.ITEM);
B. &RS_Item = CreateRowSet(RECORD.ITEM);
C. &Price = &RS_Item(&i).ITEM.PRICE.Value;
D. &RS_Item.Select("Where ITEM = :1", CUST_ORDER.ITEM);
E. &RS_Item.Fill("Where CUST_TYPE = :1", CUST_ORDER.TYPE);
F. &RS_Item = ScrollSelect(1,Scroll.ITEM, Record.ITEM, ("Where CUST_TYPE = :1", CUST_ORDER.
CUST_TYPE);
Answer: BCE

Oracle   certification 1Z0-242   certification 1Z0-242   1Z0-242 examen

Pass4Test est un site qui peut réalise le rêve de beaucoup de professionnels. Pass4Test peut vous donner un coup de main pour réussir le test Certification Oracle 1Z0-242 via son guide d'étude. Est-ce que vous vous souciez de test Certification Oracle 1Z0-242? Est-ce que vous êtes en cours de penser à chercher quelques Q&As à vous aider? Pass4Test peut résoudre ces problèmes. Les documentations offertes par Pass4Test peuvent vous provider une préparation avant le test plus efficace. Le test de simulation de Pass4Test est presque le même que le test réel. Étudier avec le guide d'étude de Pass4Test, vous pouvez passer le test avec une haute note.

Le matériel de formation de l'examen de meilleur Oracle 1Z0-108 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242

Si vous vous inscriez le test Oracle 1Z0-108 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242, vous devez choisir une bonne Q&A. Le test Oracle 1Z0-108 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 est un test Certification très important dans l'Industrie IT. C'est essentielle d'une bonne préparation avant le test.

On peut voir que beaucoup de candidats ratent le test Oracle 1Z0-108 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 quand même avec l'effort et beaucoup de temps dépensés. Cest une bonne preuve que le test Oracle 1Z0-108 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 est difficile à réussir. Pass4Test offre le guide d'étude bien fiable. Sauf le test Oracle 1Z0-108 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242, Pass4Test peut offrir les Q&As des autres test Certification IT.

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.

C'est un bon choix si vous prendre l'outil de formation de Pass4Test. Vous pouvez télécharger tout d'abord le démo gratuit pour prendre un essai. Vous aurez plus confiances sur Pass4Test après l'essai de notre démo. Si malheureusement, vous ne passe pas le test, votre argent sera tout rendu.

Code d'Examen: 1Z0-108

Nom d'Examen: Oracle (Oracle WebLogic System Administration)

Questions et réponses: 141 Q&As

Code d'Examen: 1Z0-238

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

Questions et réponses: 165 Q&As

Code d'Examen: 1Z0-055

Nom d'Examen: Oracle (Oracle Database 11g: New Features for 9i OCPs)

Questions et réponses: 150 Q&As

Code d'Examen: 1Z0-204

Nom d'Examen: Oracle (Oracle EBS R12: E-Business Essentials)

Questions et réponses: 199 Q&As

Code d'Examen: 1Z0-052

Nom d'Examen: Oracle (Oracle Database 11g: Administrator I )

Questions et réponses: 205 Q&As

Code d'Examen: 1Z0-242

Nom d'Examen: Oracle (PeopleSoft Application Developer II: App Engine and Integration)

Questions et réponses: 102 Q&As

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

NO.1 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 examen   1Z0-238   1Z0-238 examen   1Z0-238

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

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

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

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

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

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

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

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

NO.6 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   1Z0-238

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

NO.8 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 examen   1Z0-238

NO.9 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   1Z0-238 examen   1Z0-238   1Z0-238 examen   1Z0-238

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

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

NO.11 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   certification 1Z0-238

NO.12 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 examen   1Z0-238 examen   1Z0-238

NO.13 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   1Z0-238   1Z0-238   1Z0-238

NO.14 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   certification 1Z0-238   certification 1Z0-238   1Z0-238   1Z0-238 examen

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   1Z0-238 examen   1Z0-238   1Z0-238

NO.16 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 examen   1Z0-238   1Z0-238

NO.17 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   1Z0-238 examen

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

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

NO.19 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   certification 1Z0-238   1Z0-238   certification 1Z0-238

NO.20 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   certification 1Z0-238   certification 1Z0-238   1Z0-238 examen

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 examen   certification 1Z0-238   1Z0-238   certification 1Z0-238

NO.22 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 examen   certification 1Z0-238   1Z0-238   1Z0-238 examen

NO.23 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   certification 1Z0-238   1Z0-238   1Z0-238

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

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

NO.25 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   certification 1Z0-238   1Z0-238   certification 1Z0-238   1Z0-238 examen

NO.26 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   certification 1Z0-238   1Z0-238 examen   1Z0-238

NO.27 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   1Z0-238   certification 1Z0-238

NO.28 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 examen   1Z0-238   certification 1Z0-238   1Z0-238 examen

NO.29 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 examen   1Z0-238   certification 1Z0-238   1Z0-238   1Z0-238

NO.30 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 examen   1Z0-238   1Z0-238