1z0-241 | Replace Oracle 1z0-241 examcollection
Q91. If your Crystal report contains numeric fields that are formatted to have single-line or doubleline borders at the top of the container, you may experience incorrect justification of numbers in the HTML output.Which two options would solve your problem? (Choose two.)
A. Draw lines above the numeric fields using the line drawing tool.
B. Insert summary fields into a blank text object and then format the container text object to include borders above the text.
C. Get full reporting flexibility by signing out and then successfully signing in to a PeopleSoft database using the PeopleSoft sign-in dialog.
D. Select the Design tab, save the report, return to the Preview tab, and click the Refresh button to refresh your data after making changes.
E. Select the Design tab and, in the Page Header section, double-click the field that has singleline or double-line borders at the top, and then click a blank area of the report to deselect the text object.
Answer: AB
Q92. Examine this PeopleCode snippet:
Local Rowset &RS_Level0, &RS_Level1; Local Row &Row_Level0, &Row_Level1; Local Record &Rec_EMP;
Local Field &Fld_ROLE;
&RS_Level0 = GetLevel0();
&ROW_Level0 = &RS_Level0.GetRow(1);
If this is the beginning of a program that will traverse the data buffer to access values at level
1, which would be the next valid PeopleCode statement?
A. &Row_Level1 = GetRow(&I);
B. &Row_Level1 = &RS_Level1.GetRow(&I);
C. &RS_Level1 = &Row_Level0.GetRowSet(SCROLL.DEPT);
D. &REC_TASKRSRC = &Row_Level1.GetRecord(RECORD.EMP); E. &FLD_PCTAVAIL
= &REC_TASKRSRC.GetField(FIELD.ROLE);
Answer: C
Q93. You run this SQL statement in your query tool: SELECT * FROM DBA_OBJECTS;
Assuming that the syntax is correct for your platform, what does the statement select from?
A. PeopleTools tables
B. System catalog tables
C. Application data tables
D. Related language tables
Answer: B
Q94. View the Exhibit.
Which two PeopleCode snippets contain syntax errors? (Choose two.)
A. 1
B. 2
C. 3
D. 4
E. 5
Answer: BE
Q95. Select the three modifications that require you to rebuild or alter the SQL table or indexes. (Choose three.)
A. You change the length of a field definition.
B. You change the default field definition label.
C. You make an existing key field a search key.
D. You change an ascending key to a descending key.
E. You delete an unused field from the record definition.
Answer: ADE
Q96. Which three statements are true when you want to view queries? (Choose three.)
A. You can view all public queries, and private queries that are in your list of queries.
B. If you want to run queries that are not saved in PeopleSoft Query, you can use the Run page in Query Manager.
C. Query Viewer is a version of Query Manager. It has the same functions, but in a different view.
D. You can run a predefined query from your browser and view it online using any of the following links on the Query Manager search page: HTML, Excel, or Schedule.
E. If you want to run multiple queries and run each query multiple times with different runtime prompt values, the Run page is more useful than the HTML, Excel, or Schedule links on the Query Manager search page.
Answer: BDE
Q97. Within the component processor flow, the component build process is a loop that executes until _____.
A. the End Build marker is reached
B. the entire component-level PeopleCode executes
C. all the page elements are retrieved and displayed
D. all the rows in the record are loaded into the buffer
E. all the rows that were selected from the database are loaded into the buffer
Answer: E
Q98. The PeopleSoft Process Scheduler Server Agent should not run continuously. To control its activity , you can schedule a non-running time for the server. This non-running time refers to the number of seconds that you want the agent to wait before it checks for queued process requests in the Process Request table. To set the non-running time for the server, which option do you need to set?
A. The Heartbeat field on the Server Definition page.
B. The Max Concurrent field on the Distribution page.
C. The Sleep Time field on the Server Definition page.
D. The Start Time and End Time fields on the Operation page.
E. The Server Load Balancing Option field on the Operation page.
Answer: C
Q99. Are parameters passed to user-defined internal and external PeopleCode functions by reference or by value?
A. The first parameter is the input parameter, and the second parameter is output parameter.
B. User-defined internal and external PeopleCode function parameters are always passed by value.
C. User-defined internal and external PeopleCode function parameters are always passed by reference.
D. User-defined internal and external PeopleCode function parameters can be passed as input or as output, depending on the function.
E. User-defined internal and external PeopleCode function parameters can be passed by reference or by value, depending on the function.
Answer: C
Q100. View the Exhibit.
This PeopleCode program uses a SQL Update to modify PSOPRDEFN, a table that is not in the component buffers.You want to be certain that this update will occur only if the entire component buffer is successfully written to the database.In which event or events should the program be placed?
A. SaveEdit
B. SavePreChange
C. SavePostChange
D. FieldEdit and SaveEdit
E. SaveEdit and SavePostChange
F. SavePreChange and SavePostChange
Answer: C