Multiple choice technology databases

instr(Tech on the net, e, -3, 2) would retrun

  1. 10

  2. 8

  3. 6

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

The instr function searches for a substring. With -3 as start position, it searches 3 characters from the END. In 'Tech on the net', counting back 3 from end: 't' at position 10. Searching for 'e' going backwards: 'e' at position 2 (in 'Tech'). Length parameter 2 doesn't apply when searching backwards.

Keep practicing — related questions