9 SQL Server Interview Questions


There is always room to learn more about SQL Server by attempting to answer SQL Server interview questions, even if you aren’t looking for a new job. I have written on the subject of interview questions before, but there is a large number of resources on the internet to help you find new questions. This is a list of questions from Deanna Dicken, written several years ago.

  1. What is Referential Integrity?
  2. What is the difference between a clustered and a non-clustered index?
  3. What are DML triggers and what types of triggers can you have on a SQL Server table?
  4. What is a four-part name?
  5. What is a Linked Server?
  6. How do you handle an error from within a stored procedure?
  7. How do you auto number rows in SQL Server?
  8. What is a left outer join? Give an example.
  9. What is a cursor and why would you use it?

You can read the entire article here, as well as check your answers.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s