Your Onsite DBA has called you up and told you that one of the tables PS_ABC_TAO has grown very big in size ...

PeopleSoft Interview Questions and Answers

(Continued from previous question...)

31. Your Onsite DBA has called you up and told you that one of the tables PS_ABC_TAO has grown very big in size ...

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 _TAOYou 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. You look into his process and find that it uses PS_ABC_TAO as a temporary table.What would you suggest the DBA to do ?

Update statistics on the table

(Continued on next question...)

Other Interview Questions

• ER Diagrams represent?
• Which one of the following is NOT a valid PeopleSoft query type?
• What is the default Crystal Report that PeopleSoft Query tool creates?
• Which of the Following are true for force Shutdown In PeopleSoft Domain Shutdown menu?
• Is BEA WebLogic the same thing as the web server that was previously on the Tuxedo CD?
• In which PeopleCode event does ALL data validation take place?
• 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?
• In which PeopleCode event does ALL data validation take place?
• For downloading patches and fixes, you have gone to the customer connection ...
• In PeopleCode Debugger what are the valid values?
• More...