Advantages of DBMS

Question 1

This is prevented in a database as there is a single database and any change in it is reflected immediately. Because of this, there is no chance of encountering duplicate data.

Answer 1

Reducing Data Redundancy

Question 2

In a database, the users of the database can share the data among themselves.

Answer 2

Sharing of Data

Question 3

It means that the data is accurate and consistent in the database.

Answer 3

Data Integrity

Question 4

It is vital concept in a database wherein only authorized users should be allowed to access the database and their identity should be authenticated using a username and password.

Answer 4

Data Security

Question 5

In a database means only the authorized users can access a database according to its privacy constraints.

Answer 5

Privacy

Question 6

The users don’t need to backup data periodically because this is taken care of by the DBMS. Moreover, it also restores the database after a crash or system failure to its previous condition.

Answer 6

Backup and Recovery

Question 7

All data appears consistently across the database and the data is same for all the users viewing the database.

Answer 7

Data Consistency

Question 8

Advantages of DBMS

Answer 8

Reducing Data Redundancy
Sharing of Data
Data Integrity
Data Security
Privacy
Backup and Recovery
Data Consistency