Explain the difference between FLOAT, DOUBLE and

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

(Continued from previous question...)

Explain the difference between FLOAT, DOUBLE and REAL.

FLOATs store floating point numbers with 8 place accuracy and take up 4 bytes. DOUBLEs store floating point numbers with 16 place accuracy and take up 8 bytes. REAL is a synonym of FLOAT for now.

(Continued on next question...)

Other Job Interview Questions

• MySQL - Using Your Own Benchmarks
• What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
• Setting Up the Initial MySQL Privileges
• MySQL - Optimization Overview
• MySQL - How do I rotate replication logs?
• How do you find out which auto increment was assigned on the last insert?
• Explain federated tables.
• MySQL - How the Privilege System Works
• MySQL - When Privilege Changes Take Effect
• How would you change a column from VARCHAR(10) to VARCHAR(50)?
• More...