DBMS Components Questions and Answers

This set of Computer Fundamentals Multiple Choice Questions & Answers (MCQs) focuses on “Components of DBMS”.

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

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
View Answer

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
View Answer

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

Subscribe Now: Computer Fundamental Newsletter | Important Subjects Newsletters

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

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
View Answer

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

Get Free Certificate of Merit in Computer Fundamentals Now!

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

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
View Answer

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
View Answer

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
View Answer

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
View Answer

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

Sanfoundry Global Education & Learning Series – Computer Fundamentals.

To practice all areas of Computer Fundamentals, here is complete set of 1000+ Multiple Choice Questions and Answers.

« Prev - Computer Fundamentals Questions and Answers – DBMS

» Next - Computer Fundamentals Questions and Answers – Transmission Modes

Next Steps: