Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
Tell me about standby database? What should we watch out for?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
How to uncatalog backup?
How can you determine if an index needs to be dropped and rebuilt?
How can you tell if a tablespace has excessive fragmentation?
How many types of database software are there?
What is the meaning of database backup?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
What do you understand by a control file?
Explain the various modes of normalization?