MS Access is a/an

[amp_mcq option1=”relational DBMS” option2=”network DBMS” option3=”object-oriented DBMS” option4=”hierarchical DBMS” correct=”option1″]

This question was previously asked in

UPSC CISF-AC-EXE – 2024

Download PDF Attempt Online

The correct answer is A) relational DBMS. Microsoft Access is a database management system (DBMS) from Microsoft. It is designed to manage data using tables that are organized into fields and records, and allows for defining relationships between these tables using primary and foreign keys. This structure fits the definition of a relational database management system (RDBMS).

MS Access stores data in tables and uses relationships between tables to organize and manage data, which is characteristic of a Relational Database Management System.

Network, object-oriented, and hierarchical DBMS represent different data modeling structures. Network DBMS uses a graph-like structure, hierarchical DBMS uses a tree-like structure, and object-oriented DBMS stores data as objects. Relational DBMS (like MS Access, MySQL, SQL Server, Oracle) organizes data in tables with defined relationships.

More similar MCQ questions for Exam preparation:-