Which of the following is not a feature of DBMS?a)Minimum Duplication ...
Feature of DBMS: Single-user Access only
One of the features of a DBMS (Database Management System) is that it allows for multiple users to access and manipulate the data stored in the database. However, it also provides the option to restrict access to a single user or a group of users.
Explanation:
1. Security:
By limiting access to a single user, the DBMS provides higher security to the data stored in the database. This is useful in cases where sensitive information is stored in the database, and only authorized personnel should be able to access it.
2. Control:
Single-user access also allows for better control over the database. This means that the DBA (Database Administrator) can have complete control over the database operations and ensure that there are no conflicting changes made by multiple users.
3. Performance:
Single-user access can also improve the performance of the database. Since there is no contention for resources, the database operations can be executed more efficiently and with less overhead.
4. Simplicity:
In some cases, a single-user access can also simplify the design and implementation of the database. For example, if the database is intended to be used by a single application, there may not be a need for complex security mechanisms and multi-user support.
Conclusion:
Overall, single-user access is a useful feature of a DBMS that provides improved security, control, performance, and simplicity in certain cases. However, it is important to note that in most cases, a DBMS is designed to support multiple users, and single-user access should be used only when necessary.
Which of the following is not a feature of DBMS?a)Minimum Duplication ...
The important features of a database management system are:
1) Minimum Duplication and Redundancy of Data
2) High Level of Security
3) Mulitple-user Access
4) Support ACID Property
To make sure you are not studying endlessly, EduRev has designed Computer Science Engineering (CSE) study material, with Structured Courses, Videos, & Test Series. Plus get personalized analysis, doubt solving and improvement plans to achieve a great score in Computer Science Engineering (CSE).