Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.

A Peoplecode Program Is Automatically Saved To A File While You're Working On It. This Checkpoint Will Not Occur At Which The Following Times:?

Answer»

EVERY 5 MINS

Every 5 Mins

2.

Peoplecode Attached With Push Button Can Be Associated With Which Of The Following Events?

Answer»

FIELD EDIT, Field CHANGE

Field Edit, Field Change

3.

In Which Peoplecode Event Does All Data Validation Take Place?

Answer»

FieldEdit

FieldEdit

4.

People Soft Allows Multiple Long Fields Per State Record?

Answer»

False

False

5.

Ae Does Parse Sql?

Answer»

False

False

6.

We Define Business Rules Peoplecode On?

Answer»

EVENT DEFINITION

event definition

7.

Which Of The Following Record Is Not Found In Database?

Answer»

DERIVED WORK RECORD

Derived work record

8.

What Is The Logic Used By Component Buffer?

Answer»

DEPTH FIRST ALGORITHM

Depth First Algorithm

9.

Two Program Views Of Ae Program?

Answer»

DEFINITION, PROGRAM FLOW

Definition, Program flow

10.

Query Is Split Into What?

Answer»

COMPONENT and QUERY VIEW

Component and Query view

11.

Menu Path Provides Path To?

Answer»

Component

Component

12.

When Auto-join Check Box Is Checked What Does It Mean?

Answer»

COMMON KEY FIELDS

Common key fields

13.

An Employee Is Transferred Where Should He Refer In This Aspection?

Answer»

BUSINESS PROCESS

Business Process

14.

What Are Destructive Statements In Sql?

Answer»

15.

In Two Tier Mode Where Does Authentication Happens?

Answer»

APPLICATION SERVER

Application Server

16.

Where Do Peopletools Data Is Cached?

Answer»

APP SERVER

app server

17.

What Is The Minimum Number Of Objects An Object Group Can Consist Of?

Answer»

1 19.

1 19.

18.

How Do You Login Into Bs Mode?

Answer»

DB ACCESS ID

DB Access Id

19.

Activate Event Is Valid For Following?

Answer»

STANDARD & SECONDARY

Standard & Secondary

20.

What Is The Output When Query Is Split?

Answer»

COMPONENT and QUERY VIEW

Component and Query view

21.

What Does Er Diagrams Represent?

Answer»

a) Graphical Representation of Business PROCESS and Relations
b) FLOWCHART of TABLES and Fields

a) Graphical Representation of Business process and Relations
b) Flowchart of tables and Fields

22.

What Are The Uses Of Process Profile?

Answer»

(SCENARIO based on PROCESS PROFILE / process group) SERVER o/p path override, process he can access.

(Scenario based on process profile / process group) Server o/p path override, process he can access.

23.

Which Of The Above Record Definitions Is Not Stored On The Database And Therefore Not Required To Build?

Answer»

DERIVED Work RECORD DEFINITIONS not stored in the database and not require for build. When a BUSINESS requirement in Fit/Gap Analysis does not meet by PeopleSoft then go for customizations through CONSULTANTS

Derived Work Record definitions not stored in the database and not require for build. When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then go for customizations through Consultants

24.

What Are The Search Keys You Use To Find Patches And Fixes?

Answer»

REPORT ID DATE RELEASE

Report id date release

25.

What Are The People Tools Available For Integration Broker?

Answer»

The tools AVAILABLE are APPLICATION designer and Integration Broker SETUP on the Portal. In peopleSoft, 8,48 MESSAGES and Queues can be created from the Setup itself.

The tools available are Application designer and Integration Broker Setup on the Portal. In peopleSoft, 8,48 messages and Queues can be created from the Setup itself.

26.

Sysaudit Finds For?

Answer»

ORPHANED OBJECTS

Orphaned Objects

27.

Which Of The Following Commands Can Be Run In Bootstrap Mode?

Answer»

BOOTSTRAP mode is actually logging into the App DESIGNER in 3-tier mode i.e. Logon to the App SERVER. Data mover SCRIPTS are RUN on 3-tier mode.

Bootstrap mode is actually logging into the App designer in 3-tier mode i.e. Logon to the App server. Data mover scripts are run on 3-tier mode.

28.

Which Of The Following Fires After The Database Is Updated?

Answer»

SavePostChange

SavePostChange

29.

What Are The Record Field Events?

Answer»

1. FieldChange
2. FieldDefault
3. FieldEdit
4. FieldFormula
5. PrePopup
6. RowDelete
7. RowInit
8. RowInsert
9. RowSelect
10. SaveEdit
1 1. SavePostChg
12. SavePreChg
13. SearchInit
14. Search Save
IS. Workflow

