Multiple choice technology databases

Which character function can be used to return a specified portion of a character string?

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In SQL databases like Oracle, SUBSTR is the character function used to extract a specific substring from a string. While SUBSTRING exists in other SQL dialects, SUBSTR is the correct matching option here. INSTR finds character positions, and POS is not a standard SQL function for this.

Keep practicing — related questions