Answer to Question #219050 in Databases | SQL | Oracle | MS Access for stan

Question

 Database Management Systems (DBMS) is perceived by database architects like you to guarantee the integrity and consistency of the data in the database. Discuss any four (4) functions of the DBMS that ensures the above perception.

Answer 1

The functions of DBMS include:

1. Data storage management: DBMS is used to store data.
2. Security management: It sets rules to determine users who are allowed to access the database.
3. Multiuser Access Control: It enables the multiple users to access the databases simultaneously without affecting the integrity of the database.
4. Backup and Recovery Management: The DBMS is responsible for managing backup and recovery in the database.