1)Database architecture.
2) difference b/w full, differential, t-log backups
3) importance of differential backup
4)tools to monitor windows level resources/hardware.
5) perfmon counters.
6) issues faced in ur experience
7)if u wrote any sop's ...what issues did u write...till now how many did u write in ur experience.
8)as part of performance tunning what issues did u face.explain
9)what dbcc commands did u exceute.
10) what dmvs did u excute and its purpose..
11) explain always on availability configuration..step by step.
12)how many ip addresses to create active-passive cluster
13)t-log architecture
14) checkpoint
15) rollback n roll farward
16) how differential backup works..
17)reasons for restoring job to fail in log shipping
18)have u involved in db refresh. ..steps to do refresh
19)issues faced in log shipping.
20)difference between hot fix, service pack, cumulative update
21)how differential backup tracks changes after full backup
