How do you set up table-sharing in PeopleTools applications?

PeopleSoft Interview Questions and Answers

(Continued from previous question...)

73. How do you set up table-sharing in PeopleTools applications?

Add the field, SETID, as a key field to each table you want to share, and then define the set control field. PeopleSoft reserves ALL Message Sets (in Utilities, Message Catalog) up to which number?

(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