Interested to Buy Any Domain ? << Click Here >> for more details...
Given a SQL Statement, if you have been asked to check the
right syntax ?
- 1 Answers
- 5189 Views
- I also Faced
- E-Mail Answers
Answer / nimmathota
Run in backend whether WinSQL or Toad and check if errors
out if it is the cursor will stop exactly where the syntax
is wrong
| Is This Answer Correct ? | 0 Yes | 1 No |
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 could be the reason when CPU utilization is high when no load on app server? a. unidentified memory leakage in the server b. more psappsrv processes in the app server c. File system is full d. all of the above
How can you start weblogic on microsoft windows?
Tell me what views available in application designer project workspace?
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?
What statuses are available in peoplesoft domain status menu?
What elements are there in psadmin?
In the following url http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHED ULER.PRCSTYPEDEFN.GBL which one is the component definition?
In PeopleCode Debugger what are the valid values?
What are the default values for psappsrv and other servers when application designer starts?
Suppose you have created a menu and a page and given user access to that page, which of the tables gets affected on this?
PeopleSoft HRMS 
