SQL

Question 1

What does CRUD stand for?

Answer 1

Create, Read, Update, Delete

Question 2

What is the SQL command for reading data (R in CRUD)

Answer 2

SELECT … FROM

Question 3

What is the symbol for selecting all?

Answer 3

• the asterisk

Question 4

What does SQL stand for?

Answer 4

Structured Query Language

Question 5

What are rows called in databases?

Answer 5

records

Question 6

is SQL case sensitive?

Answer 6

no, but it is convention to write SQL statements in uppercase

Question 7

what is the resulting data from a SELECT statement called?

Answer 7

the result-set

Question 8

What does the DISTINCT keyword do with the SELECT statement?

Answer 8

selects and returns only distinct/different values (no duplicates)

Question 9

What is the syntax for the WHERE statement?

Answer 9

SELECT [column]
FROM [table_name]
WHERE [condition]

Question 10

What is the WHERE clause used for?

Answer 10

To filter results and apply conditions

Question 11

What word operators can the WHERE clause be used with?

Answer 11

AND, OR, and NOT

Question 12

How do you order data results in SQL?

Answer 12

With the ORDER BY keyword

Question 13

What are the two ways you can use the ORDER BY keyword to order data?

Answer 13

Order ascending with the ASC keyword, or order descending with the DESC keyword