Database management system important questions and answers pdf

1. What is DBMS? DBMS is a collection of programs that facilitates users to create and maintain a database.
In other words, DBMS provides us an interface or tool for performing different operations such as the creation of a database, inserting data into it, deleting data from it, updating the data, etc.

Basic DBMS concepts

Benefits of a DBMS

1. Improved data sharing and data security.
By providing quick solutions to database queries, a database management system enables faster access to more accurate data.
2. Effective data integration
3. Consistent, reliable data
4. Compliance with privacy regulations
5. Increased productivity
6. Better decision-making

How important is database management system?

A DBMS provides organizations a complete, clear view into the way data is shared, ensuring there aren't unnecessary copies of data.
Not to mention, A DBMS allows organizations to enforce data security and privacy policies to reduce the risk of a data breach..

What is most important in a database management system?

1.
Scalability.
One essential feature a business should look for is scalability.
The database should be able to handle the current and future needs of the business, including the ability to handle a large volume of data and a high number of concurrent users..