What are the types of locks in database?
No Answer is Posted For this Question
Be the First to Post Answer
What happens when the default and temp tablespace clauses are left out from create user statements?
What does database administrator do?
When should you increase copy latches? What parameters control copy latches?
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?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
How would you find total size of database in os level?
What should a dba know?
What is da in database?
How many dba can you have?
What are the various ingredients of sga?
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?