What is an example of a relational database management system (RDBMS)?

What is an example of a relational database management system (RDBMS)?

• A. Oracle
• B. MySQL
• C. MongoDB
• D. SQLite

Answer: (B)

MySQL is a widely recognized example of a relational database management system (RDBMS) and is noted for its use of structured query language (SQL) for managing and manipulating relational databases. MySQL allows for the creation, retrieval, update, and deletion of structured data organized in tables with predefined relationships, which is the core functionality of an RDBMS. It supports various data types, primary keys, foreign keys, and integrity constraints, ensuring that data is accurate and accessible. The other options represent different types of database management systems. Oracle is also an RDBMS and is known for its enterprise capabilities, while SQLite serves as a lightweight, file-based RDBMS for smaller applications. In contrast, MongoDB is classified as a NoSQL database, which stores data in flexible, unstructured formats such as JSON-like documents, making it fundamentally different from relational systems that require a fixed schema. Hence, MySQL stands out as a classic example of an RDBMS due to its relational structure and SQL capabilities.

MySQL is a widely recognized example of a relational database management system (RDBMS) and is noted for its use of structured query language (SQL) for managing and manipulating relational databases. MySQL allows for the creation, retrieval, update, and deletion of structured data organized in tables with predefined relationships, which is the core functionality of an RDBMS. It supports various data types, primary keys, foreign keys, and integrity constraints, ensuring that data is accurate and accessible.

The other options represent different types of database management systems. Oracle is also an RDBMS and is known for its enterprise capabilities, while SQLite serves as a lightweight, file-based RDBMS for smaller applications. In contrast, MongoDB is classified as a NoSQL database, which stores data in flexible, unstructured formats such as JSON-like documents, making it fundamentally different from relational systems that require a fixed schema. Hence, MySQL stands out as a classic example of an RDBMS due to its relational structure and SQL capabilities.