SQL Basics

Front

What does "SQL" stand for?

Back

Structured Query Language

Front

Which statement extracts data from a database? Options: Extract, Get, Open, Select

Back

Select

Front

Which clause would you use to filter data? Options: Where, Order by, From, Select

Back

Where

Front

What is the symbol for 'less than or equal to'?

Back

<=

Front

Which word is missing from this SQL statement? Select * table_name Options: With, Where, From, And

Back

From

Front

How to select all rows from the "Designer" table?

Back

SELECT * FROM Designer

Front

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

Back

SELECT Description FROM Item

Front

Which query would return only DesignerID and Designer from the Designers table?

Back

SELECT DesignerID, Designer FROM Designers

Front

How to display Chairs in the Items table with a Price over 50?

Back

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

Front

SQL term 'FROM'

Back

The table used in the query