ps query interview questions

PeopleSoft Interview Questions And Answers For Experienced. Here Coding compiler presenting a list of 199 PeopleSoft Interview Questions. These PeopleSoft questions are prepared by industry expert PeopleSoft developers. We hope that it helps you to crack your next PeopleSoft job interview. All the best and happy learning.

PeopleSoft Interview Questions and Answers for Freshers:

PeopleSoft is used to retrieve data from a database using visual representations rather than SQL instructions. These queries are ordinary or delegated, and they are used once or many times. The primary purpose is to get the results/information from the entire data bundle as needed. Therefore, its also regarded as a data source.

What are the various applications of the PeopleSoft Query?

These queries can be used to display data, perform a separate query procedure, and need to schedule inquiries for accuracy level. Certain queries can be downloaded for offline use in an Excel spreadsheet or other forms. If youre working with Crystal Reports, these can also be used as data sources. When it comes to selecting a data recipient, PeopleSoft Query can help.

Do you want to enhance your skills and build your career in this ERP domain? Then enrol for ” PeopleSoft Admin Training ” this course will help you to achieve excellence in this domain.

What are the benefits of using a PeopleSoft connectivity broker?

It assists you in carrying out your data integration tasks, either internally or with other third parties, as the name implies. Monitoring data structures, data format, and data transportation are all part of data handling. Because the PeopleSoft integration broker is modular, some of its components can be reused.

Basic Peoplesoft Interview Questions and Answers

15) How to migrate roles or PeopleCode from one database to another database?

A) Include all the roles in a project by clicking on Insert -> Definitions into Project -> select Roles and add them into the project. Migrate the project to another database.

Create a data mover script to migrate roles from PSROLEDEFN or PSPCMPROG for peoplecode table.

Login to database through App Designer as a source database.

Click on upgrade tab and open the project which contains roles which you want to migrate.

Double click on Roles folder under the opened project.

Select Action as “Copy”.

Go to Tools > Copy Project > To Database…..

Give database name (Target Database) to which you want to migrate roles.

Click on “OK”

Select “Roles” from different objects and copy those roles.

After completion of Copying double click on Roles folder under the opened project and verify that “Done” checkbox should be checked.

PeopleSoft Interview Questions

16) What is the use of set control field in record field properties?

A) Set Control id is used when you want to share tables in PeopleTools applications.

17) How to create prompt table?

A) Using edit table option in record field properties

18) How is performance management taken care in People Tools?

A) – Indexing tables on the database side helps in batch processing a great deal.

Analyzing tables helps.

If there is custom code make sure the SQL queries used are written well with the use of proper keys and joins are correct as well.

19) What are state records?

A) – The state record will be used to pass variable information between two application engine sections.

It can be physical or derived work record. Physical record can be used when you have restart logic and when you have disabled the restart logic derived work record can be used.

There can be a max of 200 state records that can be used in a single AE but only one of them can be default state record name must end with _AET.

20) What is mandatory step of application engine program?

Main is the required section in Application Engine.

There can be multiple steps in single application engine but at least one step should be part of AE.

Similarly you can have multiple actions in AE but you should have minimum 1 action part of step.

PeopleSoft Interview Questions

21) What is difference between component level peoplecode and record level peoplecode?

A) Component level PeopleCode is associated with unique component, where as record level peoplecode can be associated with any number of components

22. Types of PeopleCode functions?

A) People code supports these types of functions:

Built in

Internal

External people code

External non-people code

23) Explain with example where you used peoplecode extensively?

24) What is the difference between Prebuild & Postbuild events and saveprechange and savepostchange?

A) Prebuild can be used to validate your search data, discarding rows. Postbuild can be used to play with the pages (hide, unhide), filling up scrolls. Saveprechange is the last event where you can validate and correct your data before updating the database. Once it is done, database will get updated. Savepostchange will be used to play with tables which are not present in your component buffer.

25) Sequence of peoplecode events?

A) Searchinit peoplecode performs before the search dialogue box displays.

Search save peoplecode performs after the operator clicks ok in the search record dialogue box.

Row select peoplecode is used to filter out rows of data.

Prebuild is often used to hide and unhide the pages.

Field default attempts to set defaults for fields without a value.

Field formula performs, after field default completes successfully.

Rowinit is used to initialize the rows.

Postbuild peoplecode performs after all the component build events have performed.

Activate event is fired every time the page is activated.

PeopleSoft Interview Questions

26) Difference between SQLEXEC and CREATESQL?

A) SqlExec means it bypasses the component buffer and it is directly contacts database to retrieve data. But it retrieves the data row by row and not possible for bulk insert.

But in the case of Create SQL we can able insert the data in bulk.

27. Where is peoplecode stored?

28) Is there any function in peoplecode which stops the processing of whole component?

A) Think-time functions suspend processing either until the user has taken some action (such as clicking a button in a message box), or until an external process has run to completion. Think-time functions

Following are Think time functions:

DoCancel

DoModal

DoModalComponent

Exec (only when Synchronous)

File attach functions

Prompt

RemoteCall

RevalidatePassword

WinExec(only when Synchronous)

WinMessage

WinMessageBox

29) Stages of program flow in SQR?

A) Compile stage All the Preprocessor directives are compiled (which starts with #include).

Ex: All the SQC are run.

Check for the syntax errors for the conditions.

Ex: if for loop while loop are properly ended with the respective syntax.

Allocates memory structure if you are using the Arrays and load look up

Execution stage starts interpreting the code line by line

Check for the begin -program Begin -heading Begin- footer

30) Program flow of SQR?

Setup section

heading section

footing section

program section

procedure section

31) Difference between Translate values and Prompt tables?

