Free MySQL Interview Questions for Software Testing freshers

1. What is difference between Delete, Drop and Truncate?
2. What is Left join, Right join and Self join?
3. What is a Schema?
4. What is a View?
5. What are Wildcard Characters?
6. What is Primary key?

7. What is difference between Null and Blank?
8. Write a query to fetch employee having 2nd highest salary?
9. Differentiate between Group by and Having commands?
10. Write a query to display unique records from a table.
11. Write a SQL statement to fetch employees having salary between 20000 and 40000.
12. What does * mean in 'select * from <tablename>' ?
13. What is the difference between Union and Union All?