Text and Unicode

Module 4 quiz

Practice questions: choose an answer and check it to see the explanation. Nothing here is timed or graded.

1. 1. Two names look identical but don't compare equal. The most likely cause is:

   Different fontsDifferent Unicode forms (composed é versus e plus a combining accent)Trailing zerosA timezone difference
   Check
2. 2. DuckDB: what does trim(' a\u00a0') return when the value ends with a no-break space?

   'a''a' followed by the no-break spaceAn empty stringNULL
   Check
3. 3. Names contain double spaces inside them ("Ana Lopez"). The rules only say to trim the ends. What should you do?

   Collapse inner spaces anywayTrim the ends only and record the inner spaces as an open questionRemove all spacesQuarantine every name with two spaces
   Check
4. 4. A team lowercases names before storing them so that comparisons work. What is the problem?

   Lowercasing is slowIt changes the stored value; compare on a normalized key but keep the original nameLowercase breaks UnicodeNothing; names are case-insensitive
   Check
5. 5. What is the difference between NFC normalization and transliteration?

   NoneNFC makes equivalent forms identical without changing letters; transliteration replaces letters (é → e)NFC removes accentsTransliteration is required for names
   Check
6. 6. Two keys look identical but don't join. Printing their lengths shows 6 and 7. What is a likely cause?

   CaseAn invisible character such as a zero-width space or no-break spaceA leading zeroUnicode can't be joined
   Check
7. 7. Product codes have trailing tabs from a copy-paste. The rule says trim ASCII whitespace. What happens to the tabs?

   They stayThey are removed; tab is ASCII whitespaceThe codes are quarantinedThey become spaces
   Check