Higher Databases and SQL

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 only the customers who have ER anywhere in their last name. 

• last_name LIKE "%er%"
• last_name = "%er"
• last_name = "%er%"
• last_name LIKE "%er"

Which clause allows you to SORT data?

• ORDER BY

• WHERE

• FROM

• GROUP BY

AVG, COUNT, MAX, MIN and SUM are known as what?

• Aggregate functions
• Wildcard filters
• Subqueries
• Calculated field

What is the correct order of clauses? 

• SELECT, FROM, ORDER BY, WHERE
• SELECT, FROM, WHERE, ORDER BY
• SELECT, WHERE, FROM, ORDER BY
• WHERE, FROM, SELECT, ORDER BY

Which SQL statement is used to insert new data in a database?

•  ADD NEW
•  ADD RECORD
•  INSERT NEW
•  INSERT INTO

Which SQL statement is used to update data in a database?

• MODIFY
•  SAVE AS
• UPDATE
• SAVE

Write a code for the following: Return all romances that have an imdb_rating over 6.

• SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating > 6;
• SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating < 6;
• SELECT imdb_rating, name FROM movie WHERE genre = ‘romance’ AND imdb_rating > 6;
• SELECT * FROM movies WHERE genre = romance and imdb_rating < 6;

To find the total dollar value of sales, which aggregate function should be used?

• SUM

• COUNT

• MAX

• MIN

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