Quiz

Quiz: Relational Databases and SQL

OCR H446 Computer Science Specification

Ready to start this lesson?

Sign in to track your progress. 12 steps including 10 interactive questions.

Sign In to Start Learning
12 Steps10 Questions

Students also studied

Browse all

Steps in this lesson (12)

1
Text

Building on your knowledge of data handling, let's test your understanding of Relational Databases and SQL!

2
Multiple ChoiceInteractive

What is a relational database?

Start the lesson to answer this multiple choice question

3
Multi-SelectInteractive

Which of the following are characteristics of a relational database? (Select all that apply)

Start the lesson to answer this multi-select question

4
Fill in the BlankInteractive

A {{blank0}} is a unique identifier for a database record, while a {{blank1}} key is used to link records in different tables.

Start the lesson to answer this fill in the blank question

5
MatchingInteractive

Match the items on the left with their correct pairs on the right

Start the lesson to answer this matching question

6
Math EquationInteractive

A table contains 12 rows and 4 columns. How many cells are in the table?

Start the lesson to answer this math equation question

7
Multiple ChoiceInteractive

Which SQL keyword is used to remove a record from a table?

Start the lesson to answer this multiple choice question

8
Multi-SelectInteractive

Which of the following are common SQL data types? (Select all that apply)

Start the lesson to answer this multi-select question

9
Fill in the BlankInteractive

The {{blank0}} command is used to create a new table in SQL. The {{blank1}} command is used to modify the structure of an existing table.

Start the lesson to answer this fill in the blank question

10
MatchingInteractive

Match the items on the left with their correct pairs on the right

Start the lesson to answer this matching question

11
typedAnswer

Match the items on the left with their correct pairs on the right

12
Multiple ChoiceInteractive

What is a foreign key used for in a relational database?

Start the lesson to answer this multiple choice question

Want to Learn More?

Get personalised lessons, quizzes, and instant feedback from your AI tutor.

Explore More Topics