SQL Basics for CCEA Digital Tech

What does "SQL" stand for?

• Structured Question Language

• Structured Query Language

• Simple Query Language

• Simple Question Language

Tags

CCSS.RI.11-12.4

CCSS.RI.9-10.4

CCSS.RI.9-10.4

CCSS.RI.8.4

CCSS.RI.7.4

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

Less than or equal to?

• >=

• =>

• =<

• <=

Which word is missing from the following SQL statement?

Select * table_name

• With

• Where

• From

• And

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

• SELECT * FROM Designer

• SELECT [All] FROM Designer

• SELECT Designer.*

• SELECT FROM Designer

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

• SELECT Item.Description

• EXTRACT Description FROM Item

• SELECT Item FROM Description

• SELECT Description FROM Item

Which query would return only the fields DesignerID and Designer?

• SELECT * FROM Designers

• SELECT DesignerID, Name FROM Designers

• SELECT DesignerID AND Designer FROM Designers

• SELECT DesignerID, Designer FROM Designers

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

Match the following SQL term with a description - FROM

• The criteria which must be met

• The fields to display

• The field and order used to sort the results

• The table used in the query