Skip to content
Exercises · Q2

Q.What is a DBMS? State any four functions performed by a DBMS.

Maharashtra MsbshseTextbookSubjectiveImportance★★★★★est
15% · 2/13 Questions
✓ Free question

A Database Management System (DBMS) is software that enables users to create, store, organise, retrieve, update and manage the data in a database. It acts as the interface between the user (or an application program) and the actual data stored on disk, handling all the low-level details so the user only has to say what they want.

Four functions performed by a DBMS (any four):

  1. Data definition — defining the structure of the data: the tables, their columns, and the data type of each column.
  2. Data storage and retrieval — storing data on disk and fetching exactly the records the user asks for.
  3. Data manipulation — inserting new data, updating existing data and deleting unwanted data.
  4. Data security — controlling who may see or change which data through user accounts, passwords and permissions. (Other valid functions: data integrity — enforcing validity rules so only correct data is stored; backup and recovery; and concurrent access control — letting many users work at once without conflict.)
    ✓Final answer

    A DBMS is software that lets users create, store, retrieve, update, secure and manage the data in a database. Four functions: data definition, data storage and retrieval, data manipulation, and data security (also data integrity, backup/recovery, concurrency control).

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.