Peoplesoft Interview Questions and Answers
Question - 111 : - How many types of RDBMS support PeopleSoft?
Answer - 111 : -
The following are the list of RDBMS supporting PeopleSoft application.
DB2, SQL Base, Oracle, Microsoft SQI Server, Informix
Question - 112 : - Define a Field, Field attributes, and Field properties?
Answer - 112 : -
Fields are basic building blocks in People soft and can be used in application when they are added to at least one record. Fields are globally defined.
The common filed attributes are:
1. Data type 2. Field name 3. Long name 4. Short name 5. Formatting 6. Help context number 7. Translate values – stored in separate table (XLATTABLE).
Fields are:
1.Globally defined
2.Reusable components and can be shared across multiple record definitions
3.A change to the Field properties affects all the records that include the field.
Question - 113 : - Explain briefly about record properties?
Answer - 113 : -
KEY: The record knows a field, which uniquely identifies each row, as a key.
- We will search and retrieve data from the database according to the key field.
- This will not allow duplicate and null values.
- It is a primary key
- It allows multiple keys
- Maximum keys allowed in a record is 15
- It should be placed at the top of the record definition.
Duplicate Order Key:
1. It provides a way of ordering data in the table when the duplicate values are allowed.
2. It will create index for the column. However the index can be disabled.
Alternate Search key:
1. it identifies the field as a key that provides an alternative path into table data.
2. Due to alternate search key the system becomes slow, because database index will be created when SQL creates the tables, so it will consume the disk space.
3. It allows duplicate values.
4. Alternate search will be seen in the search dialog box when update/display mode is selected.
Descending order key:
It is used to retrieve data in the form of 3-2-1 or C-B-A and normally it is used in Effective date.
Types of Menus?
Answer - 114 : -
1. Standard menu: It appears in the menu bar of a PeopleSoft application.
2. Popup menu: Allows the user to navigate related information in other areas of application by right clicking on a page or component.
Question - 115 : - What is the difference between Key and alternate search Key?
Answer - 115 : - KEY-It is the primary key of the record. Can be used as search key or need not be. Alternate search key-it is used for searching purposes.
Question - 116 : - Which effective dated rows can be retrieved in update/display mode, update/display all and correction mode?
Answer - 116 : -
- Update/display – can view current and future rows. Can update only future rows.
- Update/display all – can view history, current and future rows. Can update only future rows.
- Correction – can view and update history, current and future rows.
What are Table Edits?
Answer - 117 : - We have prompt table edit, yes/no table edit, translate table edit as the table edits.
Question - 118 : - What conditions are required to establish parent child relationship between two records? What are the advantages with that?
Answer - 118 : -
Conditions are:
1) The child record should have all the key fields of parent record and at least one more key field other than the key fields of parent record.
2) We should mention the parent record in the record properties of child record.
3) We cannot go for more than three levels of parent/child relationships.
Advantages are:
1) To have referential integrity.
2) Data dependencies
3) Eliminate redundant data
Question - 119 : - Can you place Sub page into Grid? If yes How?
Answer - 119 : - Yes we can insert subpage using insert subpage. After insert subpage into main page, drag the subpage into the grid. When we save the page we are successfully able to save the page showing that we can insert a subpage into a grid.