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 ?
2 5113Post New Intel PeopleSoft Administration Interview Questions
Which type of plug-ins contains “Output Parameters”
wht did you apply at teletech? why not in tanscom, convergy's, ventus, etc.?
What are the different types of nosql databases? Give some example.
Differences between die and exit.
What are the data pins of microprocessors?
tell me something about yourself which is not given in the resume.
1) Any pipe line working fluid may water / steam on it one manual isolation valve suppose one side of valve 6 kg/ cm^2 pressure (i.e. up stream) and other side is “ 0” kg/ cm^2 pressure(i.e. down stream) . So how much Tourqe required for opening the valve in terms of Newton force wheather normal man can open this valve. (for reference pipe nominal bore is 100 NB )
Which work process triggers database changes?
What is the purpose of uuid?
Can you just explain about memory management in iOS?
What is the difference between git vs svn
My company was granted a bank facility of 750,000 for guarantee, performance bond, advance payment, retention guarantee and 100,000 bank overdraft. These facility amount was never added to the company account. a. What is the entry? b. Lien over fixed deposit for 50,000 to be brought upfront c. Lien over gradual buildup for fixed deposit 50,000 by transferring 10,000 monthly from customer's account to separate call account. d. After a month, we had an overdraft of 22,000. What will be my entry? e. After 3 months, we have a construction project and was asked for advance payment of 24,000 with a 25% margin? f. Another company asked for performance bond of 44,200 with 25% margin.
working of nuclear power plant
what is pmrep command?
What is binary tree used for?