Top MySql Interview Questions And Answers Part 2
1. How to represent ENUMs and SETs internally?
ENUMs and SETs are used to represent powers of two because of storage optimizations. i.e Create table size(name ENUM(‘Small’, ‘Medium’,’Large’);
2. Give string types available for column?
The string types are:
3. What are the drivers in MySQL?
Following are the drivers available in MySQL:
- PHP Driver
- ODBC Driver
- JDBC Driver
- C WRAPPER
- PYTHON Driver
- PERL Driver
- RUBY Driver..So on
4. What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
TIMESTAMP column is updated with Zero when the table is created. UPDATE CURRENT_TIMESTAMP modifier updates the timestamp field to current time whenever there is a change in other fields of the table.
5. What does myisamchk do?
It compress the MyISAM tables, which reduces their disk or memory usage.