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
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
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
Explanation: DBMS manages the interaction between the end users and the database. End users are the final users that interact with the database.
4. Which of the following is not involved in DBMS?
a) End Users
b) Data
c) Application Request
d) HTML
View Answer
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
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.
6. A characteristic of an entity.
a) Relation
b) Attribute
c) Parameter
d) Constraint
View Answer
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
Explanation: Constraint is a restriction that is placed on the data. Attribute is the characteristic and the relation describes the association.
8. IMS stands for?
a) Information Mastering System
b) Instruction Management System
c) Instruction Manipulating System
d) Information Management System
View Answer
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
Explanation: SDM stands for Semantic Data Model. It models both data and their relationships in a single structure.
10. Object=_________+relationships.
a) data
b) attributes
c) entity
d) constraints
View Answer
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.
- Practice BCA MCQs
- Practice Information Technology MCQs
- Check Computer Fundamental Books
- Check BCA Books
- Apply for BCA Internship
