Q#1: A data model is used to:
(A) Store hardware
(B) Describe the structure of a database
(C) Design network cables
(D) Install software
Answer: (B) Describe the structure of a database
Q#2: Which of the following is a type of data model?
(A) Relational Model
(B) Printing Model
(C) Editing Model
(D) Drawing Model
Answer: (A) Relational Model
Q#3: The hierarchical model organizes data in the form of:
(A) Table
(B) Tree
(C) Graph
(D) Array
Answer: (B) Tree
Q#4: The network model organizes data using:
(A) Tables
(B) Lists
(C) Graph structure
(D) Files
Answer: (C) Graph structure
Q#5: The relational model was proposed by:
(A) Charles Babbage
(B) E. F. Codd
(C) Bill Gates
(D) Alan Turing
Answer: (B) E. F. Codd
Q#6: In the relational model, data is stored in:
(A) Files
(B) Trees
(C) Tables
(D) Graphs
Answer: (C) Tables
Q#7: A row in a relational table is called a:
(A) Attribute
(B) Tuple
(C) Field
(D) Domain
Answer: (B) Tuple
Q#8: A column in a relational table is called an:
(A) Record
(B) Tuple
(C) Attribute
(D) File
Answer: (C) Attribute
Q#9: The Entity-Relationship model is mainly used for:
(A) Data storage
(B) Data transmission
(C) Database design
(D) Data encryption
Answer: (C) Database design
Q#10: In ER model, a rectangle represents:
(A) Attribute
(B) Entity
(C) Relationship
(D) Key
Answer: (B) Entity
Q#11: In ER diagram, an oval represents:
(A) Entity
(B) Relationship
(C) Attribute
(D) Constraint
Answer: (C) Attribute
Q#12: In ER diagram, a diamond represents:
(A) Entity
(B) Relationship
(C) Attribute
(D) Table
Answer: (B) Relationship
Q#13: Which data model supports many-to-many relationships directly?
(A) Hierarchical
(B) Network
(C) Relational
(D) Sequential
Answer: (B) Network
Q#14: The hierarchical model supports:
(A) Many-to-many relationship
(B) One-to-one relationship only
(C) One-to-many relationship
(D) No relationship
Answer: (C) One-to-many relationship
Q#15: Which model is widely used in modern DBMS?
(A) Hierarchical
(B) Network
(C) Relational
(D) Flat file
Answer: (C) Relational
Q#16: A domain in relational model refers to:
(A) Table name
(B) Set of allowed values
(C) Database user
(D) Query
Answer: (B) Set of allowed values
Q#17: The object-oriented data model is based on:
(A) Tables
(B) Objects and classes
(C) Trees
(D) Files
Answer: (B) Objects and classes
Q#18: The object-relational model is a combination of:
(A) Hierarchical and Network
(B) Relational and Object-oriented
(C) File and Network
(D) Tree and Graph
Answer: (B) Relational and Object-oriented
Q#19: A conceptual data model focuses on:
(A) Physical storage
(B) Hardware
(C) High-level design
(D) Programming language
Answer: (C) High-level design
Q#20: A physical data model describes:
(A) Logical structure
(B) Storage details
(C) User views
(D) Relationships only
Answer: (B) Storage details
Q#21: A logical data model describes:
(A) Hardware details
(B) Physical storage
(C) Structure of data
(D) Network cables
Answer: (C) Structure of data
Q#22: In hierarchical model, each child has:
(A) Multiple parents
(B) Only one parent
(C) No parent
(D) Many roots
Answer: (B) Only one parent
Q#23: Which data model is flexible and supports complex data types?
(A) Relational
(B) Hierarchical
(C) Object-oriented
(D) Flat file
Answer: (C) Object-oriented
Q#24: The main disadvantage of hierarchical model is:
(A) Complex structure
(B) No data independence
(C) Difficulty in handling many-to-many relationships
(D) High security
Answer: (C) Difficulty in handling many-to-many relationships
Q#25: Which data model uses foreign keys to establish relationships?
(A) Relational
(B) Hierarchical
(C) Network
(D) Object-based
Answer: (A) Relational
Q#26: The ER model is considered a:
(A) Physical model
(B) Conceptual model
(C) Storage model
(D) Network model
Answer: (B) Conceptual model
Q#27: In relational model, a relation is equivalent to a:
(A) File
(B) Table
(C) Row
(D) Column
Answer: (B) Table
Q#28: Which data model is represented using pointers?
(A) Network model
(B) Relational model
(C) ER model
(D) Object model
Answer: (A) Network model
Q#29: The primary key in a relational model must be:
(A) Duplicate
(B) Null
(C) Unique
(D) Optional
Answer: (C) Unique
Q#30: Data models help in:
(A) Increasing redundancy
(B) Reducing complexity in database design
(C) Deleting hardware
(D) Installing operating systems
Answer: (B) Reducing complexity in database designData Models MCQs