1z0-241 | Rebirth 1z0-241 Exam Study Guides With New Update Exam Questions
Q51. A SQL object is instantiated using the following statement:
&SQL = CreateSQL("Select EFFORT_SPENT from PS _TASK_TBL where TASK= :1",
TASK_RSRC.TASK);
Which PeopleCode statement can be used to reference a single row of data in &SQL?
A. &SQL.Get(&Var);
B. &SQL.Next(&Var);
C. &SQL.Fetch(&Var);
D. &SQL.Select(&Var);
E. &SQL.Create(&Var);
F. &SQL.Execute(&Var);
Answer: C
Q52. View the Exhibit.
Select the SQL statement that corresponds to the record definition.
A. SELECT A.PRODUCT_ID
, A.CUSTOMER
, B.DESCR
, A.PLATFORM
, A.PRODUCTION_STATUS FROM PS_PSU_CUST_PROD A
, PS_PSU_CUST_TBL B
WHERE A.CUSTOMER_ID = B.CUSTOMER_ID
B. SELECT A.PRODUCT
, A.CUSTOMER_ID
, B.DESCR
, A.PRODUCTION_STATUS FROM PS_PSU_CUST_PROD A
, PS_PSU_CUST_TBL B
WHERE A.CUSTOMER_ID = B.CUSTOMER_ID
C. SELECT A.PRODUCT
, A.CUSTOMER_ID
, B.DESCR
, A.PLATFORM
, A.PRODUCTION_STATUS FROM PS_PSU_CUST_PROD A
, PS_PSU_CUST_TBL B
WHERE A.CUSTOMER_ID = B.CUSTOMER_ID
D. SELECT A.PRODUCT
, A.CUSTOMER_ID
, B.DESCR
, A.PLATFORM
, A.PRODUCTION_STATUS FROM PS_PSU_CUST_PROD A
, PS_PSU_CUST_TBL B
WHERE A.CUSTOMER_ID = A.CUSTOMER_ID
Answer: C
Q53. Select the three true statements regarding page design principles that enable you to build a successful PeopleSoft page definition. (Choose three.)
A. Search keys must be at level zero.
B. You can have four levels on a page.
C. Radio buttons must be grouped together.
D. A level three scroll is a parent of a level two scroll.
E. All pages must include a level zero and a level one.
F. Related fields must precede their corresponding Display Control fields.
Answer: ABC
Q54. Select the correct syntax for a PeopleCode conditional statement.
A. If condition Then
<PeopleCode statement(s)>;
[Else
<PeopleCode statement(s)>;]
B. If condition Then
<PeopleCode statement(s)>;
[When other
<PeopleCode statement(s)>;] End-If;
C. When condition Then
<PeopleCode statement(s)>;
[Else when
<PeopleCode statement(s)>;] End-If;
D. If condition
<PeopleCode statement(s)>;
[Else
<PeopleCode statement(s)>;] End-If;
E. If condition Then
<PeopleCode statement(s)>;
[Else
<PeopleCode statement(s)>;] End-If;
Answer: E
Q55. View the Exhibit.
Examine the Add search record and select the search page that the system generates in Add mode.
Answer: D
Q56. This PeopleCode snippet creates a record object, where TASK and RESOURCE_NAME are keys on TASK_RSRC.
&MyRec = CreateRecord(Record.TASK_RSRC);
&MyRec.TASK.Value = &Task;
&MyRec.RESOURCE_NAME.Value = &Resource;
Which method will populate the record object with one row from PS_TASK_RSRC?
A. Insert
B. Fetch
C. Update
D. Execute
E. SelectByKey
Answer: E
Q57. View the Exhibit.
You access a content reference and see the search page shown.Select the property that you must change so that the search page title is more descriptive.
A. Menu item label
B. Component item label
C. Record definition label
D. Search page item label
Answer: A
Q58. View the Exhibit.
The Student Personal Details page writes to the PS_STUDENT table.If the "Same address as Customer" check box is selected on the Student Personal Details page,as shown on the Exhibit, the student address is copied from the PS_CUSTOMER table.As a result, the PS_STUDENT table must be updated whenever a change to the address value on the Customer page is written to the PS_CUSTOMER table. The recommended method to enforce this is to ________.
A. use a prompt table edit
B. write a Data Mover script
C. write a PeopleCode program
D. create an Integration Broker message
E. create an Application Engine daemon process
Answer: C
Q59. Oracle's PeopleSoft Query uses query access group trees to control security of the tables in your PeopleSoft database. Which three statements are true regarding query access group trees? (Choose three.)
A. You define a hierarchy of record components, based on logical or functional groupings, and then give users access to one or more branches of the tree.
B. After you build your query access group trees, users are granted access by default to create new queries and to run existing queries, and they have the access rights to the record components that are used in the queries.
C. Users can use PeopleSoft Query to retrieve information only from those tables with record definitions they have access to.
D. You can create, view, and update query access group trees using PeopleSoft Query Access Manager.
E. After you build a query tree, users can then generate queries on any tables that exist in the database.
Answer: ACD
Q60. Within the component processor flow, field action processing is initiated when _____.
A. a field value is changed
B. a user changes a value in a field
C. the component build process completes
D. a user enters an incorrect value in a field
E. a user changes a value in a field and exits the field or saves
Answer: E