Characteristics of DBMS ?

    • A) non-redundant
    • B) data independence
    • C) increased security
    D) all the above

Answer : D) all the above

What is DBMS ?

  • A database management system (DBMS) is a software package designed to define manipulate, retrieve and manage data in a database.
  • A DBMS mostly manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data.
  • A DBMS relieves users of framing programs for data maintenance. Fourth-generation query languages, such as SQL, are used along with the DBMS package to interact with a database.
  • Some other DBMS examples include:
    • MySQL
    • SQL Server
    • Oracle
    • dBASE
    • FoxPro
Characterstics of DBMS
  • Data abstraction and independence.
  • Data security.
  • A locking mechanism for concurrent access.
  • An efficient handler to balance the needs of multiple applications using the same data.
  • The ability to swiftly recover from crashes and errors, including restartability and recoverability.
  • Robust data integrity capabilities.
  • Logging and auditing of activity.
  • Simple access using a standard application programming interface (API).
  • Uniform administration procedures for data.
Characteristics of DBMS

Characteristics of DBMS

Advandages of DBMS

  • One of the most advantages of using a DBMS is that it lets end users and application programmers access and use the same data while managing data integrity.
  • Data is better protected and maintained when it can be shared using a DBMS instead of creating new iterations of the same data stored in new files for every new application.

Categorized in:

Tagged in:

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,