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
- 3819 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Explain about the Optimizer values passed in Oracle?
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 ?
What are the default values for psappsrv and other servers when application designer starts?
How many Message nodes are possible for a database?
Explain what are the differences between rowclass and rowset in peoplesoft?
You want to setup file attachment / report servers. How would you do that?
You are receiving an error "application server is down at this time" but hthe application server is running. What could be the problem? How will you debug it?
Tell me what views available in application designer project workspace?
you have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?
Explain how many message nodes are possible for a database?
You want to upgrade a peoplesoft tool. How would you do it?
What views available in Application Designer project workspace?
PeopleSoft HRMS 
