1Z0-241 試験問題を無料オンラインアクセス

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

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

View the Exhibit.
Select the SQL statement that corresponds to the record definition.

• A.SELECT A.COURSE,A.STUDENT_ID,A.SESSION_NBR,B.STUDENT_NAME,B.CUSTOMER_ID,DESC R,A.ENROLL_DT,A.ENROLL_STATUSFROM PS_PSU_STU_ENROLL A, PS_PSU_STUDENT_TBL B, PS_PSU_CUST_TBL CWHERE A.STUDENT_ID = B.STUDENT_IDAND B.CUSTOMER_ID = CUSTOMER_ID
• B.SELECT A.COURSE,A.STUDENT_ID,A.SESSION_NBR,STUDENT_NAME,CUSTOMER_ID,C.DESC R,A.ENROLL_DT,A.ENROLL_STATUSFROM PS_PSU_STU_ENROLL A, PS_PSU_STUDENT_TBL B, PS_PSU_CUST_TBL BWHERE A.STUDENT_ID = STUDENT_IDAND CUSTOMER_ID = CUSTOMER_ID
• C.SELECT COURSE,SESSION_NBR,B.STUDENT_NAME,B.CUSTOMER_ID,C.DESCR,ENROLL_DT ,ENROLL_STATUSFROM PS_PSU_STU_ENROLL A, PS_PSU_STUDENT_TBL B, PS_PSU_CUST_TBL CWHERE STUDENT_ID = B.STUDENT_IDAND B.CUSTOMER_ID=
• D.CUSTOMER_ID
• E.SELECT A.COURSE SELECT A.COURSE,A.STUDENT_ID,A.SESSION_NBR,B.STUDENT_NAME,B.CUSTOMER_ID,C.DESC R,A.ENROLL_STATUS,A.ENROLL_DATEFROM PS_PSU_STU_ENROLL A, PS_PSU_STUDENT_TBL B, PS_PSU_CUST_TBL CWHERE A.STUDENT_ID = B.STUDENT_IDAND B.CUSTOMER_ID = C.CUSTOMER_ID

Select the two rules about PeopleSoft prompt table mechanics. (Choose two.)

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

Your customer indicates that when she promotes her employees, typically she increases their pay simultaneously.
You want to manage this with one table. Which two fields must you place on that table to accommodate this request? (Choose two.)

• A.EFFECTIVE_SEQ
• B.EFFDT
• C.EFFECTIVE_DT
• D.EFFSEQ
• E.EFF_STATUS

Which three statements are true when you want to view queries? (Choose three.)

• A.If you want to run multiple queries and run each query multiple times with different run-time prompt values, the Run page is more useful than the HTML, Excel, or Schedule links on the Query Manager search page.
• B.Query Viewer is a version of Query Manager. It has the same functions, but in a different view.
• C.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.
• D.You can view all public queries, and private queries that are in your list of queries.
• E.If you want to run queries that are not saved in PeopleSoft Query, you can use the Run page in Query Manager.