What is the difference between clustered and non-clustered index? : sql server DBA


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  


Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  


What is replication? : sql server DBA

0 Answers  


What is dcl? : sql server DBA

0 Answers  


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?

0 Answers  


You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  


suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,


What is the difference between LMT & DLT?

1 Answers   CTS,


If we issue alter database begin backup. What happens to database?

2 Answers  


how can you implement fine-grained auditing?

0 Answers   Oracle,


In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,


What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,


Categories