Back to marketplace

SQL

No description yet. This curated deck is ready for daily study.

Total cards: 12•Content version: v4•Public deck•Updated: 8/1/2026

Card preview (12)

#1
Front (Question)

What command is used when choosing fields to read from?

Back (Answer)

SELECT , for multiple fields

#2
Front (Question)

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

Back (Answer)

FROM

#3
Front (Question)

What command is used for conditional selection?

Back (Answer)

WHERE AND/OR if multiple conditions

#4
Front (Question)

What symbol means all?

Back (Answer)

*

#5
Front (Question)

What condition would only take names starting with a?

Back (Answer)

WHERE name LIKE ‘A%’

#6
Front (Question)

How do you remove records?

Back (Answer)

DELETE FROM table WHERE condition

#7
Front (Question)

How do you create new records?

Back (Answer)

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

#8
Front (Question)

How do you delete an entire field?

Back (Answer)

DROP COLUMN fieldname

#9
Front (Question)

How do you delete an entire table?

Back (Answer)

DROP TABLE tablename

#10
Front (Question)

How do you link tables?

Back (Answer)

JOIN table2 on table1.key = table2.key

#11
Front (Question)

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

Back (Answer)

SELECT FROM JOIN WHERE

#12
Front (Question)

What is the % wildcard in sql?

Back (Answer)

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