Back to marketplace

SQL

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

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

Card preview (24)

#1
Front (Question)

What does SQL stand for?

Back (Answer)

Structured Query Language

#2
Front (Question)

What type of language is SQL?

Back (Answer)

Declarative language

#3
Front (Question)

What are the four main commands in SQL?

Back (Answer)

• SELECT • UPDATE • INSERT • DELETE

#4
Front (Question)

What is the purpose of the SELECT command in SQL?

Back (Answer)

Used for retrieving data from a database table

#5
Front (Question)

What is the general form of the SELECT command?

Back (Answer)

SELECT <attribute> FROM <table> WHERE <condition> ORDER BY <ASC/DESC></condition></attribute>

#6
Front (Question)

Is the ORDER BY clause mandatory in a SELECT command?

Back (Answer)

No, it is optional

#7
Front (Question)

What is the purpose of the UPDATE command?

Back (Answer)

Used for modifying the attributes of an existing entity

#8
Front (Question)

What is the general form of the UPDATE command?

Back (Answer)

UPDATE <table> SET <attribute> = <value> WHERE <attribute> = <value></value></attribute></value></attribute>

#9
Front (Question)

What is the purpose of the DELETE command?

Back (Answer)

Used for removing entities from a database

#10
Front (Question)

What is the general form of the DELETE command?

Back (Answer)

DELETE FROM <table> WHERE <condition></condition>

#11
Front (Question)

What is the purpose of the INSERT command?

Back (Answer)

Used to add new records to an existing table

#12
Front (Question)

What is the general form of the INSERT command?

Back (Answer)

INSERT INTO <table> (<column1>, <column2>, …) VALUES (<value1>, <value2>, …)</value2></value1></column2></column1>

#13
Front (Question)

How can the INSERT command be simplified?

Back (Answer)

INSERT INTO <table> VALUES (<value1>, <value2>, …) when all columns are used in correct order</value2></value1>

#14
Front (Question)

What are wildcards in SQL?

Back (Answer)

Used to specify any possible value

#15
Front (Question)

How are wildcards typically notated in SQL?

Back (Answer)

With an asterisk (*)

#16
Front (Question)

What command is used to create a new database table in SQL?

Back (Answer)

CREATE command

#17
Front (Question)

What does the CREATE command specify?

Back (Answer)

• Name of the new table • Attributes and their data types • Entity identifiers like primary and secondary keys

#18
Front (Question)

What does the CREATE command do?

Back (Answer)

Creates an empty table

#19
Front (Question)

What is the CHAR data type in SQL?

Back (Answer)

A fixed-length string with a specified number of characters

#20
Front (Question)

What is the VARCHAR data type in SQL?

Back (Answer)

A variable-length string with a maximum specified number of characters

#21
Front (Question)

What is the INT data type in SQL?

Back (Answer)

An integer stored using a specified number of bits

#22
Front (Question)

What does the FLOAT data type represent?

Back (Answer)

A number with a fractional part stored with specified bits and precision

#23
Front (Question)

What format is the DATE data type in SQL?

Back (Answer)

YYYY-MM-DD

#24
Front (Question)

What is the format of the DATETIME data type in SQL?

Back (Answer)

YYYY-MM-DD HH:MM:SS