Placement Papers - ORACLE
PeopleSoft Interview Questions - Answers Set - 1 (Oracle)
Posted by :
NITI
(21)
PeopleSoft Interview Questions - Answers Set - 1
The main attributes of a Component Interface (CI) are?
Keys, Properties & Collections, Methods and Name
Which one of the following are standard properties when a Component Interface (CI) is created?
GetHistoryItems
With reference to the Component Interface Tester which of the following is NOT TRUE?
GetExisting option is equivalent to opening a record in Update/Display Mode only
Which of the following are TRUE when a Component Interface (CI) is created on component that has Add action enabled?
Get keys, Create keys and Find keys gets created automaticallyThe Create method is created alongwith the other Standard methods for the CI
Which of the following can be mapped as Find Keys for a Component Interface ?
A OR b
Which of the following is NOT TRUE in Component Interface (CI) Architecture?
A component interface can be mapped to multiple PeopleSoft components
The following are various steps that describes the peoplecode logic while implementing a Component Interface:-
1.Establish a user session
2.Get the Component Interface
3.pulate the Create Keys
4.eate an Instance of the CI
5.pulate the required fields
6. Save the CI
Will Tuxedo continue to be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
Yes. WebSphere or WebLogic are used as the HTTP server and servlet engine. They are not used as middleware with the PeopleSoft Application Server. Tuxedo is always used with PIA, regardless of the HTTP server or Java servlet engine.
Can a PeopleTools 8.4 and a PeopleTools 8.1x database run on the same machine?
Yes, databases can co-exist on the same physical machine. In most cases, thedatabases themselves can exist within the same RDBMS, however, it isimportant to verify that the database version required by PeopleTools 8.4 is thesame as for the current PeopleTools 8.1x implementation.
Question based on changing prompt table, what happens when changing from NO EDIT TO EDIT option?
user can type only prompt table values and the default values gets populated from the database.
Customization done in Dev DB, Which tool i will use to move it to Prod DB?
Use App Designer -> Copy DB
Your Onsite DBA has called you up and told you that one of the tables PS_ABC_TAO has grown very big in size. Based on the standard naming convention, you have determined that the record is a temporary record since it ends with _TAOYou look into the database and decide that that the data is not required any more. You ask the DBA to delete the data in the table. Next day you get a call from an irritated user who says that a daily process that took only 1 minute to run is taking about 2 hours today. You look into his process and find that it uses PS_ABC_TAO as a temporary table.
What would you suggest the DBA to do ?
Update statistics on the table
(Some scenario) Question relating DBA Purging Temporary Table?
Update Statistics
How many Message nodes are possible for a database.?
Unlimited
How will you get a single output by combining two or more queries?
UNION
What BEA product is used for DB transaction in PS?
Tuxedo
Which one of the following Data Types is NOT supported by the PeopleCode programming environment?
TIMESTAMP
What hyperlinks available in PeopleBooks? Some options with different hyperlinks not available in peoplebooks, select the correct one?
Study all hyperlinks in the first page of people books.
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
When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then?
Some options:1. Customize PS application (Yes)2. Buy third party software (Yes)3. Call PS Development Center for Enhancement (Yes)
What are the status available in PeopleSoft Domain Status Menu?
Server, Client and Queue Status
Which of the following are part of an AE program ?
Section ,Step and Action
Which of the following fires after the database is updated?
SavePostChange
What event gets fired after DB Update?
SavePostChange
For downloading patches and fixes , you have gone to the customer connection and looking under 8 april, 2000 and see Report IDS like R-CCHEN-VP14JM. What does R stand for ?
Released
In which one of the following views would you see the fields, criteria, and other details associated with the current query?
Query view
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 process is used for running AE programs which are to be run at a frequency of less than a day ?
PSDAEMON
You can specifically trace the activity of the PSAPPSRV server process by setting the?
PSAPPSRV.tracesql
Which of the following is correct in order to start the Process Scheduler Server from the command line using psadmin.?
Psadmin ?p start ?d
In the following url http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHEDULER.PRCSTYPEDEFN.GBLwhich one is the component definition?
PRCSTYPEDEFN.GBL
I have created a Menu and a Page and given user access to that page, which of the tables gets affected on this (Scenario)?
PeopleTools Tables
You are a PeopleSoft Partner and wish to get information on database performance benchmark ( or something like this)Where would you look for the info ?
PeopleSoft Knowledge base
SYSAUDIT finds for
Orphaned Records
The main attributes of a Component Interface (CI) are?
Keys, Properties & Collections, Methods and Name
Which one of the following are standard properties when a Component Interface (CI) is created?
GetHistoryItems
With reference to the Component Interface Tester which of the following is NOT TRUE?
GetExisting option is equivalent to opening a record in Update/Display Mode only
Which of the following are TRUE when a Component Interface (CI) is created on component that has Add action enabled?
Get keys, Create keys and Find keys gets created automaticallyThe Create method is created alongwith the other Standard methods for the CI
Which of the following can be mapped as Find Keys for a Component Interface ?
A OR b
Which of the following is NOT TRUE in Component Interface (CI) Architecture?
A component interface can be mapped to multiple PeopleSoft components
The following are various steps that describes the peoplecode logic while implementing a Component Interface:-
1.Establish a user session
2.Get the Component Interface
3.pulate the Create Keys
4.eate an Instance of the CI
5.pulate the required fields
6. Save the CI
Will Tuxedo continue to be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
Yes. WebSphere or WebLogic are used as the HTTP server and servlet engine. They are not used as middleware with the PeopleSoft Application Server. Tuxedo is always used with PIA, regardless of the HTTP server or Java servlet engine.
Can a PeopleTools 8.4 and a PeopleTools 8.1x database run on the same machine?
Yes, databases can co-exist on the same physical machine. In most cases, thedatabases themselves can exist within the same RDBMS, however, it isimportant to verify that the database version required by PeopleTools 8.4 is thesame as for the current PeopleTools 8.1x implementation.
Question based on changing prompt table, what happens when changing from NO EDIT TO EDIT option?
user can type only prompt table values and the default values gets populated from the database.
Customization done in Dev DB, Which tool i will use to move it to Prod DB?
Use App Designer -> Copy DB
Your Onsite DBA has called you up and told you that one of the tables PS_ABC_TAO has grown very big in size. Based on the standard naming convention, you have determined that the record is a temporary record since it ends with _TAOYou look into the database and decide that that the data is not required any more. You ask the DBA to delete the data in the table. Next day you get a call from an irritated user who says that a daily process that took only 1 minute to run is taking about 2 hours today. You look into his process and find that it uses PS_ABC_TAO as a temporary table.
What would you suggest the DBA to do ?
Update statistics on the table
(Some scenario) Question relating DBA Purging Temporary Table?
Update Statistics
How many Message nodes are possible for a database.?
Unlimited
How will you get a single output by combining two or more queries?
UNION
What BEA product is used for DB transaction in PS?
Tuxedo
Which one of the following Data Types is NOT supported by the PeopleCode programming environment?
TIMESTAMP
What hyperlinks available in PeopleBooks? Some options with different hyperlinks not available in peoplebooks, select the correct one?
Study all hyperlinks in the first page of people books.
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
When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then?
Some options:1. Customize PS application (Yes)2. Buy third party software (Yes)3. Call PS Development Center for Enhancement (Yes)
What are the status available in PeopleSoft Domain Status Menu?
Server, Client and Queue Status
Which of the following are part of an AE program ?
Section ,Step and Action
Which of the following fires after the database is updated?
SavePostChange
What event gets fired after DB Update?
SavePostChange
For downloading patches and fixes , you have gone to the customer connection and looking under 8 april, 2000 and see Report IDS like R-CCHEN-VP14JM. What does R stand for ?
Released
In which one of the following views would you see the fields, criteria, and other details associated with the current query?
Query view
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 process is used for running AE programs which are to be run at a frequency of less than a day ?
PSDAEMON
You can specifically trace the activity of the PSAPPSRV server process by setting the?
PSAPPSRV.tracesql
Which of the following is correct in order to start the Process Scheduler Server from the command line using psadmin.?
Psadmin ?p start ?d
In the following url http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHEDULER.PRCSTYPEDEFN.GBLwhich one is the component definition?
PRCSTYPEDEFN.GBL
I have created a Menu and a Page and given user access to that page, which of the tables gets affected on this (Scenario)?
PeopleTools Tables
You are a PeopleSoft Partner and wish to get information on database performance benchmark ( or something like this)Where would you look for the info ?
PeopleSoft Knowledge base
SYSAUDIT finds for
Orphaned Records
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers