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.