Quiz

Quiz: SQL Basics - SELECT, WHERE, ORDER BY and Aggregates

OCR H446 Computer Science Specification

11 Steps9 Questions

Students also studied

Text

Welcome! Building on your knowledge of databases and SQL, let's focus on testing your understanding of SELECT, WHERE, ORDER BY, and aggregates.

Multiple ChoiceInteractive

Which SQL keyword is used to specify the columns to retrieve from a table?

Start the lesson to answer this multiple choice question

Multi-SelectInteractive

Which of the following are valid SQL aggregate functions? (Select all that apply)

Start the lesson to answer this multi-select question

Fill in the BlankInteractive

To filter rows in an SQL query, you use the {{blank0}} clause.

Start the lesson to answer this fill in the blank question

MatchingInteractive

Match the items on the left with their correct pairs on the right

Start the lesson to answer this matching question

Math EquationInteractive

What is the result of COUNT(*) if a table has 15 rows?

Start the lesson to answer this math equation question

Code CompletionInteractive

Match the items on the left with their correct pairs on the right

Start the lesson to answer this code completion question

typedAnswer

Match the items on the left with their correct pairs on the right

Multiple ChoiceInteractive

Which clause is used to group rows when applying aggregate functions?

Start the lesson to answer this multiple choice question

Multi-SelectInteractive

Which of the following SQL statements will retrieve rows where 'age' is greater than 18? (Select all that apply)

Start the lesson to answer this multi-select question

Fill in the BlankInteractive

The {{blank0}} function in SQL calculates the total of numeric values in a column.

Start the lesson to answer this fill in the blank question

Get personalised lessons, quizzes, and instant feedback from your AI tutor.