1. FieldChange
2. FieldDefault
3. FieldEdit
4. FieldFormula
5. PrePopup
6. RowDelete
7. RowInit
8. RowInsert
9. RowSelect
10. SaveEdit
1 1. SavePostChg
12. SavePreChg
13. SearchInit
14. Search Save
IS. Workflow

30.

Which Rdbms Uses Table Space?

Answer»

ORACLE, DB2, INFORMIX

Oracle, db2, Informix

31.

How Do You Set Up Table Sharing In Peopletools Applications?

Answer»

SETTD

SETTD

32.

What Is The Purpose Of State Record?

Answer»

State Records are used in AE to PASS values from action and section to the other. It also ALLOWS you to RESTART the App engine. For this, the State record has to be a SQL table. A state record either can be an SQL table or derived Work record. Process_instance FIELD is mandatory in the State Record.

State Records are used in AE to pass values from action and section to the other. It also allows you to restart the App engine. For this, the State record has to be a SQL table. A state record either can be an SQL table or derived Work record. Process_instance field is mandatory in the State Record.

33.

Tell Me Your Experience With Ci?

Answer»

CI’s can be used to UPLOAD data from LEGACY systems through excel to CI or create new data within PEOPLESOFT from ANOTHER component.

CI’s can be used to upload data from legacy systems through excel to CI or create new data within PeopleSoft from another component.

34.

What Is The Performance Tuning Of Sqr?

Answer»

1. USE Load-lookup and ARRAYS
2. Use SQT files.
3. Generate multiple reports.
4. Use correct sql joins.

1. Use Load-lookup and Arrays
2. Use SQT files.
3. Generate multiple reports.
4. Use correct sql joins.

35.

What Is The Difference Between Saveedit And Fieldedit?

Answer»

Field Edit VALIDATE PARTICULAR field only, but SAVE Edit validates all the FIELDS in that component.

Field Edit Validate particular field only, but Save Edit validates all the fields in that component.

36.

What Are The Differences Between Ae And Sqr?

Answer»

AE is built on PeopleSoft PROPRIETARY LANGUAGE called People Code, where as SQR is a THIRD party tool.

AE is built on PeopleSoft proprietary language called People Code, where as SQR is a third party tool.

37.

What Is Record. Row Peoplecode?

Answer»

Record peoplecode is triggered whenever you deal with the record. EX when u right a PIECE of code on Record Field CHANGE that code is FIRED whenever the Field is CHANGED in any page. There is nothing called ROW PeopleCode.

Record peoplecode is triggered whenever you deal with the record. EX when u right a piece of code on Record Field change that code is fired whenever the Field is changed in any page. There is nothing called Row PeopleCode.

38.

How Do You Retrieve A Value From Scroll.scroll Select?

Answer»

Scrollselect (1, targetname, recordfiledname)

Scrollselect (1, targetname, recordfiledname)

39.

What Is The Difference Between Sql Statements And Metasql Statements?

Answer»

SQL STATEMENTS are Database SPECIFIC whereas meta-SQL statements are DB INDEPENDENT.

SQL statements are Database specific whereas meta-SQL statements are Db independent.

40.

What Are The Different Ways To Run Ae, Sqr?

Answer»

2-tier, 4-tier, PROCESS SCHEDULER

2-tier, 4-tier, process scheduler

41.

How Do You Delete A File Using Sql?

Answer»

DELETE($FILENAME)

delete($filename)

42.

The Trace Tab In Configuration Manager Only Traces Windows Client (two-tier) Interactions. True Or False

Answer»

True

True

43.

What The Following Command Will Do? (psadmin -p Start -d Hrdmo)

Answer»

STARTS a PROCESS SCHEDULER

Starts a Process Scheduler

44.

Which Of The Task Cannot Be Done Through Psadmin?

Answer»

STARTING WEB SERVER

Starting Web Server

45.

What Is The Result Of The Search With The Following Criteria In Ps Books?

Answer»

SQL Table OR FIELD

SQL Table OR Field

46.

The Application Server Dynamically Scales Server Processes According To The Volume Of Transaction Requests, Which Is Known As?

Answer»

Spawning

Spawning

47.

Where Do You Create The Process Security Groups?

Answer»

SECURITY ADMINISTRATOR 20

Security Administrator 20

48.

What Is The Event That Fires After All Database Updates?

Answer»

SAVE POST CHANGE

Save post change

49.

In Which One Of The Following Views Would You See The Fields, Criteria, And Other Details Associated With The Current Query?

Answer»

QUERY VIEW 9

Query view 9

50.

Peoplesoft Tracks Object Changes Using A System Table. Which Peopletools System Table Is Used To Track Object Changes?

Answer»

PSRELEASE

PSRELEASE