Test: Database Management System - 1 - Bank Exams MCQ

The database management system was developed to store enormous amounts of data, which can take any form, including images, text, audio files, and video files.

The Integrated Data Store (IDS), which was based on a network data model, was created by Charles Bachman first, for which he was given the Turing Award (The most prestigious award which is equivalent to the Nobel prize in the field of Computer Science.). It was created at the start of the 1960s.

The information is kept in a table structure that is designed to control data storage and alter data to provide information.

Some DBMS examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro.

It provides several key features:

• It stores data in one central location.
• It allows data to be shared by many users.
• It provides user interfaces to work with the data.
• It creates backups.
• It controls who can access and edit the data.

There are the following types of databases available in the market 

• Centralized database.
• Distributed database.
• Personal database.
• End-user database.
• Commercial database.
• NoSQL database.
• Operational database.
• Relational database.
• Cloud database.
• Object-oriented database.
• Graph database.

Hardware, Software, Data, Database Access Language, Procedures, and Users all together form the components of a DBMS.

The Database Management System performs the following functions:

• Data Dictionary Management
• Data Storage Management
• Data Transformation and Presentation
• Security Management
• Multi-User Access Control
• Backup and Recovery Management
• Data Integrity Management