SQL INTERVIEW QUESTIONS

1.     Difference between internal fragmentation and external fragmentation?

2.     How will you know whether sql server starts are not if services are not available?

3.     How will you trouble shoot when jobs fail?  Where will you monitor?

4.     How will you bring back sql server from hung mode?

5.     In mirroring when transactions moving from principle to mirror the mirror server crashed? What happen to those transactions?

6.     What are the configuration settings stored under master database?

7.     In to how many files your database divided? Why it is divided like that?

8.     What is your mirroring and log shipping frequency?

9.     How you know when your servers start last time?

10.   Can we take tail log back up when server is in active?

11.   What is the reason for to run data base consistency commands?

12.   How will you trouble shoot after identifying long running query?

13.   What is the schema for user login?

14.   How much time it take to full backup of 800gb ? What is size of database after you take back up?

15.   How will you move when orphaned users when they are more?

16.   How will you trouble shoot login problem   when ever user is trying to login he gets alert that “ User already logined”?

17.  What are issues u faced in installing Hot fixes and pathes?

18.  log shipping failed when it is configuring ? Will reconfigure or what?

19.  u r installed service pack up to 70% it got failed what will you do?

20.   What is live lock ?

21.   How u r data stores in data file Sequential or random?

22.  What is u r next step if server crash?

23.   What is execution plan in sql server?

24.   Difference between OLTP and OLAP?

25.  What is the usage of ndf file in a sqlserver?

26.  Reasons for database corruption?

27.  Where will SSIS packages stores? How will you run this packages ?

28.  Publisher we have space where as in subscriber space is not there for transactions ? what will u do in this case ?

29.  Some important data delete we need to recover from backup but the deletion time not provided ? how u restore data?

30.  How to move to Msdb and model databases? What will you do if msdb crash?

31.  What is service Broker ?

32.  How to tune a Stored Procedure?

33.  When ever crash happened in logshipping how will ur recover last backup by using query (not tail logup query)?

34.  How will move if publication database is more size (around 800gb) , is there any another way apart from moving as snapshot ?

35.  How will you configure linked server by using queries?

36.   How will you find the no of user hitting Sqlserver.

37.   What queries you use to get data from Jobs schedule , job history.  

38.   While running restore job in logshipping it failed continuously and throws a error what is reason?

39.  What are top 5 DMV’s u use?

40.   In repilication you can not able to connect to subscriber . how will you trouble shoot?

41.  Components in clustering configuration ?

42.  What is tuff file in log shipping? What it stores?

43.  What is autonomy, latency and transactional consistency in trasactional repilication?

44.  Diff between clusteradmin in win2003 server and win2008?

45.  How to strat sql server in miminal configuration mode ?

46.  What is raid? What are different types of RAID configurations?

47.  What are reasons for inconsistent data ?

48.  What is file stream in sql server ?

49.  What are the types of data compressions in sqlserver 2008?

50.  What is execution plan ? when you use it ?