Computer Fundamentals Multiple choice Questions and Answers on DBMS for Freshers

1. A collection of related data.

a) Information
b) Valuable information
c) Database
d) Metadata

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

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

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.

4. Which of the following is not involved in DBMS?

a) End Users
b) Data
c) Application Request
d) HTML

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

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.

6. A characteristic of an entity.

a) Relation
b) Attribute
c) Parameter
d) Constraint

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

Answer: d

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

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

Answer: a

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

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.