CAF-3 · Chapter 5
Types of DBMS MCQs with Answers
15 multiple-choice questions on Types of DBMS for CAF-3 Data, Systems and Risks. Try each one before revealing the answer and explanation.
Practise this chapter interactivelyQuestion 1
What is the primary function of a Database Management System (DBMS)?
- A) To create physical network connections between servers
- B) To store, retrieve, and manage structured and unstructured data efficiently while ensuring security and integrity
- C) To permanently replace all manual spreadsheet applications
- D) To format and design front-end user interfaces
Show answer & explanation
Answer: B) To store, retrieve, and manage structured and unstructured data efficiently while ensuring security and integrity
A DBMS is a powerful software tool that enables organizations to handle vast amounts of structured and unstructured data with precision, security, and scalability
Question 2
A customer transfers Rs. 10,000 to another account. The system deducts the money from the sender but crashes before adding it to the receiver. When the system restarts, it completely rolls back the deduction as if it never happened. Which ACID property ensures this "all or nothing" execution?
- A) Atomicity
- B) Consistency
- C) Isolation
- D) Durability
Show answer & explanation
Answer: A) Atomicity
Atomicity ensures that a transaction is treated as a single, indivisible unit. It guarantees an "all or nothing" execution, meaning if any part of the transaction fails, the entire transaction is rolled back
Question 3
Two customers try to purchase the last available airline ticket at the exact same millisecond. The DBMS ensures that these concurrent transactions do not interfere with each other. This represents which ACID property?
- A) Atomicity
- B) Consistency
- C) Isolation
- D) Durability
Show answer & explanation
Answer: C) Isolation
Isolation ensures that concurrent transactions occur independently without interfering with each other, maintaining data accuracy
Question 4
Once an online order is confirmed by the DBMS, the changes are permanently saved in the database. Even if a sudden power failure occurs immediately afterward, the order record will not be lost. This is an example of:
- A) Atomicity
- B) Consistency
- C) Isolation
- D) Durability
Show answer & explanation
Answer: D) Durability
Durability guarantees that once a transaction is committed, its effects are permanently saved and recoverable, even in the event of a system crash or power failure . --------------------------------------------------------------------------------
Question 5
In a company's database, the HR department has a view showing employee salaries, while the Sales department has a view showing customer details but cannot see salaries. Which level of the DBMS architecture provides these customized views?
- A) Internal Level
- B) Conceptual Level
- C) External Level
- D) Physical Level
Show answer & explanation
Answer: C) External Level
The External Level (or View Level) is the highest level of DBMS architecture. It provides customized views of the database to different users or departments based on their roles, restricting access to irrelevant data
Question 6
Which level of the DBMS architecture acts as the global logical view of the entire database, defining entities, attributes, and relationships without worrying about how data is physically stored?
- A) External Level
- B) Conceptual Level
- C) Internal Level
- D) View Level
Show answer & explanation
Answer: B) Conceptual Level
The Conceptual Level describes what data is stored in the entire database and the relationships among the data. It defines the logic without specifying physical storage details
Question 7
The IT department decides to re-index the database and move the data files to a new, faster SSD storage drive. This change does not affect how the users query the data. This represents which level of the DBMS architecture?
- A) Conceptual Level
- B) External Level
- C) Internal Level
- D) Application Level
Show answer & explanation
Answer: C) Internal Level
The Internal Level (or Physical Level) deals with the physical storage of the database on disks, including the use of file structures, data blocks, and indexing strategies . --------------------------------------------------------------------------------
Question 8
The ability to modify the physical storage mechanisms (like changing hard drives or compressing data) without impacting the logical structure or how users access the data is known as:
- A) Logical Data Independence
- B) Physical Data Independence
- C) Entity Integrity
- D) Referential Integrity
Show answer & explanation
Answer: B) Physical Data Independence
Physical data independence ensures that changes to the internal storage mechanisms (physical storage) do not impact the logical schema or the way data is accessed by users
Question 9
A database administrator adds a new column, "Customer_Age", to an existing table. This modification to the schema does not break the existing front-end software applications. This is an example of:
- A) Logical Data Independence
- B) Physical Data Independence
- C) Durability
- D) Atomicity
Show answer & explanation
Answer: A) Logical Data Independence
Logical data independence means that changes to the logical schema (e.g., adding a column) do not affect the external views or the application layer . --------------------------------------------------------------------------------
Question 10
In an Entity-Relationship model, an attribute such as 'FullName' that can be further broken down into 'FirstName' and 'LastName' is classified as a:
- A) Simple Attribute
- B) Derived Attribute
- C) Composite Attribute
- D) Multivalued Attribute
Show answer & explanation
Answer: C) Composite Attribute
A composite attribute is an attribute that can be broken down into smaller, meaningful sub-attributes, such as breaking a full name into a first name and a last name
Question 11
A university database shows that one student can enroll in multiple courses, and each course can have multiple students enrolled in it. What type of relationship does this represent?
- A) One-to-One (1:1)
- B) One-to-Many (1:N)
- C) Many-to-Many (M:N)
- D) Zero-to-Many (0:N)
Show answer & explanation
Answer: C) Many-to-Many (M:N)
In a Many-to-Many (M:N) relationship, many entity instances can be associated with many instances of another entity (e.g., students and courses)
Question 12
What term is used in database design to specify the maximum number of relationship instances in which an entity can participate (such as 1:1, 1:N, or M:N)?
- A) Atomicity
- B) Normalization
- C) Integrity
- D) Cardinality
Show answer & explanation
Answer: D) Cardinality
Cardinality specifies the maximum number of relationship instances in which an entity can participate, defining whether a relationship is one-to-one, one-to-many, or many-to-many . --------------------------------------------------------------------------------
Question 13
Which type of Database Management System organizes data in a strict tree-like structure where each child record can have only one parent?
- A) Relational DBMS
- B) Network DBMS
- C) Hierarchical DBMS
- D) Object-Oriented DBMS
Show answer & explanation
Answer: C) Hierarchical DBMS
A Hierarchical DBMS organizes data in a tree-like structure where data elements are arranged in parent-child relationships, and each child node can only have one parent
Question 14
Oracle, MySQL, and Microsoft SQL Server are highly popular systems that organize data into tables containing rows and columns. These are examples of:
- A) Hierarchical DBMS
- B) Network DBMS
- C) Object-Oriented DBMS
- D) Relational DBMS (RDBMS)
Show answer & explanation
Answer: D) Relational DBMS (RDBMS)
Relational Database Management Systems (RDBMS) store data in table-based structures with rows (records) and columns (attributes). Popular examples include Oracle, MySQL, and SQL Server
Question 15
Which type of DBMS supports concepts like 'Inheritance' and 'Polymorphism', storing data as entities that contain both the data and the methods used to manipulate it?
- A) Object-Oriented DBMS (OODBMS)
- B) Relational DBMS (RDBMS)
- C) Hierarchical DBMS
- D) Network DBMS
Show answer & explanation
Answer: A) Object-Oriented DBMS (OODBMS)
An Object-Oriented DBMS (OODBMS) stores data as objects containing both data and methods, and it supports advanced programming concepts like inheritance and polymorphism