1.

Features of DBMS software

Answer» \tMinimum repetition and redundancy: In a database there are high chances of data duplication due to the presence of many users. DBMS resolves this issue by building a repository where all the data are stored and can be accessed by multiple users.\tDatabases of big corporations or companies can only be managed by a database management system. Database management system offers data protection and features like recovery and backup for easy recording and retrieval of data.\tEnhanced security: Database management systems offer enhanced security by restricting public access. It can only be accessed by a database administrator or the concerned head of the department.\tMultiple user access: Database is designed in such a way that it can be accessed by multiple users who can work on different sections of the databases at a time without interrupting the flow of work.\tProvides multiple views of the data: Database management system allows the users to access multiple views of the data present in the database. For e.g an HR personnel can check the database for processing the data of the employee, while at the same time an employee can use the database to access resources related to payslip, attendance, etc.\tPermanent storage of data: Data stored in a database will remain stored permanently until and unless it is deleted from the system manually. Even in cases of accidental deletion of data, the database system has a robust recovery system which allows recovery of deleted data.


Discussion

No Comment Found

Related InterviewSolutions