All quizzesEasy
CASE, COALESCE & Functions — Series 2
Preview — 3 of 10 questions
What does LENGTH('PostgreSQL') return?
A10
B9
C11
D12
What does TRIM(' hello ') return?
javascript
SELECT TRIM(' hello '); -- 'hello'
SELECT LTRIM(' hello '); -- 'hello '
SELECT RTRIM(' hello '); -- ' hello'A' hello'
B'hello'
C'hello '
D' hello '
What does REPLACE('2024-01-15', '-', '/') return?
javascript
SELECT REPLACE('2024-01-15', '-', '/');
-- '2024/01/15'A'2024-01-15'
B'2024_01_15'
C'2024/01/15'
DAn error — REPLACE requires a regular expression pattern
Sign up free to play
Answer all 10 questions (7 more), see explanations for every answer, and track your score.