Some of the basic questions in MYSQL includes:


  • What is the current version of MYSQL you are using.
  • What are the storage engines in MYSQL
  • What is the default storage engine in MYSQL
  • What are the different types of data types 
  • What is the difference between char and varchar
  • What is LONGTEXT and how much space it occupies by default
  • What are MYSQL Clusters
  • What are indexes.
  • How can you optimize queries
  • What are the basic mysql functions to fetch data 
  • Design a sample employee table with other tables - salary, location etc.

0 comments:

Post a Comment