What is the difference between a database and instance?
No Answer is Posted For this Question
Be the First to Post Answer
What skills should a dba have?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
How do you put database is archivelog mode, explain procedure?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
What is the difference between cold backup and hot backup?
If you see statistics that deal with "undo" what are they really talking about?
What is explain plan and how is it used?
How do I become a dba?
What are four common errors found in an alert .log?
Tell me about standby database? What should we watch out for?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?