Placement Papers - ORACLE

Why ORACLE Placement Papers?

Learn and practice the placement papers of ORACLE and find out how much you score before you appear for your next interview and written test.

Where can I get ORACLE Placement Papers with Answers?

IndiaBIX provides you lots of fully solved ORACLE Placement Papers with answers. You can easily solve all kind of placement test papers by practicing the exercises given below.

How to solve ORACLE Placement Papers?

You can easily solve all kind of questions by practicing the following exercises.

PeopleSoft Interview Questions - Answers Set - 1 (Oracle)

Posted By : Niti Rating : +21, -4
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?

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

How will you get a single output by combining two or more queries?

What BEA product is used for DB transaction in PS?

Which one of the following Data Types is NOT supported by the PeopleCode programming environment?

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?

What event gets fired after DB Update?

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 ?

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?

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?

Which process is used for running AE programs which are to be run at a frequency of less than a day ?

You can specifically trace the activity of the PSAPPSRV server process by setting the?

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?

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

Like this page? +21 -4

Companies List:

3i Infotech - AAI - ABACUS - ABB - Accel Frontline - Accenture - Aditi - Adobe - ADP - Agreeya - Akamai - Alcatel Lucent - Allfon - Alumnus - Amazon - Amdocs - AMI - Andhra Bank - AppLabs - Apps Associates - Aricent - Ashok Leyland - Aspire - Atos Origin - Axes - Bajaj - Bank of Maharashtra - BEL - BEML - BHEL - BirlaSoft - Blue Dart - Blue Star - BOB - BPCL - BPL - Brakes - BSNL - C-DOT - Cadence - Calsoft - Canara Bank - Canarys - Capgemini - Caritor - Caterpillar - CDAC - CGI - Changepond - Ciena - Cisco - Citicorp - CMC - Consagous - Convergys - CORDYS - Crompton - CSC - CTS - Cummins - Dell - Deloitte - Delphi-TVS - DeShaw - Deutsche - Dotcom - DRDO - EDS - EIL - ELGI - ELICO - ERICSSON - Essar - Fidelity - Flextronics - Freescale - FXLabs - GAIL - GE - Genpact - Geodesic - Geometric - Globaledge - GlobalLogic - Godrej - Google - Grapecity - HAL - HCL - Hexaware - Honeywell - HP - HPCL - HSBC - Huawei - Hughes - IBM - IBS - ICICI - iGate - Impetus - iNautix - Indian Airforce - Indian Airlines - Infosys - Infotech - Intec - Integra - Intergraph - IOCL - iSOFT - ISRO - Ittiam - JSW - Keane - Kenexa - L & T - L & T Infotech - LG Soft - Lifetree - LionBridge - Mahindra Satyam - Mastek - Maveric - McAfee - MECON - Microsoft - MindTree - Miraclesoft - Mistral - Motorola - Mphasis - MTNL - NIC - Nokia Siemens - Novell - NTPC - Nucleus - ORACLE - Patni - Perot - Polaris - Ramco - Robert Bosch - Samsung - SAP - Sapient - Sasken - SBI - Sierra Atlantic - Sonata - Sony India - Sutherland - Syntel - TCS - Tech Mahindra - VeriFone - Virtusa - Wipro - Zensar.