DBMS

Question 1

What is the role of the DBMS?

Answer 1

It’s a software that is responsible for managing the interaction and access to the database.

Question 2

What are the 7 advantages of the DBMS?

Answer 2

• Maintainable
• Little to no data duplication
• Scalable
• Isolated data storage
• Unified DML
• Concurrent accessibility
• Improved security

Question 3

What are the 10 functions of the DBMS?

Answer 3

• Storage, update, access
• Concurrent usage
• System catalogue
• Recovery procedures
• Transaction support
• Integrity
• Authorisation
• Communication
  -Data independence
• Utility services

Question 4

What are some disadvantages of the DBMS?

Answer 4

• Complex software
• Large software
• May run slower due to being programmed for generic use
• DBMS centralisation means if failure occurs it has a larger impact