Exam Number: 1Z0-241
Exam Title: PeopleSoft Application Developer I: PeopleTools & PeopleCode – Associated Certification Paths PeopleTools 8 Application Developer Certified Expert OPN Certified Specialist
Duration: 105 minutes
Number of Questions: 80
Passing Score: 64%
View passing score policy
This exam has been validated against Rel. 8.48, 8.50 and 8.51.
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
PeopleSoft PeopleTools I Rel 8.50
PeopleTools II Rel 8.50
PeopleSoft PeopleCode Rel 8.50
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
These earlier courses are still valid exam preparation tools but are no longer being scheduled:
PeopleTools I Rel 8.48
PeopleTools II Rel 8.48
PeopleCode Rel 8.48 (and 8.44)
The exam contains questions on Query, Crystal and Process Scheduler. The material can be studied from the documentation available on Oracle Technology Network. The relevant PeopleBook names are PeopleSoft Query, Crystal Reports for PeopleSoft,and PeopleSoft Process Scheduler.
Resources available to partners only
Training Opportunities for Oracle Partner Network Members
OPN Guided Learning Path: PeopleSoft Enterprise PeopleTools 8.50 Implementation Specialist
Training Resources by Exam Topics
PEOPLETOOLS I
Navigating PeopleSoft Applications
Access, enter and modify information in PeopleSoft applications.
Use PeopleBooks to find information.
Explaining PeopleSoft Architecture
Describe the structure of PeopleSoft databases.
Explain basic data transfer in PeopleSoft Pure Internet Architecture.
Identify the requirements for the development environment.
Organizing Data
Validating Data
Given a scenario, select the appropriate validation type in PeopleSoft applications.
Developing Applications by Using the Eight Steps
Explain the steps of PeopleSoft application development.
Designing the Application
Defining Fields
Use Application Designer to create and manage field definitions.
Use Application Designer to create and manage translate values.
Creating Record Definitions
Use Application Designer to create and manage record definitions.
Building SQL Tables
Use Application Designer to create and maintain database structures.
Creating Page Definitions
Use Application Designer to create and manage page definitions.
Defining Components
Use Application Designer to create and manage component definition.
Registering Components
Use Application Designer to register a component definition.
Testing an Application
Test and troubleshoot common development errors in basic applications.
Editing the Registry Structure
Manage Portal Registry structures. (Manage the PeopleSoft Portal Registry.)
Creating Menu Definitions
Use Application Designer to create and manage menu definitions.
Analyzing the Impact of Design Changes
Identify the impact of changing definition properties on an application.
Building Applications
Searching Applications by Using the Verity Search Engine
Use the Verity Search engine to search PeopleSoft applications.
Create and maintain a Verity search collection.
Performing Data Audits
Use Application Designer to audit PeopleSoft applications.
Importing and Exporting Projects
Use Application Designer to create and manage projects
PEOPLETOOLS II
Using Views in PeopleSoft Applications
Use Application Designer to create and maintain SQL views.
Use Application Designer to create and maintain Query views.
Creating Summary Pages Using Views
Use Application Designer to create and manage summary pages.
Creating and Using Search Records
Create and manage component search records.
Create and manage component add search records.
Using Views as Prompt Table Edits
Create and manage views that take advantage of prompting mechanics.
Explaining TableSet Sharing
Set up and maintain TableSet sharing.
Creating Parent-Child Relationships
Use Application Designer to enforce referential integrity.
Explaining Buffer Allocation
Describe buffer allocation and its impact on performance.
Creating Sub records and Sub pages
Create and maintain sub records.
Create and maintain sub pages.
Using Deferred Processing
Choose a processing mode based on a given scenario.
Introducing PeopleCode in an Application
Using Objects in PeopleCode
Creating Custom Objects with Application Classes
Using Images in PeopleSoft Applications
Use Application Designer to manage image definitions.
Use Application Designer to manage image field definitions.
Designing Pages Using Style Sheets
Use Application Designer to manage stylesheet definitions.
Apply stylesheets in PeopleSoft applications.
Designing More Advanced Pages
Create, maintain, and use message catalog entries.
Use Application Designer to create and maintain hyperlinks on pages.
PEOPLECODE
Technology Overview
Explain how PeopleCode is used
Using PeopleCode Development Tools
Choose the best PeopleTools definition with which to associate a program
Use the PeopleCode Editor locate, open, create, and edit programs
Use the PeopleCode debugger to observe program execution
Describing the Component Processor
Trace the Component Processor flow.
Identify PeopleCode search events.
Identify PeopleCode component build events.
Identify PeopleCode field action events.
Identify PeopleCode row action events.
Identify PeopleCode save action events.
Writing PeopleCode Programs
Write PeopleCode statements.
Use conditional statements
Use looping statements
Understanding PeopleCode Events
Match PeopleCode programs to the correct events
Using PeopleCode Variables
Create user-defined PeopleCode variables.
Use system variables.
Incorporate derived/work fields into PeopleSoft applications.
Using Built-In Functions
Use built-in functions
Writing PeopleCode Functions
Write external PeopleCode functions.
Explaining the Component Buffer
Determine the order of execution of PeopleCode programs based on buffer allocation rules
Accessing Data in the Component Buffer
Process rows in the component buffer using loops.
Programming With Object- Oriented PeopleCode
Write object-oriented PeopleCode programs
Referencing Data in the Component Buffer
Define the data buffer classes.
Instantiate the data buffer access classes.
Traverse the data buffer.
Creating Custom Objects with Application Classes
Describe application classes.
Organize application classes using application packages.
Using Data Buffer Methods
Use object-oriented methods manipulate the data buffer
Executing SQL in PeopleCode
Use SQL to read and modify data tables
Query, Crystal and Process Scheduler
Query
Use PeopleSoft Query Manager to extract information from PeopleSoft application data tables
Use Query Access Groups to secure and access record definitions
Create, edit, and manage queries using Query Manager
Crystal
Configure Crystal Reports to use PeopleSoft application data
Create and manage reports in Crystal Reports for PeopleSoft
Schedule and distribute Crystal Reports by using the PeopleSoft Process Scheduler
Process Scheduler
Configure and run a process using PeopleSoft Process Scheduler
Use the Process Monitor to assess the status of a process
Create, edit, and manage the elements o
QUESTION 1
You write a PeopleCode program that checks whether the user is selecting an existing search key
value on the Search page or creating a new search key value. Which system variable do you use?
A. %Add
B. &Add
C. %Mode
D. &Mode
E. %Search
F. &Search
Answer: C
QUESTION 2
Which three statements are true regarding Query Profile? (Choose three.)
A. The Query Profiles page enables users to run existing queries and create new ones.
B. The Query Profiles page enables you to specify the type of access that users have when they work with PeopleSoft Query.
C. By default, the query profile does not give users access to all PeopleSoft Query features, even if you gave them access to PeopleSoft Query.
D. If a user has more than one permission list, PeopleSoft Query uses the highest time-out value as defined in the Time-out Minutes section of the user’s permission lists.
E. The Query Profiles page enables you to restrict the types of queries that users can create, limit the number of rows returned, or set the time that a query can run before it times out.
F. By default, the Only Allowed to Run Queries option on the Query Profiles page is selected, and each permission list that is granted to a user or role has the possibility to have capabilities added.
Answer: B,D,E
QUESTION 3
Examine this PeopleCode snippet:
class OCP_ROWSET extends Rowset;
property integer FilledRowCount get;
method OCP_ROWSET(&strRecName As string, &strDataFld As
string, &strGetOrCreate As string);
method InsertRow(&iRow As integer) Returns boolean;
Select the correct statements. (Choose all that apply.)
A. OCP_ROWSET is the constructor method for the OCP_ROWSET class.
B. Executing the RO_ROWSET method instantiates an object of the OCP_ROWSET class.
C. The OCP_ROWSET method runs automatically whenever an object is instantiated using the OCP_ROWSET class.
D. The OCP_ROWSET method must initialize the ROWSET class.
E. The OCP_ROWSET method is added to the ROWSET class, and, by extension, to any instances of the ROWSET class.
Answer: A,C,D
QUESTION 4
View the Exhibit:
You are testing an application that you just completed. You access the content reference and
select a search key. When you click the Search button, you see the error shown in the image.
Select the next course of action.
A. Remove the PS_TS_EMP_REVIEW field from the record definition.
B. Run the Alter process for the PS_TS_EMP_REVIEW record definition.
C. Run the Build process for the PS_TS_EMP_REVIEW record definition.
D. Examine the record definition properties and manually create a BUILD script.
E. Verify that you created and properly configured the PS_TS_EMP_REVIEW page.
Answer: C
QUESTION 5
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
Click here to view complete Q&A of 1Z0-241 exam
Certkingdom Review, Certkingdom PDF Torrents
Best Oracle 1Z0-241 Certification, Oracle 1Z0-241 Training at certkingdom.com