Search Header Logo

A-Level Comp Sci 9618 Databases

Authored by Mykhailo Shapkin

Computers

9th - 12th Grade

Used 22+ times

A-Level Comp Sci 9618 Databases
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a limitation of using a file-based approach for the storage and retrieval of data?

Lack of data integrity
Faster query processing
Scalability
Lower storage requirements

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which feature of a relational database addresses the limitations of a file-based approach?

Data redundancy
Data isolation
Data consistency
Increased storage requirements

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main purpose of an entity-relationship (E-R) diagram?

To document a database design
To create database tables
To normalize database tables
To manage database users

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which term refers to the process of organizing a database to minimize redundancy and improve data integrity?

Denormalization
Normalization
Optimization
Indexing

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does Third Normal Form (3NF) ensure in a database?

No non-key dependencies

No partial dependencies

No multivalued dependencies

No duplicate data

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of a primary key in a relational database?

To ensure data redundancy
To uniquely identify a record
To link tables in a many-to-many relationship
To store multiple values in a single field

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of a foreign key in a relational database?

To uniquely identify a record
To enforce data consistency
To link tables in a relationship
To store multiple values in a single field

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?