Data Models in DBMS

In the hierarchical database model, data is organized in a:

• 4. Graph

• Tree structure

• Matrix

• Relational table

Which of the following is a characteristic of the hierarchical database model?

• Many-to-many relationships

• Parent-child relationships

• Data is stored in tables

In a hierarchical database model, a parent node can have:

• • A. Only one child node

• • B. Multiple child nodes

• • C. Multiple parent nodes

• D. Only one parent node

In the hierarchical model, each child node has:

• • Only one parent node

• • Multiple parent nodes

• • No parent node

• Independent relationships

One of the disadvantages of the hierarchical database model is:

• Slow data retrieval

• Lack of data integrity

• Difficulty in handling many-to-many relationships

• Complex implementation

Which of the following is true for hierarchical databases?

• They do not support parent-child relationships.

• They are ideal for many-to-many relationships.

• They are well-suited for applications with a clear hierarchy.

In a hierarchical database model, accessing data is:

• Based on a mathematical formula

• Done through direct pointers between nodes

• Handled by complex joins

• 1. Achieved through natural language processing

Which of the following is a characteristic of the network database model?

• Many-to-many relationships

• Single parent-child relationships

• Data is stored in tables

• 1. Only one-to-one relationships

In the network model, each record can have:

• Only one parent

• No parent

• Multiple parents

• Only one child

Which of the following is true for network databases?

• • They do not support many-to-many relationships.

• They are less flexible than hierarchical databases.

• They are well-suited for applications requiring complex relationships.