SQL Interview Questions and Answers

1. What is the purpose of the USE command?

2. What is the default order of an ORDER BY clause?

3. What are the logical operators?

4. What does the UPDATE command do?

5. Difference between Truncate and Delete?

June 7, 2008 | Filed Under DBMS, RDBMS | Leave a Comment

SQL Server/RDBMS Interview Questions?

What is normalization?

What is denormalization and when to use it?

Define candidate key and composite key?

Define ACID properties?

Define constraints? What are different types of constraints?

What is a Transaction?

January 7, 2008 | Filed Under DBMS, RDBMS, SQL Server | Leave a Comment

1. Define Primary Key and Foreign Key?

2. Define Stored Procedure?

3. Define Trigger?

4. Define View? Difference between Table and View?

5. Define Index, type of index and difference between clustered and a non-clustered index?

6. What is cursors?

7. Difference between Function and Stored Procedure?

8. What are the Principles of Relational Databases?

January 3, 2008 | Filed Under DBMS, RDBMS, SQL Server | Leave a Comment

About Interview Jolt

InterviewJolt is a power full way to crack your interview by getting questions and answers asked in the interview by experienced people. You will find most of the common question and their answers (answered by visitors of the site). We will post one or more questions and we expect our visitors to answers those (it will be reviewed before it goes public). This is a great way to share your interview experience with others and help job seekers and techies to prepare themselves before they get jolt at their interview!
Blogroll