Database Management Quiz

What is the primary objective of the database approach in a centralized database system?

• To increase data redundancy

• To eliminate data backups

• To reduce data security

• To maintain data currency

How is data currency achieved in a centralized database environment?

• Through database lockout

• Through data replication

• Through data partitioning

• Through user-defined procedures

What is one advantage of partitioned databases in a distributed environment?

• Increased data redundancy

• Improved transaction processing response time

• Elimination of all data backups

• Reduced user control over data

What is the primary justification for using replicated databases?

• To support read-write transactions

• To support read-only queries

• To reduce data sharing

• To eliminate data backups

What is a deadlock in the context of distributed databases?

• A temporary inconsistency in data

• A software control to prevent data access

• A permanent condition requiring special software resolution

• A method to serialize transactions

Which factor is considered in resolving a deadlock?

• The number of users accessing the database

• The resources currently invested in the transaction

• The size of the database

• The type of database encryption used

What does database concurrency control aim to achieve?

• Data redundancy across all sites

• Increase data corruption

• Elimination of data backups

• Complete and accurate data at all user sites

What is the purpose of access controls in data management systems?

• To increase data redundancy

• To reduce data currency

• To eliminate data backups

• To prevent unauthorized access to data

What is the function of a user view (subschema) in access controls?

• To define the user’s data domain and provide access to the database

• To encrypt sensitive data

• To replicate the database across multiple sites

• To back up the database periodically

What is the purpose of data encryption in a database system?

• To make data readable to all users

• To protect highly sensitive stored data from unauthorized access

• To increase data redundancy

• To eliminate the need for backups