Y9 Assessment 4 Revision Quiz

What does "SQL" stand for?

• Structured Question Language

• Structured Query Language

• Simple Query Language

• Simple Question Language

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

Less than or equal to?

• >=

• =>

• =<

• <=

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

• SELECT * FROM Designer

• SELECT [All] FROM Designer

• SELECT Designer.*

• SELECT FROM Designer

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

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

• SELECT * FROM Items ORDER BY Price ASCENDING

• SELECT * FROM Items ORDER BY Price ASC

• SELECT * FROM Items BY Price LOWEST TO HIGHEST

• SELECT * FROM Items ORDER BY Price DESC

What term is used to describe data passed into/out of a program?

• Variable

• Loop

• Constant

• Parameter

What will be the output of this program if the user enters "Han" and then "Solo"?

• An error

• Nothing

• first surname

• Han Solo