 Related Questions Only selection of existing data is possible Oracle, DB2, Other Options: SQL Server, Informix, Sybase Latest Answer : oracle ... Tags : RDBMS Update Statistics 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 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? Read Answers (2) | Asked by : ramesh
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
