Understanding DBMS: Pros and Cons

What is a primary advantage of using a DBMS?

• Increased data duplication

• Faster data retrieval

• Simplified data storage

• Data integrity and reduced redundancy.

How does a DBMS improve data integrity?

• A DBMS enhances data integrity by enforcing validation rules and maintaining consistency through constraints and transaction management.

• A DBMS enhances data integrity by allowing unrestricted data entry.

• A DBMS improves data integrity by eliminating the need for backups.

• A DBMS improves data integrity by storing data in multiple locations.

What is one major disadvantage of a DBMS?

• Easy integration with existing systems.

• Faster data retrieval than traditional methods.

• High cost of implementation and maintenance.

• Improved data security compared to flat files.

In what way does a DBMS enhance data security?

• By storing data in plain text format

• By allowing unlimited access to all users

• By automatically deleting old data without permission

• A DBMS enhances data security through user authentication, access controls, encryption, and auditing.

What objective does a DBMS serve in data management?

• To restrict user access to all data records.

• To eliminate the need for data backups.

• To enhance data visualization and reporting.

• To efficiently manage data storage, retrieval, and integrity.

How can a DBMS reduce data redundancy?

• By increasing the number of tables in the database.

• By using unstructured data formats.

• By normalizing data and establishing relationships between tables.

• By duplicating data across multiple databases.

What is a potential drawback regarding the cost of a DBMS?

• Minimal training requirements.

• Free software availability.

• High initial and ongoing costs.

• Low maintenance costs.

How does a DBMS facilitate data sharing among users?

• A DBMS only allows one user to access data at a time.

• A DBMS allows multiple users to share and access data concurrently while ensuring data integrity and security.

• A DBMS requires users to manually copy data for sharing.

• A DBMS prevents any data sharing to maintain security.

What is one objective of implementing a DBMS in an organization?

• To eliminate the need for data backup.

• To increase data redundancy and duplication.

• To manage data efficiently and ensure data integrity.

• To limit access to data for all users.

How can a DBMS impact system performance negatively?

• A DBMS can lead to slower query response times and increased resource usage.

• A DBMS can improve query response times significantly.

• A DBMS has no effect on resource usage.

• A DBMS always enhances system performance.