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 5338Post New Intel PeopleSoft Administration Interview Questions
What hierarchy is being followed when in style sheets?
Explain Avro Schemas?
what is restricted earth fault explain in details
how to measure the transformer resistance values(dyn11)?and howmuch the minimum value?
how long you will worked with us???? why you left the previous company? how can you manage our company?
What is a data science job?
Hello all, This is my assignment on shell scripting, can anyone help me regarding this ? Create a shell script which connects to the database In second shell script include the first script for the DB connection Create a table (PRADEEP_DATA) with 2 columns (name, value) In Third shell script include the first script for the DB connection And insert/delete the values from the Table, by accepting input from the user This functionality should be a menu driven Program: 1) Insert to the database a. Name b. value 2)Delete from the database a.Name b.value Exception handling needs to be taken care.
Shall we use abstract classes or interfaces in policy / strategy design pattern?
What are phagocytic cells (macrophages)?
What is the syntax of the robots meta tag?
What will happen to my current process when I execute a command using exec?
Is it possible to provide method implementations in java interfaces? If possible, how do we provide them?
What exactly is DES?
hii friends m going for interiview of lecturer in management. m mba in finance ..plz tell me wat types of questions are asked/
How do I make text smaller?