Which database model improves upon the hierarchical model by allowing a child record to have multiple parent records, creating a graph-like structure? MCQ with Answer and Explanation

Which database model improves upon the hierarchical model by allowing a child record to have multiple parent records, creating a graph-like structure?
A. Flat File Model
B. Network Model
C. Star Schema
D. Relational Model
Answer: Option B
Solution (By JKSSB Mock Tests)
The Network Model represents data as graphs where a record (node) can have multiple parent and child records, solving the strict single-parent limitation of hierarchical systems.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
What is the purpose of the SQL 'CHECK' constraint?
A. To define relationships
B. To set a default value
C. To validate data based on a condition
D. To enforce uniqueness

Correct Answer: Option C


Explanation:
CHECK constraint ensures that values in a column meet a specified condition, such as age > 0.

This question belongs to: Computer Database Management System (DBMS)
Question #2
A Primary Key in RDBMS must be:
A. Always a foreign key
B. Duplicate values allowed
C. Unique and not null
D. Can have null values

Correct Answer: Option C


Explanation:
A primary key uniquely identifies each record and cannot contain null values.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is a database cursor?
A. A control structure that enables traversal over rows in a result set
B. A type of index
C. A user account
D. A backup file

Correct Answer: Option A


Explanation:
A cursor allows row-by-row processing of query results, often used in procedural extensions of SQL.

This question belongs to: Computer Database Management System (DBMS)