Question

The main function of a DBMS is to provide the users with efficient and _______methods of data retrieval.


1)Reliable
2)unreliable​

Answer 1

Explanation:

Purpose of Database Management Systems

Organizations use large amounts of data. A database management system (DBMS) is a software tool that makes it possible to organize data in a database.

The standard acronym for database management system is DBMS, so you will often see this instead of the full name. The ultimate purpose of a database management system is to store and transform data into information to support making decisions.

A DBMS consists of the following three elements:

The physical database: the collection of files that contain the data

The database engine: the software that makes it possible to access and modify the contents of the database

The database scheme: the specification of the logical structure of the data stored in the database

While it sounds logical to have a DBMS in place, it is worth thinking for a moment about the alternative. What would the data in an organization look like without a DBMS? Consider yourself as the organization for a moment, and the data are all the files on your computer. How is your data organized? If you are like most typical computer users, you have a large number of files, organized in folders.

You may have word processor documents, presentation files, spreadsheets, photographs, etc. You find the information you need based on the folder structure you have created and the names you have given to your files. This is called a file system and is typical for individual computer users.

Now consider the challenges you are faced with. Have you ever lost a file? Have you had difficulty finding a file? Probably. Perhaps you are using multiple computers and your files are located in different physical locations. And, when was the list time you created a backup of all your files? You do back up, right?

You probably get the picture. A file system is relatively simple, but it only works if you keep yourself very organized and disciplined. Now consider an organization with 1,000 employees, each with their own computer. Can you see some of the challenges when using a file system? Do you really want critical financial data floating around the offices as simple files on individual computers?

Functions of a DBMS

So, what does a DBMS really do? It organizes your files to give you more control over your data.

A DBMS makes it possible for users to create, edit and update data in database files. Once created, the DBMS makes it possible to store and retrieve data from those database files.

More specifically, a DBMS provides the following functions:

Concurrency: concurrent access (meaning 'at the same time') to the same database by multiple users

Security: security rules to determine access rights of users

Backup and recovery: processes to back-up the data regularly and recover data if a problem occurs

Integrity: database structure and rules improve the integrity of the data

Data descriptions: a data dictionary provides a description of the data

Within an organization, the development of the database is typically controlled by database administrators (DBAs) and other specialists. This ensures the database structure is efficient and reliable.

Database administrators also control access and security aspects. For example, different people within an organization use databases in different ways. Some employees may simply want to view the data and perform basic analysis. Other employees are actively involved in adding data to the database or updating existing data. This means that the database administrator needs to set the user permissions. You don't want someone who only needs to view the database to accidentally delete parts of the database

Answer 2

Answer:

The main purpose of a DBMS is to provide the users with efficient as well as reliable methods of data retrieval.

Therefore, the option (1) is correct.

Explanation:

A DBMS or database management system is a software which is used to organize data in a database.

• The main function of database management system (DBMS) is to store data  and then transform data into information to use making decisions.
• DBMS makes possible to store and retrieve data from database files.
• The three elements of DBMS:-

1. Physical database: It is the collection of data files.
2. Database engine: It is the software that is used to access and improve the contents of the database.
3. Database schema:  It is the description of the logical structure of the data, which is stored in the database.

Some other functions of DBMS:-

• It provides concurrent access to the same database by multiple users.
• It provides the security rules to know the access rights of users.
• It makes possible to back-up the data regularly and if a problem occurs then recover data.
• Database structure and rules modify the integrity of the data.
• A data dictionary (data description) provides a description of the data.

To know more about "DBMS and its types"

https://brainly.in/question/21091548

To know more about "Advantages and disadvantages DBMS"

https://brainly.in/question/6839458