ONE 6th FORM - Understanding Databases and Security

What is the primary purpose of database design principles?

• To ensure data is stored in a single table

• To organise data efficiently and reduce redundancy

• To increase the complexity of data retrieval

• To make databases visually appealing

Which of the following is a key step in data normalisation?

• Combining multiple tables into one

• Eliminating duplicate data

• Adding redundant data for safety

• Creating a single table for all data

What does an Entity-Relationship Diagram (ERD) primarily represent?

• The physical layout of a database

• The relationships between tables and entities

• The user interface of a database system

• The security protocols of a database

Which of the following is a common feature of Database Management Systems (DBMS)?

• Manual data entry

• Automated data backup

• Physical data storage

• Data encryption only

What is the main goal of data security measures in databases?

• To increase data redundancy

• To protect data from unauthorised access

• To simplify data retrieval

• To enhance data visualisation

Which normal form requires that all non-key attributes are fully functional dependent on the primary key?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Boyce-Codd Normal Form (BCNF)

In an ERD, what does a diamond shape typically represent?

• An entity

• An attribute

• A relationship

• A primary key

Which of the following is NOT a type of Database Management System?

• Relational DBMS

• Hierarchical DBMS

• Network DBMS

• Linear DBMS

What is a common method for ensuring data security in databases?

• Data duplication

• Data encryption

• Data normalisation

• Data visualisation

Which of the following is a benefit of using a relational database?

• Increased data redundancy

• Simplified data retrieval through SQL

• Limited data access

• Complex data storage