Adithi technologies interview questions

Published on October 2 2016 by LakshmiSaahul,Dhana Royal

1. Explain WAL concept?

2.How to troubleshoot Service pack installation failed ?

3.Why every transaction log in t log file not data-file?

4.Diff between mirroring and log-shipping?

5. In log shipping copy job fail how to trouble shoot?

6.ACID properties?

7.what is index rebuild ? diff between offline rebuild and on line rebuild?

8.explain startup process sql server?

9.user perform transactions with begin tran that time sql server restart ?what happend about that transactions? where the transaction are saved?

10.what is process and build?

11.in cluster server environment sql server is restart what will happens?

12.Instance restart but service not run where you will check what are the reasons?

13.What is Asynchronous and synchronous?

14. What are the cases instant crash not respond ?

15.1 GB log file how much you can shrink the file size?

16.which database will effect when Service pack installation in sql server?