DBMS Questions and Answers

Computer Fundamentals Questions and Answers – DBMS

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

1. A characteristic of an entity.
a) Relation
b) Attribute
c) Parameter
d) Constraint

Explanation: An entity’s attribute is one of its characteristics. The relationship describes the connection between the entities.

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

Explanation: A data constraint is a restriction imposed on the data. The characteristic is the attribute, and the relationship is the association.

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

Explanation: Information Management System (IMS) is a term that refers to a system that manages data. It was created to handle massive amounts of data in the context of complex tasks.

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

Explanation: Semantic Data Model (SDM) is an acronym for Semantic Data Model. In a single structure, it models both data and relationships.

5. Object=_________+relationships.
a) data
b) attributes
c) entity
d) constraints

Explanation: Entity is the answer. It’s a component of OODBM (Object-Oriented Database Model). It keeps the benefits of the ER-model but adds new functions.

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

Explanation: A database is a logically organised collection of connected material and associated metadata. It’s made to help you manage your data more effectively.

7. DBMS is software.
a) True
b) False

Explanation: The assertion is correct. The term DBMS refers to a database management system. It makes database construction and access simple.

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

Explanation: The database management system (DBMS) controls the interaction between end users and the database. The final users who interact with the database are known as end users.

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

Explanation: Database Management Systems do not use HTML. The DBMS also includes things like data and application requests.

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

Explanation: The database is designed with the user in mind. The user is always correct, according to this viewpoint. If there is an issue with the system’s use, it is the system’s fault, not the user’s.

A database management system (DBMS) is a piece of software that allows you to arrange data in a database. The abbreviation DBMS is commonly used to refer to it. Concurrency, security, backup and recovery, integrity, and data descriptions are all features of a database management system. A database management system (DBMS) is software that stores and retrieves data for users while taking proper security precautions. A database management system (DBMS) aids users and other third-party applications in storing and retrieving data in huge systems. Users can design their own databases using a database management system (DBMS). The database is designed with the user in mind. The user is always correct, according to this viewpoint.

Leave a Reply

Your email address will not be published. Required fields are marked *