COMPUTER FUNDAMENTALS

COMPUTER APPLICATIONS

DATABASE MANAGEMENT SYSTEMS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following is a function of the DBMS?
A
Storing data
B
Providing multi-users access control
C
Data integrity
D
All of the above
Explanation: 

Detailed explanation-1: -Which of the following is a function of the DBMS? Explanation: The purpose of creating DBMS was to store the data. The data stored in the database management system can be can accessed by multiple users if the access is provided. The data stored will be accurate and complete hence providing data integrity.

Detailed explanation-2: -Answer: A. Explanation: The DBMS (or Database Management System) is a kind of system software used for several operations such as creating tables/databases, storing data, managing databases. It also allows modifying the data stored in the database as well.

Detailed explanation-3: -The correct answer is “Compatibility with SQL". It stands for Data Base Management System. The DBMS is a “software system that enables users to define, create, maintain and control access to the database". Examples of DBMS include MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, Oracle Database, and Microsoft Access.

There is 1 question to complete.