Database Management Systems

Introduction

(DBMS) or database management is used for managing a particular database. This information can be easily modified, accessed, organised, controlled, and updated. The database management software also helps in encompassing the core facilities that are furnished for administering the database. The Database management system, database, and other associated applications can together be referred to by the term “Database system”.

Body

What is a database management system?

A DBMS or Database management system is a computer-based data-keeping system. The people who use the system are provided with several facilities for performing several operations on a system such as DBMS to manipulate data within the database or manage the structure of the database itself DBMSs are classified based on their data types and structures. Different types of databases can be utilised on a mainframe to exploit z/OS. These have been discussed in the following. 

Mainframe sites often utilise the hierarchical model when a particular data’s data structure is comparatively static. The Benefits of the relational and hierarchical database are quite common However it should be stated that RDBMS is non-navigational. This feature is absent in the case of the hierarchical database. The term ‘navigational’ mainly refers to the fact that the application must be aware of the database structure. The program needs to have some specific knowledge so that it can navigate to the segment of the desired child from the root segment which contains the needed elements or attributes. In this context, it should be mentioned that a program must also be able to access several intervening segments even though they might not be needed. 

Database management system examples

There are many popular examples of database management systems that are commonly utilised by programmers. Some of these have been outlined in the following. 

Microsoft Access: This is a database management system provided by Microsoft. It combines tools of software development, graphical user interface, and the Database Engine of Microsoft Jet. It is Included within the applications of the Microsoft Office suite and is mostly involved within its higher and professional edition. 

Oracle: This is a relational DBMS that was created by Oracle Corporation. Presently it supports several data models such as key-value, relational, and document. The system has been built around a framework of a relational database in which the objects of data can be accessed directly by different users. 

Microsoft SQL or MS SQL: It is an entirely commercial tool and the DBMS is a highly popular relational DBMS. It properly handles the management of relational data as well as effective storing to interact with the SQL server database.

MySQL: This is open-source which means that anyone can use as well as modify it free of cost. It is an RDBMS and includes a client-server framework. This connects to the server of RDBMS whenever data access is needed.

Database management systems MCQ

A database management system is an important topic concerning computer knowledge. Several database management system MCQs have been provided in the following.

1. Mention SQLs full form

1. Structured Query Language
2. Structured Question  Language
3. Simplified Query language
4. None

The correct answer is A) Structured Query Language

1. Mention DMLs full form

1. Structured Query Language
2. Data Manipulation Language
3. Dam Manipulating Language
4. None

The correct answer is b) Data Manipulation Language

1. Mention DMLs full form

1. Definition Data Language
2. Data Manipulation Language
3. Data  Definition Language
4. None

The correct answer is C. Data Definition Language

1. Point out the number of Abstraction levels within a Database

1. One 
2. Two 
3. Three 
4. Four
5. Five
6. Six

The correct answer is c) three

1. Which of the following cannot be classified as a variety of databases?

1. Network database 
2. Hierarchical Database 
3. Relational Database
4. None of the previous
5. All of a), b) and c)

The correct answer is e) All of a), b) and c)

Conclusion 

Throughout the article, the chief topic that has been discussed in the Database management system or DBMS. DBMS is essentially a computer-based data-keeping system that is mostly used by programmers for managing data structures. Under this chief topic, several subtopics have been discussed. These include what is database management systems, Database management system examples, and Database management systems MCQ. A proper discussion of these subtopics has helped in analysing every aspect of this topic.