Thursday, 29 December 2016

SQL DBA : Real time interview questions few more...

Hi DBA Aspirants,

Hope you guys are doing well!!.

Let`s begin the new year with fresh thoughts ,I hope first week  in the month of JAN-2017 the corporate hiring process (freezing) will be resume. So its good time to switch company for better career growth and more Salary .

Now am continue to post few more real time interview questions . Which I have faced early in my career .I hope my blog will be help you guys for who are looking for change another company and I believe this blog will help for only experts not learners . Because so far i have posted only interview questions not for solutions. Because of expert people to know answers but don't know thing is recent interviewer are focusing which areas .

My opinion is to share my real time experience and it is not copy pasted things.  Thanks for understand.

I hope and surely , my up coming posts will be share useful scripts . Thanks for the time.

Have a quick look::

1)what is fragmentation? How can you handle fragmentation is too high?
2)what is the functionality of algebrizer in SQL SERVER?
3)Dirty read?
4)types of pages and usages?
5)msdb special permissions?
6)what is the size of TDS?
7)what are the wait types in sql server?
8)What is the silent installation?
9)what are the regular Dynamic Management Views used by DBA?
10)Importance of UPDATEUSAGE ?
11)Default MDF and LDF file size?
12)how to fix orphaned users in sql server?
13)what is the functionality of dB backup operator?
14)what are the pre-prerequisites for before the migration processes ?
15)Importance of perfmon?

Thank you for reading my blog and kindly celebrate new year safely by planning with lot of Joyeeee..
Once Again Thank You!!





No comments:

Post a Comment