Q. 1. What is MySQL?

MySQL is an open source DBMS which is built, supported and distributed by MySQL AB (now acquired by Oracle)


Q. 2. What are the technical features of MySQL?

MySQL database software is a client or server system which includes Multithreaded SQL server supporting various client programs and libraries Different backend Wide range of application programming interfaces and Administrative tools.


Q. 3. Why MySQL is used?

MySQL database server is reliable, fast and very easy to use. This software can be downloaded as freeware and can be downloaded from the internet.


Q. 4. What are Heap tables?

HEAP tables are present in memory and they are used for high speed storage on temporary basis. BLOB or TEXT fields are not allowed Only comparison operators can be used =, <,>, = >,=< AUTO_INCREMENT is not supported by HEAP tables Indexes should be NOT NULL