MySQL Interview questions

Total available count: 24
Subject - Databases
Subsubject - MySQL

What are Heap tables?

HEAP tables are present in memory and they are used for high-speed storage on a temporary basis,

  1. In HEAP tables BLOB or TEXT fields are not allowed
  2. Only comparison operators can be used =, <,>, = >,=<
  3. AUTO_INCREMENT is not supported by HEAP tables
  4. Indexes should be NOT NULL

Next 3 interview question(s)

Why MySQL is used?
What are the technical features of MySQL?
What is MySQL?