Real Page, HYD - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies.

I attended Real Page Software Company’s interview recently.  I have given all the questions which I faced during interview. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

1.        Tell me about yourself?

2.        What is the view? Disadvantages of the view?

3.        Difference between Delete and truncate?

4.        What is cardinality? Why is it used? What is the need of setting the cardinality? Any specific reason?

5.        What is the use of trigger?

6.        Difference between trigger and stored procedure?

7.        What is the use of cursors and types of cursors ?

8.        How many types of statements we have and what are DCL commands?

9.        What is the use of normalization? Types of normalization? Why we need normalization?

10.     What is the use of CTE?

11.     What is the use of locks and how many types of it?

12.     What the ACID? What is the use of atomicity?

13.     What is the SDLC?

14.     What is the Agile model?

15.     What is materialized view?

16.     What is the difference between candidate key and foreign key?

17.     What is domain integrity and column integrity?

18.     What is Blocking and deadlock?

19.     What is the use of profiler and what are the trace flags you set before starting the profiler?

20.     What are the isolation levels?

21.     How will you set the jobs in sqlserver? Give me one scenario where you have used?

22.     What are the SQL injections and what are the best ways to handle it?

23.     Can you name at least 5 aggregate functions?

24.     How will you solve the performance problems of a query and what are the performance counters you use?

25.     What are the functions? Different types of functions?

26.     Best practices to design an efficient database?