Y10 - SQL Python Quiz

A primary key is...

• A field that uniquely identifies a record in a table

• A record that uniquely identifies a field in a table

• A field that links to another table

• The most important field in the database

A table in a database can be described as...

• A complete set of records on a range of different topics

• A complete set of primary keys

• A complete set of records on the same topic

• A nice place to sit and eat your dinner

A field in a database can be described as...

• A single type of data from a database

• A record in a table

• A collection of tables in a database

• A nice place to play football

A foreign key in a database can be described as...

• A linking field from another database

• A field that uses a different programming language

• A field that can not communicate with the rest of the database

• A linking field from another table

Data redundancy in a database can be described as...

Which SQL statement will select all from the world table where name equals France?

• SELECT France FROM world WHERE name = France

• SELECT ALL FROM world WHERE name = France

• SELECT * FROM world WHERE name = France

• SELECT * FROM world where name == France

Which line of code does not contain an error?

• INSERT INTO students VALUES 47, 'James', 'Moff',14, 'Male', '9R')

• INSERT INTO students VALUES(47, 'James', 'Moff',14, 'Male', '9R')

• INSERT INTO students VALUES(47 'James' 'Moff' 14 'Male' '9R')

• INSERT students VALUES(47, 'James', 'Moff',14, 'Male', '9R')

Fix this line of code:

INSERT INTO students VALUES 47, 'James', 'Moff',14, 'Male', '9R'

Which of the below SQL statements will delete all students who are over 21 years of age?

• DELETE FROM students WHERE age < 21

• DELETE FROM students WHERE age <= 21

• DELETE FROM students WHERE age > 21

• DELETE FROM students WHERE age >= 21

What is the purpose of the WHERE clause in an SQL statement?

• To filter records based on a condition

• To sort the results

• To create a new table

• To specify the columns to be displayed