A Level Computing - Normalisation & SQL

Which of the following is NOT a requirement of 1NF?

• It should only have single (atomic) valued attributes/columns.

• a Primary Key

• One item of data per column in one row (i.e. no repeating data)

• Data should be sorted in order

Which of the following is NOT a requirement of 2NF?

• No One-Many relationships

• The data should be in 1NF

• No partial dependencies

• No One-Many relationships

Which of the following is NOT a requirement of 3NF?

• The data should be in 2NF

• No non-key fields depend on other non-key fields

• All non-key fields only depend on the Primary Key

• There are no one-many relationships between tables

In the context of database normalisation, what does "data integrity" mean?

• The database occupies less memory and is faster to search

• There is no possibility of duplicated data anywhere in the database

• The data is safe from hacking and illegal access

• It is easier to edit databases tables and data

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

• FROM
• WHERE
• SELECT
• ORDER BY

What is the purpose of  *?

• Selects ALL fields from the table
• Selects only the first field in the table
• Selects the last field in the table
• Shows only the first row in the table

Return the name and genre of each movie with an imdb_rating greater than 5 and year greater than 2012.

• SELECT * FROM movies WHERE imdb_rating > 5 AND year > 2012;
• SELECT name, genre FROM movies WHERE imdb_rating < 5 AND year < 2012;
• SELECT name, year FROM movies WHERE imdb_rating > 5 year > 2012;
• SELECT name, genre FROM movies WHERE imdb_rating > 5 AND year > 2012;

Write the code for the following : Return all movies with the word love.

• SELECT * FROM movies WHERE name LIKE %love%;
• SELECT * FROM movies WHERE name LIKE ‘love’;
• SELECT * FROM movies WHERE name LIKE %love;
• SELECT * FROM movies WHERE name LIKE ‘%love%’;

What criteria would you use in the field City to find people who lived in Manchester and London

• =london OR manchester

• =London AND Manchester

Which would find Pupils whose name begins in C from Haddon forms?

• SELECT * FROM Pupils Where Name LIKE "C%" AND House = Haddon

• SELECT * FROM Pupils Where Name = "C%" AND House = Haddon

• SELECT * FROM Pupils Where Name = "C" AND House = Haddon

• SELECT * FROM Pupils Where Name LIKE "C" AND House = Haddon