Q: 1 SET concept used in ______________.
Network Model
Hierarchical Model
Relational Model
Object Oriented Model
[ Option A ]
The SET concept is used in the Network Data Model. In this model, data is represented using records and set types, where a set defines a relationship between two record types:
A set represents a 1-to-many relationship, where one owner record can be linked to multiple member records.
| MODEL | RELATIONSHIP REPRESENTATION |
|---|---|
| Network Model | Uses set (owner-member). |
| Hierarchical Model | Uses tree structure (parent-child). |
| Relational Model | Uses tables (rows and columns). |
| Object-Oriented Model | Uses objects and classes. |
Q: 2 Which of the following is a hierarchical database system?
DBMS
IMS
MNS
None of the above
[ Option B ]
IMS (Information Management System) is a well-known hierarchical database management system developed by IBM.
In IMS, data is organized in a tree-like structure with parent–child relationships, where each child has only one parent.
Q: 3 In the network database model, which type of relationship exists?
Parent-child relationship
Owner-member type relationship
Member-member type relationship
None of the above
[ Option B ]
The Network Model represents relationships using the set construct, where each set consists of an owner record and one or more member records. This is known as an owner–member relationship and allows a record to have multiple parents, supporting many-to-many relationships.
Q: 4 Which database model uses a tree data structure?
Relational model
Hierarchical model
Network model
Object-Oriented model
[ Option B ]
The hierarchical database model organizes data in a tree-like structure, where each parent record can have multiple child records, but each child has only one parent. This represents a one-to-many relationship.
| DATA MODEL | STRUCTURE USED | DESCRIPTION |
|---|---|---|
| Hierarchical Model | Tree | Data is organized in parent–child form with one-to-many relationships. |
| Network Model | Graph | Records are connected using pointers allowing many-to-many relationships. |
| Relational Model | Tables (Rows & Columns) | Data is stored in tables and accessed using SQL. |
| Entity-Relationship (E-R) Model | Diagrammatic | Used for conceptual database design using entities and relationships. |
| Object-Oriented Model | Objects | Data is stored as objects with attributes and methods. |
| Object-Relational Model | Tables and Objects | Relational model extended with object-oriented features. |
| Distributed Data Model | Multiple sites | Data is stored across different locations but works as one database. |
Thank you so much for taking the time to read my Computer Science MCQs section carefully. Your support and interest mean a lot, and I truly appreciate you being part of this journey. Stay connected for more insights and updates! If you'd like to explore more tutorials and insights, check out my YouTube channel.
Don’t forget to subscribe and stay connected for future updates.