Placement Papers - ORACLE
PeopleSoft Interview Questions - Answers Set - 3 (Oracle)
Posted by :
Y Krishnakumar
(12)
PeopleSoft Interview Questions - Answers Set - 3
You just finished customization work that involved the creation of many new objects. You must now migrate these objects from your development database (source) to a testing database (target) to conduct more elaborate testing.Referring to the above information, why would adding your objects to a Project streamline the migration to a new database?
Projects provide the ability to migrate all objects at once or each object type individually. *
Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
Process Scheduler, Use, Process Definitions
Trace 255 command line option produces the trace file with the name?
PID.AET
Where can u see the status of the job report and details in secured way?
Process monitor
Non Repudiation property can be set?
PIA-.PeopleTools-> Integration Broker->Node DefinitionApplication Designer->Message ->Properties
If you delete a page from PSPT application which all tables are affected ??
People Tools
If u change the long name of translate field what object to be altered?
Page def
When do configuration changes made using the configuration Manager take effect?
Once you exit PeopleSoft and log back in.
Which one of the following is NOT a valid PeopleSoft query type?
Message agent queries
Interlink data type can be declared as?
Local
The following ApiObject data type objects can?t be declared as Global:?
JavaObject
PeopleSoft?s hub to handle complex system-to-system interactions.?
Integration Broker
Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000. Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time, you decide to use PeopleSoft query. Referring to the above, what function would you use, in combination with the aggregate function "Minimum" to produce the result set required?
HAVING CRITERIA 18.
DoSave( ) can be called from one of the following events?
FieldEdit, FieldChange, MenuItemSelected MenuItemSelected, Save Prechange & SavePostChange
In which PeopleCode event does ALL data validation take place?
FieldEdit
Peoplecode attached with Push Button can be associated with which of the following events?
Field Edit, Field Change
People Soft allows multiple long fields per State Record?
False
AE does Parse SQL?
False
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:?
Every 5 Mins
We define business rules PeopleCode on?
event definition
Which of the following record is not found in database?
Derived work record
What is the logic used by Component Buffer?
Depth First Algorithm
Two Program views of AE Program?
Definition, Program flow
You have 3 App. Servers where do you define the Failover.?
Configuration Properties
Query is split into what?
Component and Query view
Menu path provides path to?
Component
You can assign multiple databases and application servers to a single profile. But, each database and application server must be assigned to only one profile?
True
The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions?
True
TriggerBusinessEvent is used for triggering the workflow and its written on workflow event. TriggerBusinessEvent has the syntax?
TriggerBusinessEvent(BusProcess,BusActivity,BusEvent);
The following is an entry from the application reviewer LOG File: start Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4 Source=233What does the Source=233 parameter in the above LOG file entry identify?
The statement being executed is line 233 of the PeopleCode program.
One-to-Many?
Table 1 relates to 0,1 or many records in Table2, Table 2 relates to Table1 as one and only one table.
What the following command will do? psadmin -p start -d hrdmo?
Starts a Process Scheduler
Which of the Task cannot be done through PSADMIN?
Starting Web Server
Activate Event is Valid for following?
Standard & Secondary
What is the result of the search with the following criteria in PS Books?
SQL Table OR Field
What category of commands can be executed in data mover?
Sql , data mover commands
The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:PSHrmsSqrWhat do the above SQR flags signify to the SQR Report Writer upon execution?
Specifies the output path
The application server dynamically scales server processes according to the volume of transaction requests which is known as?
Spawning
Where do you create the process security groups?
Security Administrator 20
What is the event that fires after all database updates are over?
Save post change
In which one of the following views would you see the fields, criteria, and other details associated with the current query?
Query view 9
From the following statements which one is NOT true about Pub Broker?
Pub Broker is invoked after Pub Contractor Handler evaluates routing rules and writes contract(s)
From the following statements which one is NOT true about Pub Broker?
psserver in configuration properties
PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
PSRELEASE
PeopleSoft has its own naming convention for system and non-system (application) 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?
PSRECORDNAME
Which is a record that PeopleTools adds to every level of the Message Structure during processing?
PSCAMA
What is the configuration file that contains the entire collection configuration values for a given application server domain?
PSAPPSRV.CFG
Which command shuts down an application server domain using a ?forced? shutdown method?
psadmin -c shutdown! -d ps800dmo
The DB User mentioned in Connect ID should have permission to which Three PeopleSoft Tables?
PSACCESPRFLPSSTATUS PSOPRDEFN
PeopleSoft has its own naming convention for system and non-system (application) 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 non-system(application) tables?
PS_RECORDNAME
The initial values that you see in PSADMIN are derived from the configuration template that you select when you create your domain. Where these templates reside in the system?
PS_HOME/appserv in the Application Server
You just finished customization work that involved the creation of many new objects. You must now migrate these objects from your development database (source) to a testing database (target) to conduct more elaborate testing.Referring to the above information, why would adding your objects to a Project streamline the migration to a new database?
Projects provide the ability to migrate all objects at once or each object type individually. *
Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
Process Scheduler, Use, Process Definitions
Trace 255 command line option produces the trace file with the name?
PID.AET
Where can u see the status of the job report and details in secured way?
Process monitor
Non Repudiation property can be set?
PIA-.PeopleTools-> Integration Broker->Node DefinitionApplication Designer->Message ->Properties
If you delete a page from PSPT application which all tables are affected ??
People Tools
If u change the long name of translate field what object to be altered?
Page def
When do configuration changes made using the configuration Manager take effect?
Once you exit PeopleSoft and log back in.
Which one of the following is NOT a valid PeopleSoft query type?
Message agent queries
Interlink data type can be declared as?
Local
The following ApiObject data type objects can?t be declared as Global:?
JavaObject
PeopleSoft?s hub to handle complex system-to-system interactions.?
Integration Broker
Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000. Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time, you decide to use PeopleSoft query. Referring to the above, what function would you use, in combination with the aggregate function "Minimum" to produce the result set required?
HAVING CRITERIA 18.
DoSave( ) can be called from one of the following events?
FieldEdit, FieldChange, MenuItemSelected MenuItemSelected, Save Prechange & SavePostChange
In which PeopleCode event does ALL data validation take place?
FieldEdit
Peoplecode attached with Push Button can be associated with which of the following events?
Field Edit, Field Change
People Soft allows multiple long fields per State Record?
False
AE does Parse SQL?
False
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:?
Every 5 Mins
We define business rules PeopleCode on?
event definition
Which of the following record is not found in database?
Derived work record
What is the logic used by Component Buffer?
Depth First Algorithm
Two Program views of AE Program?
Definition, Program flow
You have 3 App. Servers where do you define the Failover.?
Configuration Properties
Query is split into what?
Component and Query view
Menu path provides path to?
Component
You can assign multiple databases and application servers to a single profile. But, each database and application server must be assigned to only one profile?
True
The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions?
True
TriggerBusinessEvent is used for triggering the workflow and its written on workflow event. TriggerBusinessEvent has the syntax?
TriggerBusinessEvent(BusProcess,BusActivity,BusEvent);
The following is an entry from the application reviewer LOG File: start Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4 Source=233What does the Source=233 parameter in the above LOG file entry identify?
The statement being executed is line 233 of the PeopleCode program.
One-to-Many?
Table 1 relates to 0,1 or many records in Table2, Table 2 relates to Table1 as one and only one table.
What the following command will do? psadmin -p start -d hrdmo?
Starts a Process Scheduler
Which of the Task cannot be done through PSADMIN?
Starting Web Server
Activate Event is Valid for following?
Standard & Secondary
What is the result of the search with the following criteria in PS Books?
SQL Table OR Field
What category of commands can be executed in data mover?
Sql , data mover commands
The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:PSHrmsSqrWhat do the above SQR flags signify to the SQR Report Writer upon execution?
Specifies the output path
The application server dynamically scales server processes according to the volume of transaction requests which is known as?
Spawning
Where do you create the process security groups?
Security Administrator 20
What is the event that fires after all database updates are over?
Save post change
In which one of the following views would you see the fields, criteria, and other details associated with the current query?
Query view 9
From the following statements which one is NOT true about Pub Broker?
Pub Broker is invoked after Pub Contractor Handler evaluates routing rules and writes contract(s)
From the following statements which one is NOT true about Pub Broker?
psserver in configuration properties
PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
PSRELEASE
PeopleSoft has its own naming convention for system and non-system (application) 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?
PSRECORDNAME
Which is a record that PeopleTools adds to every level of the Message Structure during processing?
PSCAMA
What is the configuration file that contains the entire collection configuration values for a given application server domain?
PSAPPSRV.CFG
Which command shuts down an application server domain using a ?forced? shutdown method?
psadmin -c shutdown! -d ps800dmo
The DB User mentioned in Connect ID should have permission to which Three PeopleSoft Tables?
PSACCESPRFLPSSTATUS PSOPRDEFN
PeopleSoft has its own naming convention for system and non-system (application) 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 non-system(application) tables?
PS_RECORDNAME
The initial values that you see in PSADMIN are derived from the configuration template that you select when you create your domain. Where these templates reside in the system?
PS_HOME/appserv in the Application Server
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers