Select the characteristics of a DBMS:It's cheaperProvides securityDoes not support multi-user accessProvides backup and recovery facilityRemoves redundancy
Question
Select the characteristics of a DBMS:
- It's cheaper
- Provides security
- Does not support multi-user access
- Provides backup and recovery facility
- Removes redundancy
Solution
The characteristics of a Database Management System (DBMS) are:
-
Provides Security: A DBMS provides a framework for better enforcement of data privacy and security policies.
-
Provides Backup and Recovery Facility: A DBMS contains important features like providing backup and recovery services. If a system crashes, a DBMS can recover the lost data.
-
Removes Redundancy: DBMS can avoid redundancy (i.e., duplication) of data, which means it can save storage and also ensures consistency of data.
However, the following are not characteristics of a DBMS:
-
It's Cheaper: This is not necessarily true. The cost of a DBMS can vary greatly depending on its complexity, functionality, and the licensing model.
-
Does Not Support Multi-User Access: This is incorrect. One of the main advantages of a DBMS is that it allows multiple users to access data simultaneously.
Similar Questions
Which of the following is not a feature of DBMS?Minimum Duplication and Redundancy of DataHigh Level of SecuritySingle-user Access onlySupport ACID Property
Which of the following is an advantage of a DBMS?minimal data redundancyEasy to accessHigh data securityall of the above
Which of the following is a function of the DBMS?Storing dataProviding multi-users access controlData IntegrityAll of the above
Which of the following is not the utility of DBMS?Choose one answer. Backup File organization Data Loading Process Organization
which one is not a database management system component?softwarehardwaredatausers
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.