Interview Questions.

Q1. What Are Table Edits?

We have spark off desk edit, sure/no table edit, trlate table edit as the table edits.

Q2. What Is An Array In People Code?

An array is a set of facts garage locations, every of which holds the same form of statistics.

The maximum intensity of a PeopleCode array is 15 dimensions.

Push and UnShift are the functions of the array used to add the factors into the array one from the quit of the array and one from the beginning.

Pop is a function of array used to select and delete an element from the stop of the array.

Q3. What Is Default Processing?

In default processing, any clean fields within the thing are set to their default value.

You can specify the default value either within the Record Field Properties, or in FieldDefault PeopleCode

Q4. When We Select A Component What Events Will Be Fired?

If default mode for element is seek mode:  simplest searchinit will fired.

If default mode for issue is new mode :subject default, discipline method, rowinit, searchinit.

Q5. What Are Classes In Peoplecode?

A class is the formal definition of an object and acts as a template from which an instance of an item is created at runtime.

The class defines the houses of the item and the methods used to control the object’s conduct.

PeopleSoft gives you predefined training (along with Array, File, Field, SQL, and so forth).

You can create your personal classes using the Application magnificence. You also can expand the functionality of the present training the usage of the Application elegance.

Q6. What Is Difference Between Saveprechange And Savepostchange? Which Function Directly Interacts With The Database?

Saveprechange—final event that executes earlier than updating the records from issue buffer to the database.

Savepostchange –fires after the updation of information in the database.

SQLEXEC — feature directly interacts with the database.

Q7. Can You Save The Component Programmatically?

Using Dosave and Dosavenow capabilities.

Q8. What Are Metastrings Or Metasql?

MetaStrings are special type of SQL expressions preceded by way of % sign.

MetaStrings are used in the following:

SQLExec

In utility designer to build dynamic views

With rowset item techniques (pick, fill)

SQL gadgets

Record elegance strategies (Insert, Update)

Application Engine

Cobol

Scroll buffer features (ScrollSelect and its relatives).

