1) How many data servers are you handling?
2) What is default recovery model for tempdb?
3) Reason for tempdb to be in simple recovery model?
4) What is default recovery model for model database?
5) What is dirty page?
6) If dead lock occurs in your database. How will you resolve it?
7) What is lazy writer?
8) If tempdb is not accessible/corrupted and master database also not accessible/corrupted. How will you recover it?
9) Instead of rebuilding master is there any other way we can replace the .mdf and .ldf.
10) How to restore master database after rebuild of master?
11) If tempdb is corrupted, without restarting the services how to resolve the problem.
12) What are the high availability concepts you worked so far?
13) Active/Passive cluster is configured. On passive node log shipping configured. When fail-over occurs what is the status of log shipping?
14) Which DMV or DBCC command to find login information?
15) Someone changed the stored procedure. How to find who had done the changes?
16) Difference between log shipping and db mirroring?
17) In log shipping a DML command or Delete command is running in primary server, in sudden primary got failed. We have to bring secondary server to online. Whether the changes are replicated in secondary server?
18) In transaction replication what is the role of latency?
19) What is the use of log reader agent in transaction replication?
20) How to resolve performance issues at database level?
No comments:
Post a Comment