SQL

Question 1

How should you differentiate text, number and date values in a query?

Answer 1

Text should use quotation marks (“ … “)

Number must not use quotation marks ( 92 )

Data must use hashtags (#6/14/2004#)

Question 2

What are and how would you use wildcard operators in SELECT queries?

Answer 2

Asterisk () can be used to represent any number of characters. I.e. any number starting with 519 is [ LIKE “519”

Question marks (?) are like asterisks but represent single value placeholders. I.e. 4 numbers in between 1 and 9 would is [ LIKE “1????9”]

Question 3

How would you order a query by say, first name?

Answer 3

end statement with ORDER BY Firstname;

Question 4

What are 5 built-in functions with SELECT queries?

Answer 4

1. Max
2. Min
3. Avg
4. Count
5. Sum

Question 5

When are semi-colons needed at the end of an SQL statement?

Answer 5

In MS-Access SQL: OPTIONAL

In MS SQL Server: MANDATORY

Question 6

What are the four types of SQL Action queries?

Answer 6

1. INSERT INTO
2. DELETE
3. UPDATE
4. CREATE TABLE

Question 7

Write the syntax for UPDATE actions.

Answer 7

UPDATE
SET =
WHERE
;

Question 8

Write the syntax for INSERT actions.

Answer 8

INSERT INTO
(, )
VALUES
(, );

Question 9

Write syntax for DELETE actions.

Answer 9

DELETE *
FROM

WHERE

Question 10

Write syntax for CREATE TABLE actions.

Answer 10

CREATE TABLE

( , etc.)