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:

DBMS

Tagged in:

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

Share Article:

Leave a Reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO