OCR GCSE Computer Science - Databases and SQL

A database is......

• A collection of files
• A persistent, organised store of data
• An unstructured collection of data
• A folder containing related files

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

• Tables
• Files
• File types
• Spreadsheets

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

• Entities
• Tables
• Records
• Fields

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

• Field
• Row
• Record
• Entity

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

• Field
• Record
• Column
• Entity

The SQL command to choose the data to be displayed in a query

• SELECT
• SHOW
• FROM
• WHERE

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

• SELECT
• WHERE
• FROM
• SHOW

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

• WHERE
• SELECT
• FROM
• WHEN

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

• Nothing

• All fields

• All rows

• All records containing *

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

• surname = "Khan"
• WHERE surname = "Khan"
• AND surname = "Khan"
• WHEN surname = "Khan"