SQL Basics

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

• SELECT * FROM Designers

• SELECT DesignerID, Name FROM Designers

• SELECT DesignerID AND Designer FROM Designers

• SELECT DesignerID, Designer FROM Designers

What does "SQL" stand for?

• Structured Question Language

• Structured Query Language

• Simple Query Language

• Simple Question Language

What would the SQL query do?

• Find all the men

• Find all of the female writers

• Find all of Elgar's friends

• Find all the male writers

• Find all the fish

What is missing in this SQL query? SELECT * FROM WHERE genre = ‘action’ ORDER BY year ASC;

• Missing an AND

• Table name

• Capitalize action

• None of these

Which statement extracts data from a database?

• Extract

• Get

• Open

• Select

Each field name in a table has a ...

• table name and a database

• command and an argument

• goal and a purpose

• name and a data type

Which clause would you use to filter data?

• Where

• Order by

• From

• Select

How to 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

What does the SQL term 'ORDER BY' describe?

• The fields to display

• The field and order used to sort the results

• The table used in the query

• The criteria that must be met

Which word is missing from this SQL statement?

Select * table_name

• With

• Where

• From

• And