What is the difference between sga and pga?
No Answer is Posted For this Question
Be the First to Post Answer
What is main function of database administrator?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
What are the beneficial tools for administering the database?
How many redo logs should you have and how should they be configured for maximum recoverability?
Explain 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?)
What skills should a dba have?
Give one method for transferring a table from one schema to another?
What is dba training?
Discuss row chaining, how does it happen?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
How do you set up your tablespace on installation level: low?