What does SQL stand for?
AnswerStructured Query Language
SQL, Structured Query Language, is the standard language for working with relational databases.
Coding · Facts & stats
Database facts & stats
7 fact-checked facts about databases, each with the reason behind it. 5 more are in today's round and join this page after it closes.
The basics
Which SQL command retrieves data from a table?
AnswerSELECT
SELECT reads rows; INSERT adds rows, DROP removes objects and GRANT sets permissions.
Going deeper
In the ACID properties of transactions, what does the 'A' stand for?
AnswerAtomicity
Atomicity means a transaction happens completely or not at all.
What does a SQL JOIN do?
AnswerCombines rows from two or more tables based on related columns
A JOIN matches rows across tables using related values, like customer IDs.
In a SQL query, what does the WHERE clause do?
AnswerFilters rows that meet a condition
WHERE keeps only rows that satisfy a condition; ORDER BY is what sorts results.
Expert level
Who proposed the relational model of data in 1970?
AnswerEdgar F. Codd
Edgar F. Codd, working at IBM, published the relational model in 1970.
What is the main goal of database normalization?
AnswerReduce redundant data and keep it consistent
Normalization organizes tables so each fact is stored once, avoiding update errors.
Know these cold?Today's round is five questions like these, 20 seconds each. Your streak and level follow you to every arena.Play today's round