Oracle PeopleSoft Application Develper I: PeopleTools and PeopleCode

QUESTION NO: 1
View the Exhibit.
Select the SQL that corresponds to the record definition shown.

A. SELECTA.COURSE,A.INSTRUCTOR,B.DESCR,A.SESSION_NBR,A.TRAINING_LOC,A.START _DATEFROM PS_PSU_CRS_SESSN A,PS_PSU_COURSE_TBL BWHERE A.COURSE = B.COURSE B. SELECT A.INSTRUCTOR,A.COURSE,B.DESCR,A.SESSION_NBR,A.TRAINING_LOC,A.START_DTFRO M PS_PSU_CRS_SESSN A,PS_PSU_COURSE_TBL BWHERE A.COURSE = B.COURSE C. SELECT A.INSTRUCTOR,A.COURSE,DESCR,A.SESSION_NBR,A.TRAINING_LOC,A.START_DATEF ROM PS_PSU_CRS_SESSN A,PS_PSU_COURSE_TBL BWHERE A.COURSE = COURSE D. SELECT COURSE,B.DESCR,SESSION_NBR,TRAINING_LOC,START_DATEFROM PS_PSU_CRS_SESSN A,PS_PSU_COURSE_TBL BWHERE COURSE = B.COURSE

Correct Answer: C

QUESTION NO: 2
Which three statements are true regarding Query Profile? (Choose three.)

A. 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. B. By default, the Only Allowed to Run Queries option on the Query Profiles page is selected, and eachpermission list that is granted to a user or role has the possibility to have capabilities added. C. The Query Profiles page enablesyou 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. D. By default, the query profile does not give users access to all PeopleSoft Query features,even if you gave them access to PeopleSoft Query. E. The Query Profiles page enables you to specify the type of access that users have when they work with PeopleSoft Query. F. The Query Profiles page enables users to runexisting queries and create new ones.

Correct Answer: A,C,E

QUESTION NO: 3
Select the three true statements about PeopleSoft field definitions. (Choose three.)

A. All PeopleSoft field definition names are in uppercase. B. When you work with Number and Signed Number field types, the sum of integer and decimal positions must be less than or equal to 40. C. For a Long Character field, enter a field length of 256 to enable the database platform to determine the maximum length of the field. D. Date, Time, and DateTime fields all have a fixed length. E. Altering an existing field definition's default label can have consequences at both the record definition level and the page definition level.

Correct Answer: A,D,E

QUESTION NO: 4
Select the record definition that is configured correctly.

A. Exhibit D B. Exhibit A C. Exhibit C D. Exhibit B

Correct Answer: C

QUESTION NO: 5
Select the record definitions that are correctly configured as A) a control table and B) a transaction table, respectively.

A. Exhibit D B. Exhibit A C. Exhibit C D. Exhibit B

Correct Answer: A

QUESTION NO: 6
Select the two rules about PeopleSoft prompt table mechanics. (Choose two.)

A. The prompt matches fields based on name, data type, and length. B. The prompt selects the highest-level key on the prompt record definition unless the EFFDT field is present. C. The prompt automatically selects for the lowest-level key on the prompt record definition ignoring the EFFDT and EFF_STATUS fields. D. The prompt automatically filters the rows based on higher-level key values in the buffer.

Correct Answer: C,D

QUESTION NO: 7
View this PeopleCode snippet:
If &MyVar = 0 then
&MyVar = 1;
End-if;
The &MyVar variable is not declared. What will be the result?

A. The program will run but will produce undefined results. B. &MyVar willbe automatically declared with a type of Any. C. The program will fail at run time. D. The program will not pass the syntax checker. E. &MyVar will be automatically declared as Local Number. F. &MyVar will be automatically declared with a scope of Global.

Correct Answer: B

QUESTION NO: 8
When you run a Crystal report that has run-time prompts, the prompt values need to be passed using the command line. Which two options will accomplish this task? (Choose two.)

A. Create a default Crystal report from PeopleSoft Query using the file name (ACTQRY).RPT. B. Hard-code that prompt value in quotes into the Process Definition page. C. Use PeopleSoft Application Designer to create a run control page to gather values from the user and dynamically pass them into thecommand line. D. Create a default Crystal report from a named query object; the saved representation of the selected column list is used to generate the report. E. Create a default report from a new or unnamed query object to enable PeopleSoft Query to use the in-memory selected column list to generate the report.

Correct Answer: B,C

QUESTION NO: 9
Select the three elements required for a PeopleSoft SQL view. (Choose three.)

A. Record fields B. SQL statement C. Summary page D. WHERE clause E. Record definition

Correct Answer: A,B,E

QUESTION NO: 10
Are parameters passed to user-defined internal and external PeopleCode functions by reference or by value?

A. User-defined internal and external PeopleCode function parameters can be passed as input or as output, dependingon the function. B. User-defined internal and external PeopleCode function parameters are always passed by reference. C. User-defined internal and external PeopleCode functionparameters are always passed by value. D. The first parameter is the input parameter, and the second parameter is output parameter. E. User-defined internal and external PeopleCode function parameters can be passed by reference or by value, depending on the function.

Correct Answer: B

Oracle PeopleSoft Application Develper I: PeopleTools and PeopleCode - 1Z0-241 Exam Questions