Interview Questions of MySQL

August 7, 2016 by Arti Khedkar

Filed under Database, MySQL

Last modified August 7, 2016

         Interview Questions of MySQL

  1. What is MySQL?
  2. In which language MySQL is written?
  3. What are the technical specification of MySQL?
  4. How many Triggers are possible in MySQL?
  5. What is heap table?
  6. What is BLOB and TEXT in MySQL?
  7. What is a trigger in MySQL?
  8. What is the difference between heap table and temporary table?
  9. What is the difference between FLOAT and DOUBLE?
  10. What are the advantages of MySQL in comparison to Oracle?
  11. Tell us something about Heap tables.
  12. How do you control the max size of a HEAP table?
  13. How can we convert between Unix & MySQL timestamps?
  14. What is BLOB?
  15. How would concatenate strings in MySQL?
  16. Differentiate CHAR_LENGTH and LENGTH?
  17. How to represent ENUMs and SETs internally?
  18. What is the usage of ENUMs in MySQL?
  19. Define REGEXP?
  20. Difference between CHAR and VARCHAR?
  21. Give string types available for column?
  22. What storage engines are used in MySQL?
  23. What are the drivers in MySQL?
  24. What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
  25. What is the difference between primary key and candidate key?
  26. How do you login to MySql using Unix shell?
  27. What does myisamchk do?How do you control the max size of a HEAP table?
  28. What is the difference between MyISAM Static and MyISAM Dynamic?
  29. What are federated tables?
  30. What, if a table has one column defined as TIMESTAMP?
  31. What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
  32. How can we find out which auto increment was assigned on Last insert?
  33. What do you mean by % and _ in the LIKE statement?How can we convert between Unix & MySQL timestamps?
  34. What are the column comparisons operators?
  35. How can we get the number of rows affected by query?
  36. What is the difference between the LIKE and REGEXP operators?
  37. What is the difference between BLOB AND TEXT?
  38. What is the difference between mysql_fetch_array and mysql_fetch_object?
  39. How can we run batch mode in mysql?
  40. Where MyISAM table will be stored and also give their formats of storage?
  41. What are the different tables present in MySQL?
  42. What is ISAM?
  43. What is InnoDB?
  44. How MySQL Optimizes DISTINCT?
  45. How to enter Characters as HEX Numbers?
  46. < How to display top 50 rows?
  47. How many columns can be used for creating Index?
  48. What is the different between NOW() and CURRENT_DATE()?
  49. What are the objects can be created using CREATE statement?
  50. What are the nonstandard string types?

 

 

 

Leave a Comment