MySQL Interview Questions
Q.
What is MySQL?
▾
Q.
What is a Database?
▾
Q.
What is DBMS?
▾
Q.
What is RDBMS?
▾
Q.
What is SQL?
▾
Q.
What is a Table?
▾
Q.
What is a Primary Key?
▾
Q.
What is a Foreign Key?
▾
Q.
What is the difference between Primary Key and Foreign Key?
▾
Q.
What is a UNIQUE Key?
▾
Q.
What is NULL?
▾
Q.
What is the difference between DELETE, TRUNCATE, and DROP?
▾
Q.
What is DDL?
▾
Q.
What is DML?
▾
Q.
What is DQL?
▾
Q.
What is WHERE?
▾
Q.
What is GROUP BY?
▾
Q.
What is HAVING?
▾
Q.
What is ORDER BY?
▾
Q.
What is LIMIT?
▾
Q.
What is a JOIN?
▾
Q.
What are the types of JOINs in MySQL?
▾
Q.
What is INNER JOIN?
▾
Q.
What is LEFT JOIN?
▾
Q.
What is the difference between INNER JOIN and LEFT JOIN?
▾
Q.
What is a Subquery?
▾
Q.
What is UNION?
▾
Q.
What is the difference between UNION and UNION ALL?
▾
Q.
What is an Index?
▾
Q.
Why shouldn't we create indexes on every column?
▾
Q.
What is a Transaction?
▾
Q.
What is ACID?
▾
Q.
What is COMMIT?
▾
Q.
What is ROLLBACK?
▾
Q.
What is a Deadlock?
▾
Q.
What is EXPLAIN?
▾
Q.
How do you optimize a slow MySQL query?
▾
Q.
What is a Window Function?
▾
Q.
What is a CTE?
▾
Q.
What is a CTE?
▾
Q.
What is MVCC?
▾
Q.
What is Replication?
▾
Q.
What is Database Sharding?
▾
Q.
How do you find the second-highest salary?
▾
Q.
How do you find duplicate emails?
▾
Q.
How do you find employees whose salary is greater than the average salary?
▾
Q.
How do you find the highest salary in each department?
▾
Q.
How do you find the top 3 salaries from each department?
▾
Q.
How do you find users who have never placed an order?
▾
Q.
How do you find the latest order of every customer?
▾