MS SQL DBA Interview Questions

  1. What is the full form of DBA?
  2. What do you understand by normalization?
  3. Please give us an instance of Stored Procedure.
  4. What do you know about triggers?
  5. Can you tell us the different types of indexes that are available with a typical SQL Server?
  6. How would you differentiate between a non-clustered and a clustered index?
  7. What do you mean by cursors and what is its role?
  8. Can you tell SQL Server runs on which TCP/IP port?
  9. What is the procedure to change the default port?
  10. Please explain the difference between DELETE & TRUNCATE.
  11. Where and how do we make use of DBCC command?
  12. Which command will you use to rename a DB ?
  13. Give the difference between WHERE CLAUSE and a HAVING CLAUSE.
  14. What are the basic uses of SQL Profiler?
  15. Select which of the stored procedure would you run to make an addition to a linked server?

Category: Software Interview Questions

Leave a Reply