Explain about the Optimizer values passed in Oracle?
What is peoplesoft configuration manager?
Which events get fired after db update?
What does psadmin do?
You want a single output by comining two or more queries. How would you do that?
How can you configure peoplecode trace?
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 views available in Application Designer project workspace?
what are the views available in App. Designer project workspace?
How do you login into BS mode?
what is sys audit?
Suppose you want to update your password and enter a hint for forgotten password. What would you access?
I have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?