50 most important interview questions



1)  What  is a state record.
2)  What are the actions available in AE.
3)  How will you read data from a CSV or Excel file and upload it into the database using AE.
4)  Why are SQC files used.
5)  What is the SQC used to read data from a translate table.
6)  Which section is mandatory in an SQR program.
7)  Why is setup section in an SQR program used.
8)  How will you get the system date in ORACLE.
9)  Effective Dated query in SQR.
10)             What is a subquery. Why is it used.
11)             What is Load-Lookup used in SQR.
12)             Why are FieldEdit and FieldChange events used.
13)             Why is SaveEdit event used.
14)             Why is SQLExec function used and how many rows can you retrieve using it.
15)             What is a subpage. Why is it used.
16)             Why is Derived/Work record used.
17)             What are the record types available in Application Designer.
18)             What is the difference between SQL View and Dynamic View.
19)             How many scrolls can be there on a page.
20)             How will you delete the buttons (Add, Update / Display, Correction) fr  om a page that is displayed in the browser.
21)             How will you add a component to the portal.
22)             What is the relationship between User Profiles, Roles and Permission Lists.
23)             What is the difference between Prompt table and Translate table.
24)             What is the purpose of State record.
25)             What is the difference between Local and Component variables in Peoplecode.
26)             What are the steps in Implementation.
27)             What are the types of table joins.
28)             How many objects are there in Peoplesoft 7.5, 8.12 and 8.4.
29)             How many events are there in peoplecode. When do they get fired.
30)             What is the architecture of PIA. What are its components.
31)             How will you read data from a CSV file and upload it into the database using SQR.
32)             Why is On-Break used.
33)             Why is Process Definition in Process Scheduler used and What are the options available in it.
34)             What are the object classes available in Peoplecode.
35)             What are the ways of registering a component in Portal Registry.
36)             What is the difference between Update Display, Update Display All and Correction modes.
37)             How will display an image in SQR.
38)             Which SQL commands can be used in SQL paragraph.
39)             In which sections can Select statement be used.
40)             What is Effdt and Effseq.
41)             SQR Debugging.
42)             How will you perform error handling in SQR.
43)             How are Multiple reports generated in SQR.
44)             What are the ways for Performance Tuning in SQR and Peoplecode.
45)             Why is Setenv.sqc used.
46)             Why is Process Monitor used and What is that which updates the status of a process in Process Monitor.
47)             What are the Key fields in PS_JOB and PS_EMPLOYMENT.
48)             In which record is the status of an employee stored.
49)             How will you draw a line of 80 hyphens (-) in SQR.
50)             When an incorrect value is entered in a field and the field turned red then what is the action to be taken.



SHARE

peoplesoft

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Phaniraavi@gmail.com