Wrong Answers to MySQL Interview Questions!

This mysql tutorial will walk you through a couple of wrong answers to MySQL interview questions.

There's no doubt that those conducting SQL interviews or software interviews in general have heard some funny sql interview answers to their software interview or sql interview questions.
Today, we're walking you through a couple of wrong answers to interview questions concerning MySQL.

1)
The first SQL interview question sounds like this:
Q: What will you do to ALTER a table sized 1TB or more?
A:
The most likely answer would be "I will not alter the table in the first place", which is not inherently wrong, but here we need additional context.
Why are our tables weighing terabytes to begin with? What are we storing in the SQL database and what project do we have?
Once we examine our database schema and data types, we can begin optimizing our MySQL Server database and making our MySQL database tables smaller in size, and thus easier to ALTER. If an ALTER TABLE is still necessary for our MySQL Server or MariaDB Server tables weighing terabytes, we should optimize my.cnf or load the data in via LOAD DATA INFILE after creating a necessary field and re-importing the table structure into our database instead.

2)
The second SQL interview question may have to do with UNION and UNION ALL SQL queries.
Some DBAs or beginner software engineers may confuse these two and say that these SQL clauses are one and the same, but they're not.
The main difference between a UNION clause and a UNION ALL SQL clause is that a UNION SQL clause only provides unique records, while a UNION ALL clause provides all records, including duplicates.

3)
Last but not least, we have database disaster recovery.
When asked what is a good database (not only MySQL Server) disaster recovery strategy, some may say that they have a replica working with their primary database.
Again, there's nothing wrong with that, but relying solely on database replicas is a risky strategy. Look into periodically backing up your MySQL database, offsite storage, failover mechanisms, or even database load balancers like ProxySQL.

If you've enjoyed such a SQL interview video concept, make sure to subscribe to this database tutorial channel and share this sql interview questions and answers video with your friends to see more videos concerning sql interviews, sql injection, database performance and other concepts, and until next time.

#interview #mysql #mariadb #developer #database #sql