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 4364Post New Intel PeopleSoft Administration Interview Questions
- Intel C Interview Questions (4)
- Intel OOPS Interview Questions (2)
- Intel C++ General Interview Questions (5)
- Intel Delphi Interview Questions (1)
- Intel JavaScript Interview Questions (1)
- Intel C Sharp Interview Questions (1)
- Intel ASP.NET Interview Questions (1)
- Intel Dot Net General Interview Questions (2)
- Intel Microsoft Related AllOther Interview Questions (1)
- Intel SQL Server Interview Questions (1)
- Intel Linux System Calls Interview Questions (1)
- Intel Linux General Interview Questions (1)
- Intel Operating Systems General Concepts Interview Questions (2)
- Intel QTP Interview Questions (6)
- Intel Rational TestSuite Interview Questions (1)
- Intel Manual Testing Interview Questions (5)
- Intel Test Cases Interview Questions (1)
- Intel Struts Interview Questions (1)
- Intel Teradata Interview Questions (2)
- Intel Project Planning Interview Questions (1)
- Intel SAP ABAP Interview Questions (12)
- Intel SAP FI-CO (Financial Accounting & Controlling) Interview Questions (1) Intel PeopleSoft Administration Interview Questions (1)
- Intel Oracle Apps HRMS Interview Questions (1)
- Intel 86 Family Interview Questions (2)
- Intel VLSI Interview Questions (145)
- Intel Embedded Systems AllOther Interview Questions (1)
- Intel General Science Interview Questions (1)
- Intel Civil Engineering Interview Questions (1)
- Intel Mechanical Engineering Interview Questions (1)
- Intel Electrical Engineering Interview Questions (9)
- Intel Electronics Communications Interview Questions (14)
- Intel Engineering AllOther Interview Questions (2)
- Intel Marketing Sales Interview Questions (4)
- Intel Banking Finance Interview Questions (1)
- Intel Accounting AllOther Interview Questions (1)
- Intel Call Centre AllOther Interview Questions (2)
- Intel Group II History Interview Questions (1)
- Intel General Knowledge_Current Affairs Interview Questions (4)
- Intel General Aptitude Interview Questions (1)
- Intel Placement Papers Interview Questions (1)
- Intel CCNA Interview Questions (2)
- Intel H1B Visa Interview Questions (1)
- Intel USA Student Visa F1 Visa Interview Questions (2)
- Intel C Code Interview Questions (1)
What are the technical features of MySQL?
Should I turn off windows defender with avast?
What is the purpose of the z-index and how is it used?
What are rbi monetary policy objectives?
What is RPA UiPath?
Define transfer () with syntax?
Explain some differences between a linked list and an array?
Code the tables statement for a single-level (most common) frequency?
Ram, the proprietor brought additional capital of Rs 75000/- by pledging his wifes gold.pass entry
Is stringbuilder thread safe c#?
Welcome link is dynamic. How do you handle? What is your approach and write script.plz send answer
Explain jsessionid and when is it created?
How do I vlookup from another sheet in excel?
What commands will you use to bring a new feature to the main branch?
what is the use of FR-4(flame retardant)in PCB design why dielectric material used in inner layer in PCB design technology??
