Graded quiz refining your results

 

Graded quiz refining your results

Question 1

You want to select author's last name from a table, but you only remember the author’s last name starts with the letter B, which string pattern can you use? 

SELECT lastname from author where lastname like ‘B#’ 

SELECT lastname from author where lastname like ‘B%’ 

SELECT lastname from author where lastname like ‘B$’ 

None of the above 

Question 2

In a SELECT statement, which SQL clause controls how the result set is displayed? 

ORDER BY clause 

ORDER IN clause 

ORDER WITH clause 

Question 3

Which of the following can be used in a SELECT statement to restrict a result set? 

HAVING 

WHERE

DISTINCT 

All of the above