250+ TOP MCQs on Components of DBMS and Answers

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

This is important because the products of cvs are not approved for human use in the usa. Costco offers more than just https://millerwriter.com/book/complete-idiots-guide-music-composition Yoshkar-Ola a variety of items at competitive prices. It has an extensive section that provides a comprehensive information about misoprostol including all its available information like dosage and how to take it, the way it works and the way of usage of misoprostol.

D’autres bénéfices pour les opérateurs de transports et les écologistes, dont le port de villefranche-sur-mer. Buy 20mg tadalafil tablets online from the neurontin without prescription leading online pharmacy! This helps in controlling fertility, especially when taken for long period like 3 to 6 months.

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.