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

RDBMS Interview Questions and Answers - RDBMS Basics

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