What do most people say for “Name an SQL keyword or clause”?

The usual first answers are SELECT, INSERT and UPDATE. In Icillion they are worth 10 points each, the least of any level.

How many answers are there to “Name an SQL keyword or clause”?

33 in all: 3 on The Tip, 6 Below the Surface, 7 in The Deep, 16 in The Abyss, and a single legendary answer Below the Iceberg.

Which answers to “Name an SQL keyword or clause” are the shortest and the longest?

The shortest accepted answer is “CASE” and the longest is “PARTITION BY”.

Computer Science trivia

Name an SQL keyword or clause

“Name an SQL keyword or clause” is one of 34 computer science prompts in Icillion. Of its 33 accepted answers, 3 are the ones nearly everyone says first; the rest sink deeper the rarer they are.

The tip of the iceberg

Right, but shallow: 3 answers nearly everyone thinks of, worth 10 points each.

SELECT
INSERT
UPDATE

One step down

These 6 are known, but not the first thing people say. 25 points each:

DELETE
FROM
WHERE
JOIN
CREATE
DROP

Answers by level

Level	Accepted answers	Points
The Tip	3	10
Below the Surface	6	25
The Deep	7	50
The Abyss	16	85
Below the Iceberg	1	100

The Deep holds 7 answers starting with A, D, G, H, L, O and U. The Abyss has 16 more, and one legendary answer waits below them all.

Inside the answer list

33 answers in total, 3 of them longer than one word.
Shortest: “CASE”. Longest: “PARTITION BY”.
C, D and R are the most common first letters; together they start 27% of the answers.

Getting below the surface

Start with C: 3 of the answers begin with it.
SELECT, INSERT and UPDATE are safe but shallow. Aim past them.
Older and academic tools are rare answers.

Play computer science trivia now See all 33 answers A–Z

What the words mean

Questions about this prompt

What do most people say for “Name an SQL keyword or clause”?: The usual first answers are SELECT, INSERT and UPDATE. In Icillion they are worth 10 points each, the least of any level.
How many answers are there to “Name an SQL keyword or clause”?: 33 in all: 3 on The Tip, 6 Below the Surface, 7 in The Deep, 16 in The Abyss, and a single legendary answer Below the Iceberg.
Which answers to “Name an SQL keyword or clause” are the shortest and the longest?: The shortest accepted answer is “CASE” and the longest is “PARTITION BY”.

More computer science trivia

Something different: Name a type of parrot · Name a sea or ocean · Name a martial art

All 34 computer science prompts

How deep does your knowledge go?

Seven prompts a day, twenty seconds each. Obvious answers float on the tip of the iceberg; rare ones sink all the way to the trench.

▼ Start today’s iceberg ▼