Computer Fundamentals Multiple Choice Questions on “DBMS”.
1. A collection of related data.
a) Information
b) Valuable information
c) Database
d) Metadata
Answer: c
Clarification: 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
Answer: a
Clarification: 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
Answer: c
Clarification: 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
Answer: d
Clarification: 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
Answer: b
Clarification: 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
Answer: b
Clarification: 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
Answer: d
Clarification: 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
Answer: d
Clarification: 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
Answer: a
Clarification: 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
Answer: c
Clarification: 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.