GCSE J277 - 2.2.3 - SQL

Which of these is NOT a valid clause (part) of a SQL statement

• SELECT
• FROM
• WHERE
• TABLE

What is the correct order for these keywords in a SQL statement

• SELECT, WHERE, FROM
• SELECT, FROM, WHERE
• FROM, WHERE, SELECT
• WHERE, FROM, SELECT

Choosing which fields of data are retrieved is done in which part of the statement

• SELECT
• FROM
• WHERE
• ORDER BY

Choosing the criteria for which data is retrieved is done in which part of the statement

• SELECT
• FROM
• WHERE
• ORDER BY

Choosing the table data is extracted from is done in which part of the statement

• SELECT
• FROM
• WHERE
• ORDER BY

Which of these wildcards would retrieve ALL fields (Columns) from a table

• !
• ALL
• *
• @

Which of these statements would retrieve everyone with the name "Jim"

• SELECT * FROM users WHERE name = "Jim"
• SELECT * FROM users WHERE name = Jim
• SELECT * FROM users WHERE name == "Jim"
• SELECT * FROM users WHERE name == Jim

If I wanted to filter data I extract, which clause would I use

• SELECT
• FROM
• WHERE
• ORDER BY

Allows you to specify more than one condition on the WHERE clause

• Or
• Also
• And
• When

Allows you to specify only one of a series of conditions needs to be met on the WHERE clause

• Or
• Also
• And
• When