Google

MYSQL Interview Questions

MYSQL Interview Questions

  1. What are CSV tables?
  2. What does myisamchk do?
  3. Explain about normalization?
  4. Explain about MyISAM table?
  5. Explain about database design?
  6. Explain about creating database?
  7. When is a declare statement needed?
  8. Explain some of the uses of MYSQL?
  9. What is SERIAL data type in MySQL?
  10. State some of the features of MYSQL?
  11. Explain about MYSQL and its features?
  12. What does “tee” command do in MySQL?
  13. What? s the default port for MySQL Server?
  14. Which version of MySQL supports Subquery?
  15. What is the Oracle rowid counterpart in MySQL?
  16. How do you start and stop MySQL on Windows?
  17. Use mysqldump to create a copy of the database?
  18. How to connect mysql from jsp (Java Server Page)?
  19. Can you save your connection settings to a conf file?
  20. State some of the disadvantages present in MYSQL?
  21. How to see the database architecture in MySQL?
  22. Explain about HEAP table?
  23. What are HEAP tables in MySQL?
  24. How to create MYSQL new users?
  25. How MySQL is different from SQL?
  26. How do you start MySQL on Linux?
  27. Explain about the time stamp field?
  28. How do you control the max size of a HEAP table?
  29. What happens when we don’t use Console option?
  30. How will you export tables as an XML file in MySQL?
  31. What is a Trigger in MySQL? Define different types of Trigger?
  32. What are the advantages of mysql comparing with oracle?
  33. What happens if a table has one column defined as TIMESTAMP?
  34. What are the limitations of mysql in Comparison of Oracle?
  35. What are the advantages of Mysql comparing with oracle?
  36. State some security recommendations while using MYSQL?
  37. What are some good ideas regarding user security in MySQL?
  38. How will retrieve nth level categories from one query in mysql?
  39. Explain the difference between mysql and mysqli interfaces in PHP?
  40. Explain about a security flaw which is present while creating a username?
  41. State two considerations which can improve the performance of MYSQL?
  42. Explain about the rules which should be followed while assigning a username?
  43. What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
  44. What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
  45. How to display nth highest record in a table for example? How to display 4th highest (salary) record from customer table?
  46. How we can count duplicate entery in particular table against Primary Key? What are constraints?
  47. How do you change a password for an existing user via mysqladmin?
  48. What packages (if any) has Oracle provided for use by developers?
  49. What are the security recommendations while using MySQL?
  50. What are the Performance and Scalability characteristics of MySQL?
  51. What is MySQL data directory? How to determine the location of the data directory?
Article Global Facebook Twitter Myspace Friendfeed Technorati del.icio.us Digg Google StumbleUpon Eli Pets



Follow us on Google Plus