SQL

Question 1

What command is used when choosing fields to read from?

Answer 1

SELECT
, for multiple fields

Question 2

What command is used to choose which table to read/write data?

Answer 2

FROM

Question 3

What command is used for conditional selection?

Answer 3

WHERE
AND/OR if multiple conditions

Question 4

What symbol means all?

Answer 4

*

Question 5

What condition would only take names starting with a?

Answer 5

WHERE name LIKE ‘A%’

Question 6

How do you remove records?

Answer 6

DELETE FROM table
WHERE condition

Question 7

How do you create new records?

Answer 7

INSERT INTO table (field1, 2…)
VALUES (1,2,3…)

Question 8

How do you delete an entire field?

Answer 8

DROP COLUMN fieldname

Question 9

How do you delete an entire table?

Answer 9

DROP TABLE tablename

Question 10

How do you link tables?

Answer 10

JOIN table2 on
table1.key = table2.key

Question 11

What is the order of commands when selecting data in relational databases?

Answer 11

SELECT
FROM
JOIN
WHERE

Question 12

What is the % wildcard in sql?

Answer 12

however many characters, can be 0, used for LIKE command