A) Translate Table: Translate table is a special kind of table that is limited to validating data of four characters or less. The translate table serves as a universal prompt table and is effective-dated

Prompt Table: Prompt table are used to provide users with validate values from other tables other values are generally populated by system users and are often application specific

32) What is .SQC and .SQT?

A) .SQC is a Function Library file. It is like a sub program is saved by extension .SQC and this program can be called in the SQR program

.SQT is compile time/Run time file. When a file with XXX.SQR is compiled we get the output as XXX.SQT and when is XXX.SQT is executed we get the output XXX.LIS (List file/Output file).

33) Important SQC that need to be attached to SQR program?

– #include ‘setenv.sqc’

– #include ‘stdapi.sqc’

– #include ‘prcsdefn.sqc’

– #include ‘prcsapi.sqc’

– #include ‘curdtrim.sqc’

– #include ‘hrctlnld.sqc’

– #include ‘datwtime.sqc’

PeopleSoft Interview Questions

34) What is Normalization in Oracle?

A) The major goals of Normalization are

– Eliminating redundant data (for example storing the same data in more than one table

– Ensuring data dependencies (only storing related data in a table).

35) Performance tuning in SQR?

– Load Look Up

– Arrays

– Multiple Report

– -Bnn

– Using SQT Files

– Run on the BATCH Server

– Proper Programming Logic

– Set processing

– SQL Tuning

36) Difference between search record and add search record?

A) Search Record: Specify the search record for the component. The search record controls access to rows of data in a table. Its keys and alternate search keys appear on the search page as criteria.

Add Search record: Specify if you want a different search record specifically for add actions.

37) What is difference between scroll and grid?

A) Scroll area is used to maintain parent child relationship we insert grid in low level scroll

Example: assume we have 3 scroll levels in our page level1 level2 and level3 we insert grid in level 3

PeopleSoft Interview Questions

38. How many ways we can run the application engine program?

A) – Running from Application Designer.

– By calling People Code function.

– Running from DOS Environment (Debugging).

– Running from Application Engine People Tool.

– Running from Peoplesoft Application.

39) Functional and Technical?

A) Based on Customer Business processes functional person maps requirements to PeopleSoft and performs the rules and the Configurations required. He is the one who collects the requirement and decides what customization is and what is delivered by PeopleSoft.

PeopleSoft Technical Guy is the Person who knows how to code in PeopleSoft to execute the requirement.

40) What are the new features added in PS 8 Application Designer?

A) The newly added features in PS 8 Application Designer are as follows:

The Application Reviewer has been integrated with Application Designer in 8.

The PeopleCode has become VBA style with objects properties and methods.

The Meta SQL variables are introduced. The new variables like component, record, SQL has been introduced.

The Application engine now supports PeopleCode.

The scroll bars have become scroll areas in PS 8.0 etc.

41. What are the three actions that can be attached to menu?

42. What is the difference between a Process and a Report?

A) The Process receives a command line parameter where as the Report receives run controls from the page.

43) What are maximum number of actions possible in a step, list them

A) Various actions possible in Application Engine step are as follows:

– Do while

– Do when

– Do select

– PeopleCode

– SQL

– Call section

– Log Message

– Do until

One action can be called only once in a step of an Application Engine program.

PeopleSoft Interview Questions

44) Tell about application engine program you worked with?

45) What is built in restart logic in Application Engine programs?

A) Within each Application Engine program, you must define how frequently the program will issue a COMMIT. After doing so, each COMMIT becomes a “checkpoint” that Application Engine uses to locate where within a program to restart after an abend. This type of built-in logic does not exist in COBOL or SQR.

46) What are Application Engine State records?

A) The State Record is a PeopleSoft record that must be created and maintained by the Application Engine developer. This record defines the fields a program uses to pass values from one Action to another.

Think of the fields of the Application Engine State Record as comprising the working storage for the Application Engine program. An Application Engine State Record can be either a physical record or a work record, and any number of State Records can be associated with a program. Physical State Records must be keyed by process instance.

An Application Engine State Record must have PROCESS_INSTANCE defined as the first field and the only key field. And, so that the system recognizes the record as a State Record, all State Record names must end with the _AET identifier.

47) What is PIA and what are its components?

A) It is n-tier architecture. We have client, web server, application server and Database server. We have jolt and tuxedo. We have WSL, WSH, JSL, JSH, QUEUES and services.

In database server we have system tables, PeopleTools tables and application tables.

48) In which events error & warning are used most extensively.

A) Field edit, save edit, Search save, row delete, row insert.

PeopleSoft Interview Questions

49) Is there any way by which you can find out whether the user is in Add mode or Update mode?

A) %mode—returns A—for Add mode. Returns U –for Update mode

50) How is the searchinit event most often used by people soft application?

A) Searchinit fires before the search dialogue page is displayed to the end use. For this reason searchinit is often used to enhance row level security by inserting and graying out certain values to the search dialogue page.

FAQ

What is PS Query in PeopleSoft?

How do you create a PS query in PeopleSoft?

1. Select Reporting Tools > Query > Query Manager.
2. Click the Create New Query link.
3. Click the Search button.

What are the SQL interview questions?

• What is Database? …
• What is DBMS? …
• What is RDBMS? …
• What is SQL? …
• What is the difference between SQL and MySQL? …
• What are Tables and Fields? …
• What are Constraints in SQL? …
• What is a Primary Key?

How do you run a query in Photoshop?

• What is Database? …
• What is DBMS? …
• What is RDBMS? …
• What is SQL? …
• What is the difference between SQL and MySQL? …
• What are Tables and Fields? …
• What are Constraints in SQL? …
• What is a Primary Key?