DBA Interview with RevitUP

1. What is Physical DB Architecture and explain? What are the pagefile information? 2. What is Checkpoint and sequence of operations when Checkpoint is run? 3. Types of Checkpoints? 4. How do you connect to IBM DB2 for data retriveral or update/Insert? 5. WHat is Transactional replication and how it works? 6. WHat are the types of ISOLATIONS and use of them? 7. WHen do you use each of them? 8. How do you plan SQL Server migration and ensure perfect migrations? Logins Objects Credentials Configurations Drives Capacity OnPrem to Azure (IaaS) On Prem to Azure PaaS DMA DMS BACKPAC EXPORT 9. Have you worked on DB Partitioning and how does it work? 10. How do you check IO Statistics of the Servers and how do you ensure it's healthy? 11. what are L1, L2 and L3 Administrator Roles? 12. How do you rate yourself on PowerShell? 13. Have you involed in Automation activties? 14. What kind of activities are automated through PowerShell? 15. What is tail log backup? 16. TEMPDB Best practices? 17. How do you migrate databases to Azure Databases? 18. How do you migrate Large Databases? 19. How do you tune SQL Query? 20. How do you check Dead Locks? 21. How do you fix dead locks as a DBA? 22. WHat are the monitoring tools used? 23. How do you fix BD corruption issues? 24. If you don't have any details in logs, how do you check and fix the DB Corruption issues? 25. How does Query Optimizer works and work flow of Query Optimizer? 26. Explore on entier SQL Architectrure DB Architecture Log File Architecture Data File Architecture 27.