Question 580
An incident summary text stores a ticket code embedded within narrative prose. The team implemented this change: Extract the documented ticket pattern and handle missing matches safely. Which result would best confirm the change worked?
Explanation
Correct Answer
Known incident strings produce the expected ticket IDs and unrelated words are ignored. REGEXP_SUBSTR can extract a substring matching a supported pattern from text.
Incorrect Answers
That observation could pass while the problem persists: Pattern specificity, input variability and no-match handling are necessary for trustworthy extraction.
This acceptance test measures the wrong outcome: Use the actual SQL regex dialect with representative text and supported function semantics.
The suggested success signal is inadequate because Extraction tests must compare exact expected ticket IDs and reject unrelated text or absent identifiers. The suggested measurement would appear successful even in a reproducible case where the original failure remains.