Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

DBMS definition and major components | RGPV PYQ

Photo of author

By Team EasyExamNotes

RGPV 2018
Define database management systems (DBMS). What are the major components of this system ? Explain each component.

Ans. A DBMS is used for storing, manipulating, and managing data.
Some examples of DBMSs: 
  1. MySQL, 
  2. Microsoft SQL Server, 
  3. Microsoft Access, 
  4. Oracle
In DBMS an organized collection of structured information, or data, typically stored electronically in a computer system is known as database.
The data and the DBMS, along with the applications that are associated with them, are referred to as a database system.
Some types of databases:
  1. Hierarchichal databases.
  2. Network databases.
  3. Object oriented databases.
  4. Relational databases.
  5. NoSQL databases.
Some components of DBMS:
  1. Software: DBMS software, operating systems, networking softwares etc.
  2. Hardware: Harddisk, RAM, I/O device, etc.
  3. Data: Values stored in DBMS.
  4. Data dictionary: it stores information about data.
  5. Database administrator: The admin in DBMS.
  6. Database access languages: DDL, DML, DCL, TCL, etc.

Download as PDF

Related posts:

  1. Database approach v/s Traditional file accessing approach | RGPV
  2. RGPV DBMS Explain the concepts of generalization and aggregation with appropriate examples
  3. RGPV solved Database approach vs Traditional file accessing approach
  4. Concept of primary, foreign key, integrity constraints | RGPV DBMS PYQ
  5. Data modelling, compare Data models | RGPV DBMS PYQ
  6. Consider the following employee database
  7. Explain select, project and division operations with examples.
  8. Explain the concepts of Generalization and Aggregation with appropriate examples.