A2 Computing SQL

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

To join a table, connect the ___________ of one table to the ___________ of the other.

• primary key, foreign key
• group by clause, primary key
• filtered by, foreign key
• aggregate function, where clause

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"

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

• Aggregate functions
• Wildcard filters
• Subqueries
• Calculated field

Which word allows you to add more than one filter to a SQL query?

• AND
• BETWEEN
• LIKE
• EQUALS

Which query would return the fields Name and Form?

• SELECT Name, Set FROM Pupils

• SELECT Name, Group FROM Pupils

• SELECT Name, Form FROM Pupils

• SELECT Name, Gender FROM Pupils

What does integrity control consist of?

• Constraints
• Tables
• Cells
• None of the above

What does integrity control protect the database from?

• Inconsistency
• Duplication
• Corruption
• Deletion

What does the SQL DDL allow?

• objects to be created and destroyed
• objects to be removed
• objects to be modified