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
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.