2.4: Functions of a DBMS questions and answers with rated

2.4: Functions of a DBMS questions and answers with rated Functions of a DBMS Data storage, retrieval, and update; a user-accessible catalog; transaction support; recovery services; authorization services; support for data communication; integrity services; services to promote data independence; and utility services. Data Storage, Retrieval, and Update A DBMS must furnish the users with the ability to store, retrieve, and update data in the database. A User-accessible Catalog A DBMS must furnish a catalog in which descriptions of data items are stored and which is accessible to users. System Catalog A repository of information describing the data in the database. Also known as a data dictionary. Metadata Data about the data. Transaction Support A DBMS must furnish a mechanism that will ensure either that all the updates corresponding to a given transaction are made or that none of them were made. Inconsistency Happens when some changes have been made but related changes have not. Concurrency Control Services A DBMS must furnish a mechanism to ensure that the database updated correctly when multiple users are updating the database concurrently. Recovery Services A DBMS must furnish a mechanism for recovering the database in the event that the database is damaged in any way. Authorization Services A DBMS must furnish a mechanism to ensure that only authorized users can access the database. Support for Data Communication A DBMS must be capable of integrating with communication software. DCM Data Communication Manager Integrity Services A DBMS must furnish a means to ensure that both the data in the database and changes to the data follow certain rules. Services to Promote Data Independence A DBMS must include facilities to support the independence of programs from the actual structure of the database. Utility Services A DBMS should provide a set of utility services.