← DbChallenge.com

Coding · Facts & stats

DB facts & stats

7 fact-checked facts about databases and SQL, each with the reason behind it. 5 more are in today's round and join this page after it closes.

Play today's round

The basics

In a database table, what is a single row often called?

AnswerA record

Each row is one record.

Which SQL command retrieves data from a table?

AnswerSELECT

SELECT queries read data.

Going deeper

Who proposed the relational database model in 1970?

AnswerEdgar F. Codd

Codd described the model while at IBM.

In the ACID properties of transactions, what does the A stand for?

AnswerAtomicity

Atomicity means a transaction happens fully or not at all.

What is a foreign key?

AnswerA column that refers to a primary key in another table

Foreign keys link related tables.

Expert level

Which JOIN returns only rows that have matches in both tables?

AnswerINNER JOIN

INNER JOIN keeps only matching rows.

In which year was SQLite first released?

Answer2000

D. Richard Hipp released SQLite in August 2000.

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