250+ TOP MCQs on Components of DBMS and Answers

Computer Fundamentals Multiple Choice Questions on “Components of DBMS”.

1. DBMS is a set of __________ to access the data.
a) Codes
b) Programs
c) Information
d) Metadata

Answer: b
Clarification: Database is a set of programs designed to access the data. It contains information about a particular enterprise.

2. DBMS provides a convenient and efficient environment.
a) True
b) False

Answer: a
Clarification: The statement is true. DBMS stands for Database Management System. It provides an efficient and easy to use environment.

3. Which of the following isn’t a level of abstraction?
a) physical
b) logical
c) user
d) view

Answer: c
Clarification: There are three levels of abstraction: physical, logical and the view level. These three levels are involved in DBMS.

4. A level that describes how a record is stored.
a) physical
b) logical
c) user
d) view

Answer: a
Clarification: The answer is physical. The physical level describes how the record gets stored.
e.g. Customer.

5. The ______level helps application programs hide the details of data types.
a) physical
b) logical
c) user
d) view

Answer: d
Clarification: The application programs hide details of datatypes. Views can also hide information for security purposes.

6. A logical structure of the database.
a) Schema
b) Attribute
c) Parameter
d) Instance

Answer: a
Clarification: A schema is the logical structure of the database. e.g A set of customers and accounts and their relationship.

7. The actual content in the database at a particular point.
a) Schema
b) Attribute
c) Parameter
d) Instance

Answer: d
Clarification: The answer is Instance. Instance is the actual content of the database at a particular point of time.

8. Which of the following is not an object-based logical model?
a) ER
b) Network
c) Semantic
d) Functional

Answer: b
Clarification: Network model is a part of record-based logical model and not object-based. Others are object based models. ER stands for Entity-relationship.

9. SQL is _______
a) Relational
b) Network
c) IMS
d) Hierarchical

Answer: a
Clarification: SQL or structured query language is a relational model. It comes under record-based logical models.

10. A level that describes data stored in a database and the relationships among the data.
a) physical
b) logical
c) user
d) view

Answer: b
Clarification: The answer is logical. The logical level describes the relationships between the data. Physical level describes how the data is stored.