Only selection of existing data is possible
Oracle, DB2, Other Options: SQL Server, Informix, Sybase
Latest Answer : oracle ...
Update Statistics
Created a Menu and a Page and given user access to that page, which of the tables gets affected on this (Scenario)?
PeopleTools Tables
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.
Update statistics on the table
user can type only prompt table values and the default values gets populated from the database.
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?
PSRECORDNAME
PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
PSRELEASE
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?
When you alter a table (adding few fields or deleting fields from record)with out lossing the data what you will do?
