August 4, 2022

Top 50 MySQL DBA interview questions answers

MySQL/MariaDB DBA Interview Questions and Answers - Part 1


Q1. What is the MySQL default port number?
answer: 3306

Q2. How MySQL replication works?
answer:
Replication is the process of creating and maintaining multiple copies of a MySQL database. It allows you to synchronize data across multiple database servers, providing high availability, scalability, and redundancy.

Q3. How will you fix MySQL slave replication issues?
answer:

Q4. What is GTID based replication?
answer:

Q5. Please explain the main differences between RDS MySQL and Amazon Aurora MySQL cluster?
answer:

Q6. Define ACID properties?
answer:

Q7. How many types of backups are available in MySQL? How do you take a backup of a MySQL database?
answer:
MySQL provides multiple methods for backup, such as using the mysqldump utility, using the MySQL Enterprise Backup tool, or performing raw data backups using file system-level tools.

Q8. How do you take incremental backup in MySQL?
answer: 

Q9. Give the different types of logs available in MySQL?
answer:

Q10. What is the command to retrieve the current date in MySQL?
answer:

Q11. Which is the default database engine utilized in MySQL?
answer:

Q12. Provide the various database engines present in MySQL?
answer:

Q13. How can a user get the current MySQL version?
answer:

Q14. What is Sharding in MySQL?
answer:

Q15. Is there any way to optimize MySQL tables? What is optimize table command do?
answer:

Q16. What are the Transaction Isolation Levels in MySQL database?
answer:

Q17. What is the default Transaction Isolation Level in MySQL?
answer:

Q18. How to change Transaction Isolation Level in MySQL?
answer:

Q19. What is MVCC in MySQL database?
answer:

Q20. How to improve the performance of a MySQL query?
answer:

    
Related MySQL Articles: 50 
Best MySQL DBA interview questions answers Part 2   MySQL Database Administrator Online Quiz

No comments:

Post a Comment