SQL

Which statement is used to extract data from a database?

• Extract

• Get

• Open

• Select

If you were wanting to filter data, which clause would you use?

• Where

• Order by

• From

• Select

Using which word allows you to specify that more than one condition must be met in a query?

• Also

• And

• Or

• Where

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

• And

• Maybe

• If

• Or

Which statement allows us to add a record to a table?

• Add To

• Update To

• Add Into

• Insert Into

Which character returns all the data found in a table?

• %

• #

• *

• /

Which word is missing from the following SQL statement?

Select * table_name

• With

• Where

• From

• And

What is the correct order of clauses in a SQL statement?

• SELECT, FROM, ORDER BY, WHERE

• SELECT, FROM, WHERE, ORDER BY

• SELECT, WHERE, FROM, ORDER BY

• WHERE, FROM, SELECT, ORDER BY

How do we select all rows for the "Designer" table?

• SELECT * FROM Designer

• SELECT [All] FROM Designer

• SELECT Designer.*

• SELECT FROM Designer

How would you display Chairs in the Items table that have a Price greater than £50.

• SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

• SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

• SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

• SELECT * FROM Items WHERE Price > 50