1. What are the new #features in SQL Server latest #version?
2. What is RTO and RPO?
3. How to map a user to execute #permission on a usp?
4. What is VLF and how can you check it?
5. What is SSRS?
6. What will be you approach ,if db mail is unable to send #email and alerts?
7. How would you find failed job history?
8. What is difference log #shipping and #mirroring?
9. What is difference between migration and upgradation of #sqlserver ?
10. What is trace flag? Give some example.
11. What is different between local and globle tables?
12. What is difference between #truncate and delete?
13. What is index? How many type of indexes in sql server?
14. What do you mean by #rebuild and #reorganize of #indexes?
15. What is #deadlock?
16. What is RAID?
17. What is ACID #properties?
18. Can you explain query life cycle in #sqlserver ?
19. What is page?
20. What is BCP and DCM?
21. What is dbcc?
22. What is contained #database?
23. What are server and database roles?
24. Explain HADR?
25. what are the procedure to repair master #database?
26. What is Hotfixes and Patches?
27. What are the different #replication agents?
