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...

    Content View

    Student View

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

Already have an account?