Recently I have gotten many, many requests for SQL Server Interview Questions and Answers as well as related articles. It seems many people are looking for Job or appearing for an interview at this time of the year. I have included lists of the my top downloads in the sidebar of the blog, still I receive many curious questions as side bar does not show up in the RSS feed.
Please bookmark this post for future reference.
SQL Server Interview Questions and Answers Download
SQL Server Management Studio Keyboard Shortcuts (SSMS Shortcuts) Download
Here are some of the sample questions:
What is RDBMS?
- What are the Properties of the Relational Tables?
- What is Normalization?
- What is De-normalization?
- How is ACID property related to Database?
- What are the Different Normalization Forms?
- What is a Stored Procedure?
- What is a Trigger?
- What are the Different Types of Triggers?
- What is a View?
- What is an Index?
- What is a Linked Server?
- What is a Cursor?
- What is Collation?
- What is the Difference between a Function and a Stored Procedure?
- What is subquery? Explain the Properties of a Subquery?
- What are Different Types of Join?
- What are Primary Keys and Foreign Keys?
- What is User-defined Functions? What are the types of User-defined Functions that can be created?
Reference: Pinal Dave (https://blog.sqlauthority.com)
2 Comments. Leave new
I think you should add ctrl+i to ssms shortcuts (incremental search)
Hi Dave ,
We are planning to Migrate the Database from 2000 to 2005 , As a SQL DEVELOPER what are the Points to be taken Care ,
Like , How to test Compatabily whether my scrips are Good into SQL 2005 or not ,
Thanks in Advance
Praveen