Tell me about standby database? What are some of the configurations of it? What should we watch out for?
276Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
335What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
264Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
257Post New Oracle DBA (Database Administration) Questions
What are the five functions of a database?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
What is the difference between truncate and delete? How would a full table scan behave after?
What are four common errors found in an alert .log?
How do I become an administrator?
What are the main functions of dba?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
What os user should be used for the first part of an oracle installation (on unix)?
What is pct free/pct used/pct increase parameter in segment?
What is the full form of dba?
What does dba stand for in technology?
When should an artificial (or derived) primary key be used?
What is the relation between database and instance?
What is the finger command?
What is the easiest method to create a file on unix?