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)

1
Why MySQL is used?
2
What are the technical features of MySQL?
3
What is MySQL?