GCSE OCR SQL

Front

What does "SQL" stand for?

Back

Structured Query Language

Front

Which statement is used to extract data from a database?

Back

Select

Front

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

Back

Where

Front

To remove a record from a table which SQL statement would you use? Options: Remove, Cancel, Delete, Eradicate

Back

Delete

Front

Less than or equal to?

Back

<=

Front

Which character returns all the data found in a table? Options: %, #, *, /

Back

*

Front

Which word is missing from the following SQL statement?
Select * table_name

Back

From

Front

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

Back

SELECT, FROM, WHERE, ORDER BY

Front

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

Back

SELECT * FROM Designer

Front

How would we script a SQL query to select "Description" from the Item table?

Back

SELECT Description FROM Item