T7 - SQL

Question 1

SQL

Answer 1

stands for Structured Query Language
allows you to create, query and add data to databases

Question 2

SELECT

Answer 2

… (list the fields to be displayed)

Question 3

FROM …

Answer 3

(specify the table name)

Question 4

WHERE

Answer 4

… (list the search criteria)

Question 5

“wild card”

Answer 5

• to mean “all columns”

Question 6

WHERE clause

Answer 6

is used to select only records satisfying a specified condition:

Question 7

Operators in where clause:

Answer 7

= != > < >= <= AND, OR, NOT

Question 8

BETWEEN

Answer 8

between an inclusive range

Question 9

LIKE

Answer 9

search for a pattern

Question 10

Sorting:

Answer 10

ORDER BY allows a query to sort data by ascending or descending order

Question 11

To sort by ascending order:

Answer 11

ORDER BY Surname ASC

Question 12

To sort by descending order:

Answer 12

ORDER BY Surname DESC