1z0-241 | The Secret of Oracle 1z0-241 braindumps
Q71. View the Exhibit.
Select the SQL that corresponds to the record definition shown.
A. SELECT A.COURSE
,B.DESCR
,A.SESSION_NBR
,A.TRAINING_LOC
,A.START_DATE
FROM PS_PSU_CRS_SESSN A
,PS_PSU_COURSE_TBL B WHERE A.COURSE = B.COURSE
B. SELECT A.INSTRUCTOR
,A.COURSE
,B.DESCR
,A.SESSION_NBR
,A.TRAINING_LOC
,A.START_DATE
FROM PS_PSU_CRS_SESSN A
,PS_PSU_COURSE_TBL B WHERE A.COURSE = B.COURSE
C. SELECT A.COURSE
,A.INSTRUCTOR
,B.DESCR
,A.SESSION_NBR
,A.TRAINING_LOC
,A.START_DATE
FROM PS_PSU_CRS_SESSN A
,PS_PSU_COURSE_TBL B WHERE A.COURSE = B.COURSE
D. SELECT A.INSTRUCTOR
,A.COURSE
,B.DESCR
,A.SESSION_NBR
,A.TRAINING_LOC
,A.START_DT
FROM PS_PSU_CRS_SESSN A
,PS_PSU_COURSE_TBL B WHERE A.COURSE = B.COURSE
Answer: B
Q72. View the Exhibit.
This FieldChange program conditionally populates DERIVED.EDITTABLE, based on the value of PSU_EMP_RVW_RVR.REVIEW_TYPE.Another similar program should be placed in a companion event.In which other event should the other PeopleCode program be placed?
A. FieldEdit
B. RowInit
C. RowInsert
D. SavePreChange
E. SavePostChange
Answer: B
Q73. PeopleCode in the SavePostChange and SavePrechange events can be placed on the component either at the component level or at the component record level. Which two statements are true about the how these events are processed? (Choose two.)
A. PeopleCode in these events placed at the component record level runs once per row when the page is saved.
B. PeopleCode in these events placed at the component record level runs once when the page is saved.
C. PeopleCode in these events placed at the component level runs once per row when the page is saved.
D. PeopleCode in these events placed at the component level runs once when the page is saved.
E. PeopleCode in these events placed at the component record level triggers a Save when a row is changed.
F. PeopleCode in these events placed at the component level triggers a Save when the page is changed.
Answer: AD
Q74. For the Employee Expenses application, a PeopleCode program could be placed either on the EMPLOYEE record or on the EMP_EXPENSE component. You decide to place it on the component.Which is a valid reason for choosing to place the program on the component instead of the record?
A. The program updates multiple database tables.
B. The program validates data across multiple records.
C. Component PeopleCode executes before record PeopleCode, so it is more efficient.
D. The record definition is used on several components, but this program should run only on this component.
E. The program initializes fields on the search page, and the search record is associated with the component.
F. The component contains several record definitions and you do not want to duplicate the code in each record.
G. Component PeopleCode is more reusable because component PeopleCode is available for execution on other components.
Answer: D
Q75. View the Exhibit.
This PeopleCode program compares two editable fields on a component. Which event or events should the program be placed in?
A. SaveEdit
B. FieldEdit
C. SaveEdit and RowInit
D. FieldEdit and RowInit
E. SearchSave and SavePreChange
F. FieldChange and SavePreChange
Answer: A
Q76. This PeopleCode function uses effective-date logic to return the current row from PSXLATITEM. SQLExec("SELECT A.XLATSHORTNAME, A.XLATLONGNAME
FROM PSXLATITEM A WHERE A.EFFDT = (SELECT MAX(B.EFFDT) FROM
PSXLATITEM B WHERE
A.FIELDNAME = B.FIELDNAME AND A.FIELDVALUE = B.FIELDVALUE AND
B.EFFDT <= <date>)");
Which system variable should be substituted for <date> so the function correctly returns the current row as of the run date for all supported database platforms?
A. %Date
B. %AsOfDate
C. %DateTime
D. %EffDtCheck
E. %CurrentDateIn
F. %CurrentDateOut
Answer: E
Q77. Which three statements are true when you modify the default settings in Crystal Reports? (Choose three.)
A. To add a Print Date field, you drag the Print Date field from the Field Explorer to the appropriate area of the report.
B. To change fonts in a report, you select the text, double-click it, and then select the appropriate font, style, size, and color from the tool bar.
C. To change default column headings of a report, you can either double-click the column heading that you want to change or click the text object and select Edit, Edit Text. Then, edit the text and click a blank area of the report to deselect the column headings.
D. If you modify a query to include additional fields, you need to modify the report definition in Crystal Reports to include the new fields in your report. To modify the report definition, select the Verify Database option from the Database menu.
E. You can make the column headings as long as you want. If you make them much longer than the current heading, Crystal Reports will automatically enlarge the text box to fit your new heading.
Answer: ACD
Q78. During the execution of a PeopleCode program, a FieldEdit program issues an error statement. The component processor _____.
A. notifies the user and the processing continues
B. terminates the program and rolls back changes
C. displays a message and returns to the reset state
D. displays a message, loops back through the component build flow, and waits for the user to change the field
E. displays a message, loops back to display the page, and waits for the user to change the field
Answer: E
Q79. What must you do first, before you create a link to an external Web page from a PeopleSoft page?
A. Create and save a link image definition.
B. Understand the structure of the component.
C. Select the "Open in New Window" check box.
D. Save the external URL in the URL repository.
E. Configure the portal navigation to the external page.
Answer: D
Q80. Select the two true statements about the PeopleSoft application development process. (Choose two.)
A. The steps build on each other and should be completed in a definite order.
B. The process can be divided into four phases: planning, data design, user interface design, testing.
C. During the process, you define or use fields, records, pages, component interfaces, and menus.
D. During the process, you use Application Designer to manipulate the structure of the PeopleTools tables.
E. During the process, you use Application Designer to create pages, which are stored as HTML in the PeopleTools tables.
Answer: AB