7.7 Introduction to SQL

Question 1

SQL stands for

Answer 1

Structured Query Language

Question 2

What is SQL used for?

Answer 2

A language which can be used to create, query and add data to databases

Question 3

SQL syntax for querying a database

Answer 3

SELECT … FROM … WHERE …

Question 4

What does the wild card “*” do?

Answer 4

Selects all columns

Question 5

BETWEEN

Answer 5

Includes a range for the query

Question 6

LIKE

Answer 6

Searches for a pattern in the table

Question 7

ORDER BY

Answer 7

Allows a query to sort data by ascending or descending order