Which of the following are true with respect to validate sign on with database option enabled in psadmin?
1. The application server first attempts to connect to database using the user id and password as part of the database connection string.2. User must be defined on either the operating system or the
Only selection of existing data is possible
Latest Answer : normally state record used to pass the values from one action to another acton in application engine. ...
Oracle, DB2, Other Options: SQL Server, Informix, Sybase
Latest Answer : oracle ...
Update Statistics
Create Trigger
Latest Answer : Alter Table & Create Trigger ...
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