FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WHAT IS DATABASE MANAGEMENT

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What are the DBMS Functions?
A
Data dictionary management
B
Data transformation and presentation
C
Security management
D
Data storage management
Explanation: 

Detailed explanation-1: -Database Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data. A DBMS serves as an interface between an end-user and a database, allowing users to create, read, update, and delete data in the database.

Detailed explanation-2: -Answer: d 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-3: -A DBMS must store data persistently in files or datasets of some sort. Depending on the DBMS, table spaces and index spaces each may require one, or possibly more, files to store the actual data. Some DBMS products combine multiple table spaces into a single O/S file.

Detailed explanation-4: -A data store is a repository for persistently storing and managing collections of data which include not just repositories like databases, but also simpler store types such as simple files, emails, etc. A database is a series of bytes that is managed by a database management system (DBMS).

There is 1 question to complete.