MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In this type of database model, the schema, is represented using nodes and relationship types and is not restricted to being a hierarchy or lattice
A
Relational Database
B
Hierarchical Database
C
Network Database
D
Object Oriented Database
Explanation: 

Detailed explanation-1: -The network model is a database model conceived as a flexible way of representing objects and their relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice.

Detailed explanation-2: -Types of database models Hierarchical database model. Relational model. Network model. Object-oriented database model.

Detailed explanation-3: -Relational Model (RM) represents the database as a collection of relations. A relation is nothing but a table of values. Every row in the table represents a collection of related data values.

Detailed explanation-4: -Cons of Hierarchical Model Relationships that are complex are not supported. Because it only supports one parent per child node, if we have a complex relationship in which a child node needs to have two parents, we won’t be able to describe it using this model.

Detailed explanation-5: -A hierarchical model represents the data in a tree-like structure in which there is a single parent for each record. To maintain order there is a sort field which keeps sibling nodes into a recorded manner.

There is 1 question to complete.