Some Record magnificence methods (Insert, Update, and so on.

Q9. What Are The Built-capabilities Used To Control Trlate Values Dynamically?

Adddropdownitem() Deletedropdownitem()

Q10. How To Populate Data Into Grid In Online?

&Rs.Select or Scrollselect()

Q11. What Is Record Group? Which Records Can Be Included Into A Record Group?

Record institution consists of facts with comparable capability.

To setup a record in record organization we should enter a fixed control field fee in file homes.

Q12. What Is Differed Processing And Its Advantages?

Postpones a few user actions to lessen the wide variety of trips to the database so that will increase the performance (in gadget edits, area edit, and subject exchange).

Advantages:

Reduces the network site visitors.

Increases the performance.

Q13. What Databuffer Classes Are Available In People Code?

Rowset

Row

Record

Field

Array

File

Sql

chart

grid and so on.

Q14. What Is Difference Between Getrowset And Createrowset In People Code?

Getrowset –is used to get rowset for a report within the factor buffer.

Createrowset—is used to create rowset for a document which in database, and is also known as a Standalone rowset

Q15. What Is Sub Page, Secondary Page In Peoplesoft?

A Sub Page is applied where you want to display or capture similar statistics for diverse entities,

for instance, taking pictures an address, for a organization or for a person, could want comparable records like Street cope with,State county, Country,Pincode etc.. In the ones situations a sub web page might be used, to layout once and reuse at more than one places.

A Secondary Page is used to display or seize secondary facts approximately an entity.A secondary page ought to use numerous sub pages, however the reverse is not proper.

Q16. Hot To Store Output Of A Sql Query In A Variable Using Peoplecode?

Using SQLExec Function

SQLExec (“SELECT EMPLID,NAME FROM PS_PERSONAL_DATA”, &Emplid, &Name);

Q17. What Is Difference Between Field Default And Row Init?

Field default specifies simplest the default price for a area whilst we are in Add mode.

Row init fires best while a row of facts coming from database to component buffer

Q18. What Is Pia And What Are Its Components?

It is n-tier structure. We have patron, web server, software server and Database server. We have jolt and tuxedo. We have WSL, WSH, JSL, JSH, QUEUES and offerings. In database server we've got system tables, peopletools tables and alertness tables.

Q19. Differentiate Field Edit And Save Edit?

In Field edit for each area change, a trition to the utility server to the database is taken region. In Saveedit for all the fields , simplest one trition to the application server to the Database is taken location.

Q20. What Is The Purpose Of The Sqlexec Function? What Are Its Benefits And Draw Backs?

 SQLEXEC is used to execute the sq. Statements(select,insert,update,delete). We can get only one row at a time.

Q21. What Is Auto Update In Peoplesoft?

This document area property is used to update the date subject of precise document with the server’s contemporary date and time each time a consumer creates or updates a row. Even the user enter the facts into that discipline, the facts which the user enters will be updated through the system’s current date and time.

Q22. What Is Getlevel0()? What Is The Use Of %subrec And %selectall Functions?

Getlevel0()— used to get the rowset of the extent@

%subrec    — is used most effective in Dynamic View SQL in which it expands to the columns of a subrecord:

%selectall–%SelectAll is shorthand for selecting all fields inside the distinct file, wrapping date/time fields with %DateOut, %TimeOut.

Q23. What Are The Rules Used By The System To Determine Whether A User Is Authorized To Update An Object?

The person need to have the permission to replace the object. This is given by way of the Definition security.

The organization, which holds the object, have to be brought to the permission list of the user in replace mode.

Q24. In Which Events Error & Warning Are Used Most Extensively?

Field edit

Save edit

Search save

row delete

row insert

Q25. What Are Different Variables In People Code And Their Scope?

System variables and User defined variables.

Scope

Global

Component

Local

Q26. Which Effective Dated Rows Can Be Retrieved In Update/display Mode, Update/show All And Correction Mode?

Update/show: can view present day and future rows. Can replace most effective future rows.

Update/display all: can view history, contemporary and future rows. Can update simplest destiny rows.

Correction: can view and replace history, present day and future rows.

Q27. Can You Place Sub Page Into Grid? If Yes How?

Yes we are able to insert subpage the use of insert subpage. After insert subpage into foremost page, drag the subpage into the grid. When we store the web page we are efficiently able to keep the web page displaying that we will insert a subpage right into a grid.

Q28. What Is An Expert Entry?

Expert entry enables a consumer to trade from interactive to deferred mode at runtime for appropriate tractions

Q29. What Types Of Audits Are Supported By People Soft?

We have discipline stage audit and record degree audit.

Q30. What Is The Use Of Primary Permission List In User Profile?

Primary permission list is used for mass trade and definition security purposes.

Q31. Why Do Peoplesoft Often Use Views As Search Records?

Search perspectives are used for 3 principal reasons.

Adding criteria to the hunt dialogue page

Providing row degree protection

Implementing search page processing

Q32. What Are The Different Ways We Can Set Up The Portal Security To Access Component In Portal?

Structure & content

Menu import

Register issue

Q33. What Is The Difference Between Sqlexec And Createsql?

SqlExec me it bypasses the component buffer and it's far without delay contacts database to retrieve statistics.

But it retrieves the records row by way of row and now not viable for bulk insert.

But in the case of Create SQL we will able insert the facts in bulk.

Q34. How To Give Access To The Records That Are To Be Used In A Query?

To provide get admission to to the records which are to be used in query, we've got create a brand new query safety tree and upload the statistics which we need to provide the access and then assign a get right of entry to group to the tree. After that we ought to upload that query tree and question get right of entry to organization to the permission list.

Q35. Is There Any Way By Which You Can Find Out Whether The User Is In Add Mode Or Update Mode?

%mode

Returns A—for Add mode.

Returns U — for Update mode

Q36. What Conditions Are Required To Establish Parent Child Relationship Between Two Records?What Are The Advantages With That?

Conditions are:

The baby record must have all of the key fields of figure record and at the least one extra key subject apart from the important thing fields of figure file.

We must mention the figure document within the file houses of child file.

We can't move for more than 3 ranges of figure/toddler relationships.

Advantages are:

To have referential integrity.

No need to enter facts again and again

Q37. In Case Of Record Level Audit What Is The Structure Of Table?

The structure of the desk in document stage audit is: AUDIT_OPRID, AUDIT_STAMP, AUDIT_ACTN, AUDIT_RECNAME and can add fields from report.

Q38. How Can A Component Have More Than One Search Record? Give A Situation?

You would possibly want to reuse the identical thing a couple of instances with exclusive seek records. You can accomplish this by using overriding the factor seek record at run-time whilst the issue is opened from a menu object without developing separate copies of the aspect.

The aspect override is temporary, and takes place simplest whilst the component is opened from the menu object in which the override is set. It does now not exchange the element definition.

Q39. What Are Think Time Functions?

Think-time functions suspend processing both till the consumer has taken a few motion (such as clicking a button in a message container), or until an external technique has run to final touch.

Q40. Can You Hide A Primary Page In A Component? Reason?

No we can't disguise the number one page of a thing. If the issue had handiest one page then by means of making this web page also invisible we wont have any aspect present so we are not allowed to cover the number one web page.

Q41. What Is The Difference Between Key And Alternate Search Key?

KEY-It is the primary key of the file. Can be used as seek key or need not be.

Alternate seek key-it's miles used for searching purposes.

Q42. What Is The Difference Between Component Buffer And Data Buffer?

Component buffer consists of all of the information of the energetic issue. Data buffer incorporates the statistics apart from the facts inside the thing buffer (Data of other facts)