Mysql interview questions:

  1. what is mysql?
  2. what is table?
  3. what is msql?
  4. what is table?
  5. what is sql?
  6. How do you prevent MySQL from caching a query?
  7. What’s the difference between PRIMARY KEY and UNIQUE in MyISAM?
  8. What’s the difference between query_cache_type 1 and 2?
  9. How do you index just the first four bytes of the column?
  10. How do you convert to a different table type?
  11. Which storage engines support transactions in MySQL?
  12. What’s ACID?
  13. Explain MySQL architecture.
  14. Explain MySQL locks.
  15. Explain multi-version concurrency control in MySQL.
  16. What are MySQL transactions?
  17. How many TRIGGERS are allowed in MySql table?
  18. Differentiate between FLOAT and DOUBLE.
  19. Tell us something about Heap tables.
  20. How do you control the max size of a HEAP table?
  21. What are the advantages of MySQL in comparison to Oracle?
  22. What does myisamchk do?
  23. What is BLOB?
  24. What is TEXT?
  25. What is the difference between BLOB and TEXT?
  26. How is MyISAM table stored?
  27. Explain advantages of MyISAM over InnoDB?
  28. How would concatenate strings in MySQL?
  29. How would you get the current date in Mysql?
  30. How would you enter Characters as HEX Numbers?
  31. How are MySQL timestamps seen to a user?
  32. Explain about MySQL and its features.
  33. What are the disadvantages of MySQL?
  34. What are the security recommendations while using MySQL?
  35. Describe MyISAM table.
  36. What is HEAP table?
  37. What is Query Cache in MySQL?
  38. How is Exception Handling handled in MySQL?
  39. What are the Performance and Scalability characteristics of MySQL?
  40. What are the limitations of mysql in Comparison of Oracle?
  41. What is a Trigger in MySQL? Define different types of Trigger?
  42. What is the difference between CHAR_LENGTH and LENGTH?
  43. Explain the difference between BOOL, TINYINT and BIT.
  44. What are ENUMs used for in MySQL?
  45. Explain MySQL Aggregate Functions.
  46. Describe Transaction-Safe Table Types in MySQL
  47. Describe MySQL Connection using mysql binary.
  48. Explain advantages of MyISAM over InnoDB
  49. MySQL – Stored Procedures and Triggers
  50. Primary Keys and Auto Increment Fields in MySQL
  51. COMMIT and ROLLBACK in MySQL
  52. ALTER command to add and drop INDEX in MySQL
  53. Describe MySQL Connection using PHP Script.
  54. Test your mysql knowledge with our multiple choice questions!
  55. How will you export tables as an XML file in MySQL?
  56. What is the use of i-am-a-dummy flag in MySQL?
  57. What are the differences between MySQL_fetch_array(), MySQL_fetch_object(),MySQL_fetch_row()?
  58. What is difference between mysql_connect and mysql_pconnect?
  59. What is MySQL data directory? How to determine the location of the data directory?
  60. What you can use Regular Expression for in MySQL? Support your answer with an example.How
  61. Will you export tables as an XML file in MySQL?
  62. What is the use of i-am-a-dummy flag in MySQL?
  63. What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?
  64. What is MySQL data directory? How to determine the location of the data directory?
  65. What you can use Regular Expression for in MySQL? Support your answer with an example.
  66. What is difference between mysql_connect and mysql_pconnect?
  67. Mysql_connect:
  68. Mysql_pconnect:
  69. What is MySQL data directory? How to determine the location of the data directory?
  70. What you can use Regular Expression for in MySQL? Support your answer with an example.
  71. How will retrieve nth level categories from one query in MySQL ?
  72. How is structure of a table got in MySQL?
  73. what is MySQL operator?
  74. How is stored procedures managed in MySQL?
  75. What are the link types for joins, =? What datasets result?
  76. what are PL/SQL views and cursors?
  77. What is the differance between exec and execute in stored procedure?
  78. How do you use outer join in MySQL
  79. How to view all triggers in MySQL?
  80. What are the data types available in MySQL?
  81. What is reload privileges in MySQL used for?
  82. What is the command for counting all the rows in a table in MySQL?
  83. Is it possible to delete duplicate records from a table with out using rowid in MySQL?
  84. What are the platforms supported by MySQL?
  85. How may types of joins supported in mysql
  86. How database is copied from one machine to another
  87. How to display nth highest record in a table for example ?