SQL

Question 1

What does SQL stand for?

Answer 1

Structured Query Language

Question 2

What is a database?

Answer 2

A database is a persistent store of data.

Question 3

What does SQL allow you to do?

Answer 3

it is a language which allows you to create, query and add data to databases.

Question 4

Can SQL queries be used in high level programming languages?

Answer 4

Yes, they can be used in languages such as Python and C#

Question 5

What are the three SQL syntax for querying a database?

Answer 5

SELECT (list the fields to be displayed)
FROM (specify the table name)
WHERE (list the search criteria)

MUST ALL BE IN CAPITALS.

Question 6

What is a wild card?

Answer 6

All columns.

Question 7

What are the three main operators in word form?

Answer 7

AND, OR, NOT

Question 8

What does the Operator BETWEEN mean?

Answer 8

Searches between a inclusive range,

Question 9

What does the operator LIKE do?

Answer 9

Searches for a pattern.

Question 10

What does ORDER BY allow you to do?

Answer 10

Allows a query to sort data by ascending or descending order.

Question 11

What are the commands for Ascending order or Descending Order?

Answer 11

Ascending = ASC
Descending = DESC