PeopleSoft MCQ Questions and Answers for Practice

1. Where are definitions used to create fields on a page in the user interface and columns in application data tables stored?

1. PSFIELD
2. PSDBFIELD
3. PSRECFIELD
4. PS_DBFIELD

2. The definitions that make up a PeopleSoft Application are stored in?

1. PEOPLETOOLS TABLES
2. APPLICATION TABLES
3. PEOPLETOOLS CATALOG
4. SYSTEM CATALOG

3. The Application Data is Cached in?

1. Application server
2. Web Server
3. Batch Server
4. None of these

4. PeopleSoft has its own naming convention for system and non-system tables. In the list below, RECORDNAME refers to the name of any table or record. Referring to the above information, which one of the following identifies the naming convention PeopleSoft uses for system tables?

1. PS_RECORDNAME
2. SYSRECORDNAME
3. PSRECORDNAME
4. PS$RECORDNAME

5. What is the record field property that should be set to validate dates for <> 30 days?

1. Setting %Date as constant
2. Required
3. Specifying Default using Record and Field values
4. Reasonable date

6. What are the requirements of an effective dated table?

1. Define EFFDT
2. Define EFF_STATUS
3. Define EFFDT as key, in ascending order
4. Define EFFDT as key, in descending order

7. EFFDT cannot occur at what occurs levels?

1. 1
2. 2
3. 3

8. What type of a field can have Auto Update?

1. CHAR
2. LONG CHAR
3. DATE
4. NUMBER

9. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?

1. SYSRELEASE
2. SYSOBJECTS
3. PSRELEASE
4. PSOBJECTS

10. When can a value be added in the underlying table?

1. Prompt Table with Edit
2. Translate Table with Edit
3. Prompt Table with No Edit
4. Yes/No Edit

11. Which of the following record definitions is NOT stored on the database and is therefore NOT required to be built?

1. View
2. Query View
3. SQL Table
4. Derived / Work Record

12. Audits can be implemented at the following levels

1. Field
2. Page
3. Record
4. Field and Record