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!!

Real time interview questions :: Sample

SQL DBA : Have a quick look for Real time interview questions :: Sample

1)How can we Move tempDB to another drive ?Is it possible, If yes how?
2)how the Differential backup works internally?
3)What is the use of FILL FACTOR settings and impact on performance of the BOX?
4)How page split impact on server performance ?Brief
5)CPU utilization is high (100%) how you trouble shoot in this context.
6)TEMPDB Full , how can you handle?
7)What is the difference between SQL Server clustering methods: - Active/Active - Active/Passive
8)What is the alive & Looks alive
9)What is Quorum ?Why Quorum is necessary ?
10) Unable to start SQL Server, what is the reason, how to find issue?
11)Log file is corrupted (there is no backups, how u will get database?
12)How to recover a Database in suspect mode?
13)How to find long running queries?
14)How to transfer Logins?
15)SQL Server Agent Service is not working?
16)While taking full backup can we take transaction log backup?
17)How do database checkpoint occur?
18)Difference between Checkpoint and Lazy writer?
19)What is SQL service broker?
20)Define acid property in SQL Server?

Thank you for reading my blog, I will post in my next blog for more usefull real time questions....,Once Again Thank You!!

Welcome

Hi All,

I hope you all are doing fine. I am creating this blog to give idea about SQL DBA from basics to Experience level. I will upload some study material and videos.

Actually in IT field there are so many professions are available to choose. From them one is as Server Administrator and it is also a high salary paid job. But the main point is you should have good knowledge of the field.

Through this blog I will provide you step by step tutorials for better understanding. So lets begin the journey of becoming a  good SQL Administrator.

More over I can promote SOCIAL BUSINESS as well like work from HOME for two to three hours Trading. It's very useful and treated as a extra money for smooth running Life.

Thank you.