MySQL Interview questions

Total available count: 24
Subject - Databases
Subsubject - MySQL

Difference between CHAR and VARCHAR?

The differences between CHAR and VARCHAR are as follows,

  1. CHAR and VARCHAR types differ in retrieval and storage
  2. CHAR column length is fixed to the length that is declared while creating a table. The length value ranges from 1 and 255
  3. When CHAR values are stored then they are right padded using spaces to a specific length. Trailing spaces/Blank spaces are removed when CHAR values are retrieved

Next 5 interview question(s)

What are the advantages of MySQL when compared with Oracle?
What are Heap tables?
Why MySQL is used?
What are the technical features of MySQL?
What is MySQL?