Cs3492 database management systems question bank

What is the use of database management system in banking?
Answer: A distributed database management system makes sure that each bank branch has its own copy of the most up-to-date customer information.
Instead of sending the information to a central server, the bank copies the information about the customer's account..

How does a DBMS enforce data integrity constraints?

If data is always accessed through the DBMS, the DBMS can enforc e integrity constraints on the data

For example, before inserting salary information for an employ ee, the DBMS can check that thedepartment budget is not exceeded

Also, the DBMS can enforce access controlsthat govern what datais visible to different classes of users

What are the advantages of using a DBMS over a file system?

ADVANTAGES OF A DBMS OVER FILE SYSTEM: Using a DBMS to manage data has many advantages: Data Independence: Application programs should be as independent as possible from details of datarepresentation and storage

The DBMS can provide an abstract view of the data to insulateapplication code from such details

Efficient Data Access:

Categories

Cs3492 database management systems question bank

What is the use of database management system in banking?

How does a DBMS enforce data integrity constraints?

What are the advantages of using a DBMS over a file system?