OCR Computer Science A Level Database concepts

OCR Computer Science A Level Database concepts

12th Grade

15 Qs

quiz-placeholder

Similar activities

Database Glossary

Database Glossary

12th Grade

20 Qs

1.3.1 Databases & SQL

1.3.1 Databases & SQL

12th Grade

20 Qs

SLR23 | Databases

SLR23 | Databases

12th Grade

20 Qs

SQL

SQL

10th - 12th Grade

11 Qs

Databases and Normalisation

Databases and Normalisation

12th Grade

20 Qs

SQLDatabase

SQLDatabase

12th Grade

15 Qs

MySQL revision tour

MySQL revision tour

11th - 12th Grade

10 Qs

SQL Database

SQL Database

12th Grade

20 Qs

OCR Computer Science A Level Database concepts

OCR Computer Science A Level Database concepts

Assessment

Quiz

Computers

12th Grade

Medium

Created by

Ana Bracher

Used 1+ times

FREE Resource

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the unique identifier for each object added to the database?

Attribute1

DoctorID

DirectorName

MovieTitle

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of database consists of a single file?

Indexing

Relational Database

Flat File

Entity Relationship Modelling

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the process of coming up with the best possible design for a relational database called?

Normalisation

Indexing

Referential Integrity

Record Locking

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which method is used to store the position of each record when ordered by a certain attribute?

Primary Key

Secondary Key

Foreign Key

Indexing

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the process of preventing simultaneous access of records in a database called?

Redundancy

Transaction Processing

Referential Integrity

Record Locking

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement is used to collect fields from a given table?

ADD

SELECT

UPDATE

DELETE

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the process of ensuring consistency in a database called?

Atomicity

Consistency

Durability

Isolation

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?