8.2 Database Management Systems (DBMS) Cambridge iAS 9618

What is the main function of a Database Management System (DBMS)?

• To manage and organize data efficiently.

• To store files in a directory system.

• To delete redundant data automatically.

• To generate reports only.

Which of the following is a key feature of a DBMS?

• Data integrity enforcement.

• Automatic software updates.

• File compression.

• Only storing unstructured data.

How does a DBMS improve data security?

• By implementing access rights and encryption.

• By deleting old data records automatically.

• By preventing all users from modifying data.

• By removing primary keys from tables.

What is a major disadvantage of a file-based system compared to a DBMS?

• Data redundancy and inconsistency.

• Easier access control.

• Faster data retrieval.

• Better concurrency handling.

Which feature of a DBMS helps maintain data consistency and prevents errors?

• Data integrity controls.

• Data redundancy.

• Logical schema.

• File storage system.

What is a data dictionary in a DBMS?

• A collection of metadata describing the structure of the database.

• A user manual for database users.

• A backup of all database records.

• A software tool for managing indexes.

Which component of a DBMS defines how data is structured and stored?

• Logical schema.

• Query processor.

• Data dictionary.

• Report generator.

Which feature of a DBMS allows users to request and manipulate data?

• Query processor.

• Logical schema.

• Data integrity.

• File storage system.

Which software tool in a DBMS provides an environment for developers to create and modify databases?

• Developer interface.

• Query processor.

• Data dictionary.

• Backup system.

What is the purpose of the query processor in a DBMS?

• To interpret and execute database queries.

• To manage file storage.

• To remove redundant data.

• To create new databases automatically.