MySQL is Open Source DBMS - Database

Q.  Which of the following is an Open Source DBMS?
- Published on 19 Oct 15

a. MySQL
b. Microsoft SQL Server
c. Microsoft Access
d. Oracle

ANSWER: MySQL
 

    Discussion

  • Nirja Shah   -Posted on 29 Oct 15
    - MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses.

    - It is developed, marketed, and supported by MySQL AB, which is a Swedish company.

    - It is becoming so popular because of many good reasons:

    1. It has been released under an open-source license. So you have nothing to pay to use it.

    2. It's a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.

    3. A standard form of the well-known SQL data language is being used.

    4. It works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.

    5. This DBMS works very quickly and works well even with large data sets.

    6. It is very friendly to PHP, the most appreciated language for web development.

    7. They support large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).

    8. It is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)