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?

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

Which SELECT statement eliminates duplicates in the result set?

What is the default sorting mode of the ORDER BY clause?

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