DBMS MCQ Question :
1. A database management system (DBMS) is a________
(a) Hardware system used to create, maintain and provide controlled access to a database
(b) Hardware system used to create, maintain and provide uncontrolled access to a database
(c) Software systems used to create, maintain, and provide uncontrolled access to a database
(d) Software systems used to create, maintain, and provide controlled access to a database
(e) All of the Above
2. Database management system (DBMS) is a___________
(a) DBMS is a collection of queries
(b) DBMS is a high-level language
(c) DBMS is a programming language
(d) DBMS stores, modifies, and retrieves data
(e) None of the above
3. A Database Management System (DBMS) is_____________
(a) collection of data describing one particular enterprise
(b) collection of programs to access data
(c) collection of interrelated data
(d) All of the above
What is Database Management System (DBMS) :
DBMS is a Database Management System. The name suggests that it manages the entire database. Database management systems do everything from creating, handling, and deleting data. It is software that can create, manage, control, delete and update data. With DBMS, both the user and the programmer can handle their data i.e. both can create, manage and update the data.
A database is a collection of related data. There is data collection of facts and figures which are processed to generate information. This database management system stores data in a way that makes it easy to retrieve, manipulate, and produce information.
Types of Database Management System
1. Network Database: In such a database the data is represented as a record and the link between the data is represented.
2. Relational Database: It stores data in the form of tables. Where data is stored in Columns and Rows. It is also known as a structural database.
3. Hierarchical Database: In it, the data is represented as Parent and Child which are in the tree structure.
What is the Function of a Database Management System?
- Create Data: Data is created by DBMS i.e. it is stored in the table.
- Manage Data: It manages the data so that it can be easily accessed.
- Update Data: It can update the data as required.
- Delete Data: Data that is not needed in it is deleted.
- Data Backup: It backs up the data so that it can be recovered in case of system failure.
- Data Recovery: In this, data is recovered in case of system failure.
Disadvantages of Database Management System (DBMS) :
1. Cost Of Implementation: The cost of implementing a database system can be high and costly.
2. Effort To Transfer Data: Transferring a database to an existing system can be very difficult and can take a long time.
3. There is a risk of Database Failure: If the data spreads even for a short period, it will affect the company and the company may incur various losses.