Correct option is A
MS Excel is a spreadsheet application, not a Relational Database Management System (RDBMS). While it can store and manipulate data in a tabular format similar to a database, it does not provide the features of an RDBMS such as data relationships, structured query language (SQL) support, and multi-user access.
Important Key Points:
1. MS Excel: It is used for data analysis, calculations, and charting but does not support complex relational database features like indexing, querying, or data integrity constraints.
2. RDBMS Features: RDBMS systems like SQL Server, MySQL, and Oracle manage large datasets with tables, enforce relationships between data, and support advanced SQL features.
3. Data Integrity: Unlike Excel, RDBMS systems enforce rules to ensure data consistency and prevent errors through constraints like primary keys and foreign keys.
Knowledge Booster:
• SQL Server: A full-fledged RDBMS developed by Microsoft that supports SQL and is used for managing large datasets with complex relationships.
• MySQL: An open-source RDBMS known for its fast performance and reliability, commonly used for web applications.
• Oracle: A powerful and widely-used RDBMS that supports complex database structures and transactions, commonly used in enterprise environments.