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:
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:
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
Discussion & Comments