What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by dba?
What does dba stand for database?
How to drop an oracle database?
Explain procedure to change characterset of a database.
What happens if a tablespace clause is left off of a primary key constraint clause?
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?
What parameters control copy latches?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
Which files are vital that should be backed up?
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
How many control files should you have? Where should they be located?
How many redo logs should you have and how should they be configured for maximum recoverability?