Basic & Advanced MySQL Interview Questions with Answers

  • 10_What is the default port for MySQL Server
  • 11_How would you select all the users whose phone number is null
  • 12_What are ENUMs used for in MySQL
  • 13_What are the advantages of Mysql comparing with oracle
  • 14_What is the difference between CHAR_LENGTH and LENGTH
  • 15_How are ENUMs and SETs represented internally
  • 16_How do you change a password for an existing user via mysqladmin
  • 17_If the value in the column is repeatable how do you find out the unique values
  • 18_Explain the difference between FLOAT DOUBLE and REAL