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 Interview Questions and Answers

(Continued from previous question...)

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

(Continued on next question...)

Other Interview Questions

• The main attributes of a Component Interface (CI) are?
• 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?
• Which of the following are TRUE when a Component Interface (CI) is created on component that has Add action enabled?
• Which of the following can be mapped as Find Keys for a Component Interface ?
• Which of the following is NOT TRUE in Component Interface (CI) Architecture?
• The following are various steps that describes the peoplecode logic while implementing a Component Interface?
• Will Tuxedo continue to be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
• Can a PeopleTools 8.4 and a PeopleTools 8.1x database run on the same machine?
• Can a PeopleTools 8.4 and a PeopleTools 8.1xapplication server run on the same machine?
• How does the PeopleSoft Enterprise Portal workwith 8.1x and 8.4 applications?
• For the servlet layer on the web server, what version of the Java Servlet API are the PIA Java Servlets coded to with PeopleTools 8.4?
• IBM How should Web Application Servers be usedwith PeopleTools 8.1x and PeopleTools 8.4?
• Why did PeopleSoft bundle IBM WebSphere Advanced Single Server Edition rather than Advanced Edition?
• Will the PeopleSoft Internet Architecture, now that it embeds BEA WebLogic and IBM WebSphere, work with my other corporate web servers and tools?
• Is BEA WebLogic the same thing as the web server that was previously on the Tuxedo CD?
• Are disconnected mobile applications supportedin PeopleTools 8.1x?
• Is WebSphere certified on PeopleTools 8.1x?
• Is web server load balancing supported with PeopleTools 8.4?
• Both BEA WebLogic and IBM WebSphere have the ability to plug into many different web servers. Does PeopleSoft support the web servers that they plug into?
• Does Application Messaging work between 8.1xand 8.4 applications?
• Why is PeopleSoft no longer supporting Apache Jserv?
• What HTTP servers and Java servlet engine combinations are supported with PeopleTools 8.4?
• WorkItem is available in?
• Where are workflow work items found ?
• In which platform does Crystal and Psnvision works?
• You want to update your password and enter a hint for forgotten password. What would you access?
• Question based on changing prompt table, what happens when changing from NO EDIT TO EDIT option?
• Customization done in Dev DB, Which tool i will use to move it to Prod 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 ...
• (Some scenario) Question relating DBA Purging Temporary Table?
• How many Message nodes are possible for a database.?
• How will you get a single ouptut 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?
• When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then?
• What are the status available in PeopleSoft Domain Status Menu?
• Which of the following are part of an AE program ?
• 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 ...
• In which one of the following views would you see the fields, criteria, and other details associated with the current query?
• 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 ....
• 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.?
• In the following url, Which 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)?
• 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 ?
• Which RDBMS uses Tablespace?
• Changing Prompt Table with NO Edit to Prompt Table with Edit?
• Which command is valid in both bootstrap and regular mode when operating the data mover?
• PeopleCode events pertaining to Record Field:?
• Which of the following are Record field events ?
• Which of the following commands can be run in Bootstrap mode?
• What commands are valid in BS mode?
• What views available in Application Designer project workspace?
• Which of the above record definitions is NOT stored on the database and is therefore NOT required to be built?
• You have downloaded an Application fix as a project from the customer connection. Whrere would you upgrade it to ?
• PS Query definition is stored on which server?
• How do you login into BS mode?
• If you want to log into DataMover in Bootstrap mode, you would login as..?
• What is added as new option in Build apart from Create Tables, Indexes, Views?
• Where will you configure for failover of Application Server (Scenario) -?
• Which one of the following is a trasaction control statement ..?
• What Record Changes does not affect Database?
• Which one of the following steps is NOT part of performing an upgrade?
• Update and Fixes: R-* files refers to?
• How do you set up table-sharing in PeopleTools applications?
• What is the default Crystal Report that PeopleSoft Query tool creates?
• (Some scenario) Find which is not part of AE Program, Options would be?
• Which of the following are true with respect to validate signon with database option enabled in psadmin.?
• Which of the Following are true for force Shutdown In PeopleSoft Domain Shutdown menu?
• After logging into customer connection, you wish to search for fixes/patches. What are the search criterias available ?
• What are the Search Keys you use to find Patches and Fixes?
• Which one of the following tree types is NOT supported in the PeopleSoft tree manager? -
• Which Web Services is only used as a Proxy Server?
• In PeopleCode Debugger what are the valid values?
• Select the components which form the part of Integration Broker?
• what are the views available in App. Designer project workspace(multiple answer)?
• What are Menu types available?
• Database Connectivity Drivers should be installed in the following System?
• Where do you need to install connectivity software?
• What are the People Tools available for Integration Broker?
• A Customer wants to use a new Image in HRMS, where it is stored?
• We access pia from mac OS?
• Which of the following technology is used in app messaging?
• Which one of the following PeopleCode debugging tools automatically converts values of any data type other than object into string values for viewing during debugging?
• PIA screens and recognize it?
• Where do u set the web server cache?
• Your company obtained the newest Application Release of PeopleSoft ...
• Can a business Process be used as a Navigator Home page ?
• The physical, dedicated tables are locked at the time the Application Engine program is loaded into memory?
• State Record can be Dynamic Record?
• In Call Section – Action it is possible to leave the Program ID with blank Value in certain cases?
• 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?
• The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions?
• TriggerBusinessEvent is used for triggering the workflow and its written on workflow event. TriggerBusinessEvent has the syntax?
• The following is an entry from the application reviewer LOG File....
• One-to-Many?
• What the following command will do? psadmin -p start -d hrdmo?
• Which of the Task cannot be done through PSADMIN?
• Activate Event is Valid for following?
• What is the result of the search with the following criteria in PS Books?
• What category of commands can be executed in data mover?
• The example below demonstrates the use of SQR flags in the configuration manager directories folder...
• The application server dynamically scales server processes according to the volume of transaction requests which is known as?
• Where do you create the process security groups?
• What is the event that fires after all database updates are over?
• In which one of the following views would you see the fields, criteria, and other details associated with the current query?
• From the following statements which one is NOT true about Pub Broker?
• From the following statements which one is NOT true about Pub Broker?
• 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...
• which is a record that PeopleTools adds to every level of the Message Structure during processing?
• What is the configuration file that contains the entire collection configuration values for a given application server domain?
• Which command shuts down an application server domain using a “forced” shutdown method?
• The DB User mentioned in Connect ID should have permission to which Three PeopleSoft Tables?
• PeopleSoft uses for non-system(application) tables?
• 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?
• You just finished customization work that involved the creation of many new objects ...
• Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
• Trace 255 command line option produces the trace file with the name?
• Where can u see the status of the job report and details in secured way?
• Non Repudiation property can be set?
• If you delete a page from PSPT application which all tables are affected –?
• If u change the long name of translate field what object to be altered?
• When do configuration changes made using the configuration Manager take effect?
• Which one of the following is NOT a valid PeopleSoft query type?
• Interlink data type can be declared as?
• The following ApiObject data type objects can’t be declared as Global:?
• PeopleSoft’s hub to handle complex system-to-system interactions.?
• Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000 ...
• DoSave( ) can be called from one of the following events?
• In which PeopleCode event does ALL data validation take place?
• Peoplecode attached with Push Button can be associated with which of the following events?
• People Soft allows multiple long fields per State Record?
• AE does Parse SQL?
• 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:?
• We define business rules PeopleCode on?
• Which of the following record is not found in database?
• What is the logic used by Component Buffer?
• Two Program views of AE Program?
• You have 3 App. Servers where do you define the Failover.?
• Query is split into what?
• Menu path provides path to?
• When Auto-join check box is checked what does it mean?
• What effect would making a change to the EMPLID field in the above project have?
• An employee is transferred where should he refer in this aspection?
• What are destructive statements in SQL?
• A clients App was 3months behind, what should he do to update the app since it was not working?
• In Two Tier mode where does authentication happens?
• Worklist for a particular user contains marked worked and reassigned buttons. The reassigned button is set from?
• ps application logic reside where?
• Where do peopletools data is cached?
• My Asst. Manager approves some document; She uses some screens which presents her with all the data. What she do to minimize the data?
• You need not create separate DB for every user in PPSFT 8.4 onwards. This is possible because of?
• File formats for File Layout?
• Prompt table with no edit to no edit?
• Meta-SQL where is it stored?
• What are all stored in System Catalog?
• Process Profile contains?
• File format for SQR?
• People Soft clients wants to get info about PSPT where to find it?
• Which of the following are object definitions?
• How do you define the names of the application servers being used to access PeopleSoft?
• ER Diagrams represent?
• Tuning can be done on which servers?
• When do u view Business process map?
• A System Manager must approve all the transactions what is this?
• The field mapping button on worklist definition is used for for mapping the fields of worklist record ....
• Question Maximum number of Actions in a Step?
• PSWORKLIST record is used for workflow routing . It should contains minimum of ?
• SQL Queries on PS_STAFF table?
• Let us take a Temp Table TMP_TAO......
• PeopleCode variables (global, component, local, and parameter), method, and property names can now be up to _______ characters long?
• PeopleSoft reserves ALL WinHelp context numbers (in Utilities, PeopleTools Options) up to which number?
• File format u can download query result?
• Which one of the following tree types is NOT supported in the PeopleSoft tree manager?
• Where is Unicode used?
• What is the minimum number of objects an object group can consist of?
• Use of process profile?
• PeopleSoft Interview Questions only