PostgreSQL: range, tìm kiếm, JSONPath và thời gian

Nội dung luyện tập

• search range inclusive exclusive bounds
• search json extraction result type
• search tsvector normalizes lexemes
• search strpos one based not found zero
• search discrete range canonical form
• search jsonb array containment not multiplicity
• search plain query does not parse or syntax
• search array subscript versus ordinality
• search regexp replace global flag
• search timestamp type ignores zone in literal
• search jsonpath item existence versus predicate
• search set returning regex can remove row
• search phrase stopword keeps position distance
• search exclusion rejects overlapping range
• search calendar day versus elapsed hours
• search text gin does not store weight labels
• search fulltext config migration needs vector refresh
• search untrusted regex needs resource boundaries
• search transaction time is not wall clock now
• search jsonb gin opclass matches query set

Mỗi câu đúng 1 điểm. Mục tiêu 70%. Đáp án và giải thích mở sau khi nộp bài.