All quizzesEasy
CASE, COALESCE & Functions — Series 3
Preview — 3 of 10 questions
What does LEFT('PostgreSQL', 4) return?
ASQL
BPost
CgreSQL — everything except the first 4 characters
DAn error — LEFT isn't a real function; only SUBSTRING exists
What does SPLIT_PART('2026-08-27', '-', 2) return?
A2026
B27
C08
D2026-08
What does LPAD('42', 5, '0') return?
A42000
B00042
C42
DAn error, since LPAD only works on strings, not the numeric literal 42
Sign up free to play
Answer all 10 questions (7 more), see explanations for every answer, and track your score.