What is the difference between clustered and non-clustered index? : sql server DBA
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
What is replication? : sql server DBA
What is dcl? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
You're getting high "busy buffer waits" - how can you find what's causing it?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is the difference between LMT & DLT?
If we issue alter database begin backup. What happens to database?
how can you implement fine-grained auditing?
In oracle 10g export, import if we declare rows=y/n what would be the output?
What background process refreshes materialized views?
2 Answers Accenture, FLSmidth,