DBA Interview Questions

Recently Posted

Category

2

Answers

What are the different isolation levels in SQL Server, and how do they impact performance and concurrency?

Muhammad Imran Ansari
1y Reply
0

Answer

What is star schema and how does it differentiate from Snowflake schema?

Tharunkumar Magudeeswaran
1y Reply
1

Answer

What are temporal tables in Azure SQL database and what are it's use cases?

Nandan Hegde
1y Reply
3

Answers

What is the major difference between a CTE and a temp table

Nandan Hegde
1y Reply
1

Answer

What is the Importance of data binning in data analysis?

Nikunj Satasiya
1y Reply
5

Answers

Find the number of a user's friends' friend who are also the user's friend. Output the user id along with the count.

Akshima Aggarwal
1y Reply
2

Answers

What is the need for MERGE statement?

Jayraj Chhaya
2y Reply
2

Answers

Which is faster in SQL Server? Simple Query or VIEW

Onkar Sharma
4y Reply
2

Answers

What is the difference between HAVING and WHERE Clause in SQL Server?

Onkar Sharma
4y Reply
4

Answers

Difference between Delete, Truncate and Drop Statements in SQL Server?

Onkar Sharma
4y Reply
1

Answer

How to add extensions to Azure Data Studio?

Onkar Sharma
4y Reply
2

Answers

What is the use of MySQL IF Function?

Onkar Sharma
4y Reply
2

Answers

Explain the difference between a Table Variable and a Temp Table

Cristopher Coronado
5y Reply
3

Answers

What is the difference between Union and Union All?

Cristopher Coronado
5y Reply
1

Answer

What would be the first step to take when troubleshooting a slow query?

Cristopher Coronado
5y Reply

What are the different isolation levels in SQL Server, and how do they impact performance and concurrency?

What is star schema and how does it differentiate from Snowflake schema?

What are temporal tables in Azure SQL database and what are it's use cases?

What is the major difference between a CTE and a temp table

What is the Importance of data binning in data analysis?

Find the number of a user's friends' friend who are also the user's friend. Output the user id along with the count.

What is the need for MERGE statement?

Which is faster in SQL Server? Simple Query or VIEW

What is the difference between HAVING and WHERE Clause in SQL Server?

Difference between Delete, Truncate and Drop Statements in SQL Server?

How to add extensions to Azure Data Studio?

What is the use of MySQL IF Function?

Explain the difference between a Table Variable and a Temp Table

What is the difference between Union and Union All?

What would be the first step to take when troubleshooting a slow query?