SQL Usage

Question 1

What is a field also known as?

Answer 1

An attribute

Question 2

What is a row also called?

Answer 2

A record

Question 3

SQL keywords are ____ case sensitive

Answer 3

NOT

Question 4

SQL SELECT specific columns

Answer 4

SELECT column1, column2, …
FROM table_name;

Question 5

Select ALL columns

Answer 5

SELECT * FROM table_name;

Question 6

SQL SELECT DISTINCT Statement

Answer 6

SELECT DISTINCT column1, column2, …
FROM table_name;

Question 7

Count Distinct

Answer 7

SELECT COUNT(DISTINCT column_name) FROM table_name;

Question 8

The SQL WHERE Clause

Answer 8

SELECT column1, column2, …
FROM table_name
WHERE condition;

Question 9

Operators that can be used with WHERE clause (9)

Answer 9

=
>
<
>=
<=
<> (!= - in some SQL versions)
BETWEEN x AND Y
LIKE
IN

Question 10

SQL ORDER BY

Answer 10

SELECT column1, column2, …
FROM table_name
ORDER BY column1, column2, … ASC|DESC;

Question 11

SQL AND Operator

Answer 11

SELECT column1, column2, …
FROM table_name
WHERE condition1 AND condition2 AND condition3 …;

Question 12

SQL OR Operator

Answer 12

SELECT column1, column2, …
FROM table_name
WHERE condition1 OR condition2 OR condition3 …;

Question 13

NOT Operator

Answer 13

SELECT column1, column2, …
FROM table_name
WHERE NOT condition;

Question 14

SQL INSERT INTO

Answer 14

INSERT INTO table_name (column1, column2, column3, …)
VALUES (value1, value2, value3, …);

or

INSERT INTO table_name
VALUES (value1, value2, value3, …);

Question 15

IS NULL Syntax

Answer 15

SELECT column_names
FROM table_name
WHERE column_name IS NULL;

Question 16

IS NOT NULL Syntax

Answer 16

SELECT column_names
FROM table_name
WHERE column_name IS NOT NULL;

Question 17

SQL UPDATE

Answer 17

UPDATE table_name
SET column1 = value1, column2 = value2, …
WHERE condition;

Question 18

SQL DELETE

Answer 18

DELETE FROM table_name WHERE condition;

Question 19

SQL SELECT TOP

Answer 19

SELECT column_name(s)
FROM table_name
WHERE condition
LIMIT number;

Question 20

SQL MIN()

Answer 20

SELECT MIN(column_name)
FROM table_name
WHERE condition;

Question 21

SQL MAX()

Answer 21

SELECT MAX(column_name)
FROM table_name
WHERE condition;

Question 22

Set Column Name (Alias)

Answer 22

SELECT MIN(Price) AS SmallestPrice
FROM Products;

Question 23

SQL COUNT()

Answer 23

SELECT COUNT(column_name)
FROM table_name
WHERE condition;

Question 24

SQL SUM()

Answer 24

SELECT SUM(column_name)
FROM table_name
WHERE condition;

Question 25

SQL AVG()

Answer 25

SELECT AVG(column_name)
FROM table_name
WHERE condition;

Question 26

SQL LIKE