What is MySQL?
-->MySQL is an open source DBMS which is built, supported and distributed by MySQL AB (now acquired by Oracle).
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.
What are Heap tables?
-->HEAP tables are present in memory and they are used for high speed storage on temporary.
What is the default port for MySQL Server?
-->The default port for MySQL server is 3306.
What are the advantages of MySQL when compared with Oracle?
Differentiate between FLOAT and DOUBLE?
Following are differences for FLOAT and DOUBLE:
-->MySQL is an open source DBMS which is built, supported and distributed by MySQL AB (now acquired by Oracle).
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.
What are Heap tables?
-->HEAP tables are present in memory and they are used for high speed storage on temporary.
What is the default port for MySQL Server?
-->The default port for MySQL server is 3306.
What are the advantages of MySQL when compared with Oracle?
- MySQL is open source software which is available at any time and has no cost involved.
- MySQL is portable
- GUI with command prompt.
- Administration is supported using MySQL Query Browser
Differentiate between FLOAT and DOUBLE?
Following are differences for FLOAT and DOUBLE:
- Floating point numbers are stored in FLOAT with eight place accuracy and it has four bytes.
- Floating point numbers are stored in DOUBLE with accuracy of 18 places and it has eight bytes.
Differentiate CHAR_LENGTH and LENGTH?
CHAR_LENGTH is character count whereas the LENGTH is byte count. The numbers are same for Latin characters but they are different for Unicode and other encodings.
0 comments:
Post a Comment