Interested to Buy Any Domain ? << Click Here >> for more details...
How will you get a single ouptut by combining two or more
queries?
- 2 Answers
- 3824 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ?
Explain what are the components which form the part of integration broker?
What bea product is used for db transaction in peoplesoft? How would you log into the bs mode?
Explain load balancing?
Explain bb and bbl.
You want to upgrade a peoplesoft tool. How would you do it?
What elements are there in psadmin?
one particular query taking long time how to reduce that time
Where do we need to install connectivity software?
All the application servers in production environment have reached a threshold. How would you configure a new application server so that the web server is not bounced?
Differentiate between dddaudit and sysaudit?
Do you know what record changes does not affect database?
PeopleSoft HRMS 
