Mock Interview - MS SQL Server and PostgreSQL Server DBA
Mock Interview - MS SQL Server and PostgreSQL Server DBA
Question
1. What are #system #databases in SQL Server?
2. What are the different types of #temporary tables in tempdb?
3. How many types of replications are there in SQL server?
4. What are the different types of #authentication mode in SQL server?
5. What happens if SQL server agent service does not run?
6. How will you find locked #transactions in SQL server?
7. What do you mean by PLE?
8. How will you find the waiting task in SQL server?
9. What are the different types of #performance #monitoring #tools?
10. What is MDOP and the best #value for it in SQL server?
11. What are the different types of #replication #agents in SQL Server?
12. Explain difference between Log shipping and Mirroring?
13. Explain difference between #Mirroring and Always ON long with scenario?
14. What will be the #impact if you have #implemented log shipping with stand by #mode?
15. what are the different type of #Database state in SQL server?
#interviewtips
#interviewtipsandtricks
#citus
#extension
#sqlserver
#dbas
#sqlserver2017
#sqlserver2019
#sqlserver2022
#developers
#azure
#azuresql
#postgresql
#installation
#live
#demo
#training
#sqlserver
#onlintraining
#dbas
#interviewtipsforfreshers
#technology
#education
#educational
#rdbms
#training
#motivation
#motivational
#shortsfeed
#shorts
#motivationalvlog
#dbas
#sqlserver
#freshers
#experience
#coding
#sql
#story
#emotional
#shortstory
#educational
#professionaltraining
#bestpractices
#onlinetraining
@mcc2002