GeekInterview.com
Series: Subject: Topic:

Peoplesoft Admin Interview Questions

Showing Questions 1 - 20 of 89 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Sys audit finds for?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

Orphaned records

Answered by: pankaj on: Mar 13th, 2013

Any and all sys audit related discrepancies can and should be resolved using People Books Reference : How to Run SYS AUDIT report. For each discrepancy there is a specific set of actions and some of t...

Answered by: SRIKANTH on: Jan 17th, 2012

Orphaned Records

Data processing in peoplesoft

Asked By: sourya pattanayak | Asked On: Aug 3rd, 2011

How is data stored,retrieved,manipulated and processed in peoplesoft application?

Answered by: srinu on: Jan 14th, 2013

Synchronus Process

What commands are valid in bs mode?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

Encrypt_password

Answered by: Dhruv1212 on: Oct 16th, 2012

IGNORE_DUPS & UPDATE_STATISTICS

Answered by: Harish Mahanta on: Nov 10th, 2006

Ans:-  Grant User & ENCRYPT_PASSWORD

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...

Asked By: Interview Candidate | Asked On: May 6th, 2005

Update statistics on the table

Answered by: MBKUL on: 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.

Answered by: amgill on: 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...

Customization done in dev db, which tool I will use to move it to prod db?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

Use app designer -> copy db

Answered by: jkanive on: 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.

Answered by: kasmita on: 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.

Which of the following is correct in order to start the process scheduler server from the command line using psadmin?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

Psadmin –p start –d

Answered by: patil srikanth on: Jan 17th, 2012

Using tmadmin we can start the process scheduler
psadmin -p start -d database name.

What are the status available in peoplesoft domain status menu?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

Server, client and queue status

Answered by: patilsrikanth on: Jan 14th, 2012

1) Client status
2) Queue status
3) Server status

Not able to edit the voucher when voucher is in recycle status

Asked By: ramukarra | Asked On: Nov 22nd, 2011

Hi all, peoplesoft: I have created a voucher and voucher status is in recyle,all the voucher client has uploaded excel upload,but some voucher are error status due to combo ,we have asked the user to correct the account,but user able to edit few voucher which are in recycle status and few voucher not...

In ren server, how would you allocate buffer size?

Asked By: saran2g | Asked On: May 2nd, 2006

Answered by: BULLI on: 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] ;=====================================...

Answered by: jvilango on: Nov 9th, 2006

You can set io_buffer_size parameter of PSRENSRV section in psappsrv,cfg file.  Ex.,[PSRENSRV];=========================================================================; Event notification server...

How can we trace peoplecode in application engine program?

Asked By: Rimpal Johal | Asked On: May 8th, 2006

Answered by: bulli on: Nov 2nd, 2011

1.How can we trace PeopleCode in Application Engine ...

ans: In Config Mangager check the People code that need to trace

Regards

Answered by: Niraj Kumar on: Oct 20th, 2011

Go to below navigation: PeopleTools-> Process Schedular-> Processes. Enter Process name and then go to the override tab. Enter the trace option as per your requirement(below is an example) -TRACE 391 ...

How do you login into bs mode?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

Db access id

Answered by: Suresh Katreddi on: Sep 15th, 2011

Using Db owner id and Password

Answered by: kasmita on: Aug 23rd, 2011

Using Peolesoft Dababase SuperUser(Access id)

Which one of the following steps is not part of performing an upgrade?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

Apply all outstanding patches, prior to upgrade.

Answered by: gspradeep on: Sep 8th, 2011

we have to apply patches only after install new software . then we have to run ptpatches.dms to updaqte peopletools about it

Answered by: gspradeep on: Sep 8th, 2011

we have to apply patches only after installing new upgrade software .

Pia components

Asked By: kumar3207 | Asked On: Sep 22nd, 2008

What are the components of pia?

Answered by: kasmita on: Aug 23rd, 2011

PIA Components:-

3 mandatory components :

1) Web Server 2) Application Server 3) Database Server

Optional components

1) Batch Server

Answered by: Anmol.ece on: Aug 6th, 2009

PIA Components can be classified into
1. Web server
2. Application server
3. Batch server

Why we are comparing objects before and after migration?

Asked By: geetha | Asked On: Nov 1st, 2006

Answered by: gauravm0602 on: 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 checked
2)the DONE tab should be unchecked

Answered by: SARAVANAN.G on: 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...

You have downloaded an application fix as a project from the customer connection. Where would you upgrade it to ?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

Demo

Answered by: amitsk_00 on: Jul 9th, 2009

First it should be applied on DEMO and then to dev/test environments.

Regarding one to many relationship?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

Answered by: baslove on: 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...

Which RDBMS uses table space?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

Oracle, db2, other options: SQL server, informix, sybase

Answered by: sunil_ronanki on: Oct 16th, 2008

oracle

Which of the following are true for force shutdown in peoplesoft domain shutdown menu?

Asked By: Interview Candidate | Asked On: Sep 4th, 2004

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

Answered by: rajeevtyagi2003 on: 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.

People tools versions

Asked By: SaiKr | Asked On: Mar 22nd, 2007

What are the differences that can be seen with the people tools 8.46 version compared to the tools 8.42 release?

Answered by: peoplesoft1982 on: Jun 19th, 2008

8.42

Change Assistent tool and Purge cache not avaliable.

8.46

Purge cache option avaliable in Peoplesoft Administraton Domain menu

Change assistent tool avaliable in $PS_HOME

Answered by: sameer6893 on: 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.

When you alter a table (adding few fields or deleting fields from record)with out lossing the data what you will do?

Asked By: ramesh | Asked On: Aug 7th, 2006

Answered by: Zoheir on: 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 table
This will keep all the data.

Answered by: sriram kammisetty on: Oct 10th, 2006

While building the record options select Alter table Chekc box.

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.