Computer Fundamentals Questions and Answers – DBMS

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

1. A collection of related data.
a) Information
b) Valuable information
c) Database
d) Metadata
View Answer

Answer: c
Explanation: Database is the collection of related data and its metadata organized in a structured format. It is designed for optimized information management.

2. DBMS is software.
a) True
b) False
View Answer

Answer: a
Explanation: The statement is true. DBMS stands for Database Management System. It enables easy creation and access of the database.

3. DBMS manages the interaction between __________ and database.
a) Users
b) Clients
c) End Users
d) Stake Holders
View Answer

Answer: c
Explanation: DBMS manages the interaction between the end users and the database. End users are the final users that interact with the database.
advertisement
advertisement

4. Which of the following is not involved in DBMS?
a) End Users
b) Data
c) Application Request
d) HTML
View Answer

Answer: d
Explanation: HTML isn’t involved in Database Management System. Other things like the data and application request are a part of the DBMS.

5. Database is generally __________
a) System-centered
b) User-centered
c) Company-centered
d) Data-centered
View Answer

Answer: b
Explanation: Database is user-centered. The perspective is that the user is always right. If there is a problem with the use of the system, the system is the problem, not the user.
Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

6. A characteristic of an entity.
a) Relation
b) Attribute
c) Parameter
d) Constraint
View Answer

Answer: b
Explanation: An attribute is a characteristic of an entity. The association among the entities is described by the relationship.

7. The restrictions placed on the data.
a) Relation
b) Attribute
c) Parameter
d) Constraint
View Answer

Answer: d
Explanation: Constraint is a restriction that is placed on the data. Attribute is the characteristic and the relation describes the association.
advertisement

8. IMS stands for?
a) Information Mastering System
b) Instruction Management System
c) Instruction Manipulating System
d) Information Management System
View Answer

Answer: d
Explanation: IMS stands for Information Management System. It is developed to manage large amounts of data for complex projects.

9. A model developed by Hammer and Mc Leod in 1981.
a) SDM
b) OODBM
c) DDM
d) RDM
View Answer

Answer: a
Explanation: SDM stands for Semantic Data Model. It models both data and their relationships in a single structure.
advertisement

10. Object=_________+relationships.
a) data
b) attributes
c) entity
d) constraints
View Answer

Answer: c
Explanation: The answer is entity. It is a part of OODBM (Object-Oriented Database Model). It maintains the advantages of ER-model but adds more features.

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.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.