A Level Computing Databases #1

What is a database?

• A complex algorithm for data processing

• An organized collection of data

• A type of computer hardware

• A programming language

What is the primary key in a database?

• A tool to encrypt data

• A password to access the database

• A unique identifier for each record

• A key that opens the database

What type of relationship is described as one-to-many?

• One tutor group contains many students

• One tutor group belongs to one student

• One student belongs to many tutor groups

• Many students belong to one student

What is normalization in the context of databases?

• Backing up data regularly

• Adjusting the database size

• Reducing data redundancy

• Encrypting sensitive information

What is a foreign key?

• A key from another database

• A primary key in another table

• A unique identifier used in foreign databases

• A backup key for emergency use

What is the purpose of indexing in a database?

• To increase the database size

• To make the database look organized

• To secure the database

• To make data retrieval quicker

What is a flat file database?

• A 3D model of a database

• A database stored on flat storage devices

• A database that cannot contain tables

• A database with only one table

What does 'entity relationship modeling' help with?

• Modeling the user interface of the database application

• Calculating the storage space needed for the database

• Sketching out the relationships between tables

• Designing the physical appearance of the database

What is a secondary key?

• A duplicate of the foreign key

• A field indexed for search purposes

• A key used for secondary databases

• A backup primary key

Why might a many-to-many relationship be considered poor database design?

• It is too complex to understand

• It makes the database too fast

• It can lead to data redundancy

• It is not supported by most databases