Computer Fundamentals Multiple choice Questions and Answers on Components of DBMS for Freshers

1. DBMS is a set of __________ to access the data.

a) Codes
b) Programs
c) Information
d) Metadata

Answer: b

Explanation: 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

Explanation: 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

Explanation: 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

Explanation: 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

Explanation: 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

Explanation: 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

Explanation: 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

Explanation: 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

Explanation: 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

Explanation: The answer is logical. The logical level describes the relationships between the data. Physical level describes how the data is stored.