Open-source DBMS identification: ________ is a well-known open-source relational DBMS product that runs on UNIX, Linux, and Windows platforms and is frequently used with web applications.

Difficulty: Easy

Correct Answer: MySQL

Explanation:


Introduction / Context:
Open-source relational database management systems power a large percentage of modern web and enterprise applications. Being able to recognize widely deployed products and their typical environments is basic knowledge for developers and DBAs alike.



Given Data / Assumptions:

  • The product runs across major operating systems: UNIX, Linux, Windows.
  • It is open source and widely adopted.
  • It is a DBMS, not a programming API or web technology.


Concept / Approach:

MySQL is an open-source RDBMS known for LAMP/LEMP stacks (Linux/UNIX, Apache/Nginx, MySQL, PHP/Python). It supports SQL, replication, and storage engines like InnoDB. Alternative well-known open-source DBMSs include PostgreSQL, but among the options provided, MySQL is the correct match. The other options are not DBMS products.



Step-by-Step Solution:

Filter options for “DBMS product” versus “technology/API”.Identify MySQL as the only DBMS listed.Confirm cross-platform support: UNIX, Linux, Windows → MySQL qualifies.


Verification / Alternative check:

Check typical stacks: WordPress, MediaWiki, and many applications support MySQL as a first-class database.



Why Other Options Are Wrong:

JSP/SQL and JDBC/SQL: these are programming acronyms/APIs, not DBMS products.

Sun ACCESS: not a recognized open-source DBMS; likely a distractor.



Common Pitfalls:

Confusing query languages (SQL) or APIs (JDBC) with database servers; overlooking that multiple open-source DBMSs exist but only one appears in the choices.



Final Answer:

MySQL

More Questions from JDBC, Java Server Pages, and MySQL

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion