How are ENUMs and SETs represented internally?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How are ENUMs and SETs represented internally?

As unique integers representing the powers of two, due to storage optimizations.

(Continued on next question...)

Other Job Interview Questions

• MySQL - Startup options to mysqld which concerns security
• How would you change a table to InnoDB?
• MySQL - Drawbacks to Creating Large Numbers of Tables in the Same Database
• How MySQL Stores Its Row Data and Index Data?
• What are HEAP tables in MySQL?
• Functionality Missing from MySQL - Foreign Keys
• MySQL - Setting Up Passwords
• MySQL - Optimization Overview
• What are HEAP tables in MySQL?
• What does + mean in REGEXP?
• More...