← 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 tech, what does DB usually stand for?

AnswerDatabase

DB is common shorthand for database.

What is a primary key?

AnswerA column that uniquely identifies each row

Primary key values must be unique.

Going deeper

Which SQL clause filters rows by a condition?

AnswerWHERE

WHERE keeps only rows that meet the condition.

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

AnswerAtomicity

Atomicity means a transaction happens fully or not at all.

Which of these is a NoSQL document database?

AnswerMongoDB

MongoDB stores JSON-like documents.

Expert level

What does a database index mainly speed up?

AnswerFinding rows in queries

Indexes speed lookups at the cost of extra storage and writes.

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