SQL Interview Questions

Recently Posted

Job Title

1

Answer

What is blocking and how would you troubleshoot it?

Arvind Yadav
3y Reply
3

Answers

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

Arvind Yadav
3y Reply
1

Answer

How much "NULL" values you can define for the "NULL" Data Type Column in SQL ?

Jay Pankhaniya
3y Reply
2

Answers

What is the difference between “INNER JOIN” and “OUTER JOIN”?

Rajanikant Hawaldar
4y Reply
2

Answers

Explain the difference between a Table Variable and a Temp Table

Cristopher Coronado
4y Reply
3

Answers

What is the difference between Union and Union All?

Cristopher Coronado
4y Reply
1

Answer

Can we execute a Trigger directly?

Praveen Kumar
5y Reply
1

Answer

How many ways we can return data from Stored Procedure?

Praveen Kumar
5y Reply
1

Answer

How can you encrypt the Stored procedure?

Praveen Kumar
5y Reply
4

Answers

What is good option to use in SQL and WHY? 1) JOIN 2) SUB QUERY

Mohd Kashif
5y Reply
1

Answer

Explain how to enhance query performance using indexes?

Amita Palkar - Junnarkar
7y Reply
4

Answers

This is one of the Interview Question Ask in one of MNC Company Interview tbl1 Id Sal 1 1000 2 2000 3 3000 Output Asked Was Id Sal 1 1000 2 3000 3 6000 For fist row Sal Should be same,for second row sum of first and second and third row sum of first,second and third?

Aniket Narvankar
8y Reply
6

Answers

This is one of the Interview Question Ask in one of MNC Company Interviewt bl1 Id Sal 1 1000 2 2000 3 3000 Output Asked Was Id Sal 1 1000 2 3000 3 6000 For fist row Sal Should be same,for second row sum of first and second and third row sum of first,second and third.

Aniket Narvankar
8y Reply
1

Answer

What is difference between OLAP and OLTP ?

Bikesh Srivastava
8y Reply
6

Answers

How will you delete duplicate data from a table in sql

Pankaj Kumar Choudhary
10y Reply

16 - 30 of 52

What is blocking and how would you troubleshoot it?

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

How much "NULL" values you can define for the "NULL" Data Type Column in SQL ?

What is the difference between “INNER JOIN” and “OUTER JOIN”?

Explain the difference between a Table Variable and a Temp Table

What is the difference between Union and Union All?

Can we execute a Trigger directly?

How many ways we can return data from Stored Procedure?

How can you encrypt the Stored procedure?

What is good option to use in SQL and WHY? 1) JOIN 2) SUB QUERY

Explain how to enhance query performance using indexes?

This is one of the Interview Question Ask in one of MNC Company Interview tbl1 Id Sal 1 1000 2 2000 3 3000 Output Asked Was Id Sal 1 1000 2 3000 3 6000 For fist row Sal Should be same,for second row sum of first and second and third row sum of first,second and third?

This is one of the Interview Question Ask in one of MNC Company Interviewt bl1 Id Sal 1 1000 2 2000 3 3000 Output Asked Was Id Sal 1 1000 2 3000 3 6000 For fist row Sal Should be same,for second row sum of first and second and third row sum of first,second and third.

What is difference between OLAP and OLTP ?

How will you delete duplicate data from a table in sql