Jul 3, 2017

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?