-
-
-
What event gets fired after DB Update?
SavePostChange
-
PeopleCode events pertaining to Record Field?
FieldEdit, SaveEdit and RowDelete
-
Which of the following are Record field events ?
FieldChangeSearchSave and SavePreChange
-
Which of the following are true with respect to validate sign on with database option enabled in psadmin?
1. The application server first attempts to connect to database using the user id and password as part of the database connection string.2. User must be defined on either the operating system or the database and within the PeopleSoft.
-
-
When you alter a table (adding few fields or deleting fields from record)with out lossing the data what you will do?
Zoheir
- Apr 23rd, 2008
When you build the table, check the Alter table option, and in options under Alter tables tab, select alter with table rename.Once you build the project, then run the script to alter the tableThis will keep all the data.
sriram kammisetty
- Oct 10th, 2006
While building the record options select Alter table Chekc box.
-
People tools versions
What are the differences that can be seen with the People tools 8.46 version compared to the Tools 8.42 release?
peoplesoft1982
- Jun 19th, 2008
8.42Change Assistent tool and Purge cache not avaliable.8.46Purge cache option avaliable in Peoplesoft Administraton Domain menuChange assistent tool avaliable in $PS_HOME
sameer6893
- May 4th, 2008
The best way to find out differrences is to analyse rel DMS scripts from 8.42 to 8.46 like rel843.dms etc.
-
Which of the Following are true for force Shutdown In PeopleSoft Domain Shutdown menu?
1. shuts down the domain using the tmshutdown -k TERM -c command.2. A forced shutdown is a non-quiescent shutdown that immediately terminates all the processes
rajeevtyagi2003
- Jul 18th, 2008
A forced shutdown is a nonquiescent shutdown that immediately terminates all of the processes in the domain. Normally, you use the forced shutdown only when a Bulletin Board Liaison (BBL) process encounters errors and cannot be shut down by using a normal shutdown.
-
Regarding One to Many Relationship?
baslove
- Oct 29th, 2008
The relationship between a database server and an application server is a one-to-many model.That is, a single database server can have multiple application servers connecting to it. Thedatabase server...
-
You have downloaded an Application fix as a project from the customer connection. Where would you upgrade it to ?
Demo
-
Why we are comparing objects before and after migration?
gauravm0602
- Dec 29th, 2010
We need to compare the peoplesoft objects by generating compare report before and after migration using Application Designer:We need to notice two things in the Appdesigner:1)the UPGRADE tab should be checked2)the DONE tab should be unchecked
SARAVANAN.G
- Nov 16th, 2006
We should compare objects before and after migration to ensure whether all objects are migrated successfully or not.Because sometimes developers may forget to include a particular object&nb...
-
PIA Components
-
Which one of the following steps is NOT part of performing an upgrade?
Apply all outstanding patches, prior to upgrade.
-
-
In REN Server, How would you allocate buffer size?
BULLI
- Nov 2nd, 2011
2. In REN Server, How would you allocate buffer size?... ANS :You can set io_buffer_size parameter of PSRENSRV section in psappsrv,cfg file. Ex., [PSRENSRV] ;=====================================...
jvilango
- Nov 9th, 2006
You can set io_buffer_size parameter of PSRENSRV section in psappsrv,cfg file. Ex.,[PSRENSRV];=========================================================================; Event notification server...
-
What are the status available in PeopleSoft Domain Status Menu?
Server, Client and Queue Status
-
Customization done in Dev DB, Which tool i will use to move it to Prod DB?
Use App Designer -> Copy DB
jkanive
- Feb 23rd, 2012
The tool for migration will depend on the type of customization.
If the changes are data related then you can create Data Mover scripts. If its PeopleSoft Object then it can be moved using the App Designer. Its is assumed that it is tested and staged in UAT before moving to Prod.kasmita
- Aug 23rd, 2011
Application Disgner : To move customization from Dev to prod database
Or You can user Questat tool to move customization from one database to other. -
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 _TAO You 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
MBKUL
- Aug 10th, 2012
Before asking the DBA to truncate the table, we can check the number of rows in that table, followed by table truncation, and for stats we can populate fake stats using the row count number before table truncation.
amgill
- Sep 29th, 2009
One way to handle such temp tables is to delete stats and then lock stats so that the scheduled update stats job does not update stats on them. One example I have is the PS HRMS (Oracle DB), &quo...
Peoplesoft Admin Interview Questions
Ans