SQL: DDL, DML & Queries — Chapter Test

Answer all 5 questions, then submit. You need 60% to pass. Log in to save progress.

Question 1
Which command CREATES the structure of a table?
AINSERT
BSELECT
CCREATE TABLE
DUPDATE
Question 2
What happens with DELETE FROM student; (no WHERE)?
ADeletes one row
BDeletes the whole table structure
CRemoves ALL rows from the table
DCauses an error
Question 3
Which clause sorts query results?
AGROUP BY
BORDER BY
CWHERE
DDISTINCT
Question 4
In LIKE, which wildcard matches any number of characters?
A_
B%
C*
D?
Question 5
Which keyword removes duplicate values from a result?
AUNIQUE
BDISTINCT
CONLY
DGROUP