MYSQL INTERVIEW QUESTIONS

MYSQL INTERVIEW QUESTIONS

1. What is MySQL?
2. What are DDL, DML and DCL?
3. If the value in the column is repeatable, how do you find out the unique values?
4. How do you get the number of rows affected by query?
5. How do you find out which auto increment was assigned on the last insert?
6. How to change a column from VARCHAR(10) to VARCHAR(50)?
7. When do you ORDER BY in DELETE statement?
8. How to delete a column?
9. How to convert a string to UTF-8?
10. How do you concatenate strings in MySQL?
11. What is the difference between Unix timestamps and MySQL timestamps?
12. How to start MySQL on Linux?
13. What is the default port for MySQL Server?
14. What are some good ideas regarding user security in MySQL?
15. Explain advantages of MyISAM over InnoDB?
16. Explain advantages of InnoDB over MyISAM?
17. Explain the difference between MyISAM Static and MyISAM Dynamic?
18. What are HEAP tables in MySQL?
19. Explain the difference between BOOL, TINYINT and BIT?
20. How to Make MySQL Secure Against Crackers?
21. What are CSV tables?
22. How the Privilege System Works in mysql?
23. What issues should I be aware of when setting up two-way replication?
24. How do I rotate replication logs?
25. When and how much can MySQL replication improve the performance of my system?
26. How can I use replication to provide redundancy/high availability?
27. How MySQL Uses Memory?
28. How MySQL Locks Tables?
29. How MySQL uses DNS?
30. How MySQL Uses Indexes?
31. How MySQL Optimizes WHERE Clauses?
32. How MySQL Optimizes DISTINCT?
33. How MySQL Optimizes LEFT JOIN and RIGHT JOIN?
34. How MySQL Optimizes LIMIT?
35. What is the difference between mysql_fetch_array and mysql_fetch_object?
36. What are the different table present in MYsql?