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