What are the Advantages and Disadvantages of DBMS - Anna University Multiple Choice Questions

What are the Advantages and Disadvantages of DBMS

Define Data Base Management System or What is meant by DBMS ?

  • The collection of interrelated data's and the set of programs to access those data's are called as  Database management system.
  • or
  • The DBMS or database system consist of a collection of interrelated & persistent data and a set of application programs used to access,update and manage those data's. 
  • The collection of data is called as data base.Databases are usually designed to store & manage large amount of informations or data's.
  • The goal of DBMS is to provide an environment for both retrieving information from the data base and storing information into the database.
Advantages of  DBMS | Data Base Management System
  • Control of data redundancy
  • Data consistency
  • Sharing of data
  • Improved data integrity
  • Improved security
  • Enforcement of standards
  • Economy of scale
  • Improved data accessibility and responsiveness
  • Increased productivity
  • Increased concurrency
  • Improved backup and recovery services
These are some of the advantages of database management system or database system.

Disadvantages of  DBMS | Data Base Management System :
  • Complexity
  • Size
  • Cost of dbms is high
  • Additional hardware costs
  • Performance
  • Higher impact of failure
These are some of the disadvantages of database management system or database system.

Disadvantages of file system over DBMS :
  • Data redundancy and inconsistency
  • Difficulty in accessing data
  • Data isolation
  • Integrity Problems
  • Atomicity Problems
  • Concurrent - access anomalies
  • Security Problems 
These are some of the disadvantages of file system over database management system or database system.
--------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment