OCR GCSE Computer Science - Databases and SQL

Front

What is a database?

Back

A persistent, organised store of data

Front

Databases are made up of one or more ......

Back

Tables

Front

Database tables store data about real world things called...

Back

Entities

Front

A column in a database table is called a ......

Back

Field

Front

A row in a database table is called a ......

Back

Record

Front

The SQL command to choose the data to be displayed in a query: SELECT, SHOW, FROM, WHERE

Back

SELECT

Front

The SQL command to choose which tables the data for the query will be taken from

Back

FROM

Front

The SQL command which sets conditions for the rows or columns to be shown in the query output

Back

WHERE

Front

What does * mean in the following query: SELECT * FROM Customers

Back

All fields

Front

Complete the SQL query to find all records for surname = "Khan": SELECT * FROM Customers ......

Back

WHERE surname = "Khan"