Multiple choice technology databases

select INSTR('TCS_SQL','S',4) from dual;

  1. 3

  2. 6

  3. 5

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

INSTR('TCS_SQL','S',4) searches for 'S' starting from position 4 in 'TCS_SQL'. Positions 1-3 are 'T', 'C', 'S' (the first S). From position 4, the string is '_SQL', where 'S' is at position 5 of the original string (second S in the string).

Keep practicing — related questions