What are the advantages of DBMS over typical file processing system? Also define the functions of a DBA .[Answer Limit: 125 words, Marks : 08] [ UKPSC-2016]2016 ]
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Notifications
A Database Management System (DBMS) provides numerous benefits compared to regular file processing systems. It promotes data integrity and consistency by organizing data systematically, which minimizes duplication and enhances accuracy. The system allows multiple users to access and interact with the data at the same time without causing conflicts. Security is bolstered through user authentication and access controls. Additionally, data recovery and backup processes are streamlined, ensuring that information remains safe. The DBMS also supports data sharing and integration across various applications. A Database Administrator (DBA) is responsible for overseeing and maintaining the database system. Their roles encompass designing and setting up the database, safeguarding data security and integrity, optimizing system performance, and handling backup and recovery tasks. DBAs also keep an eye on system performance, resolve any issues that arise, and ensure adherence to data regulations.