Bashas' SQL Developer interview questions

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