In SQL implementations that support the INSTR() function, what is the default…

PYQ IBPS SO CRP SPL-XIV (2024)

In SQL implementations that support the INSTR() function, what is the default starting index for the first character, and what value is returned if the specified substring is not found in the target string?

  1. A.

    Starts from 1; returns NULL if not found

  2. B.

    Starts from 0; returns -1 if not found

  3. C.

    Starts from 1; returns -1 if not found

  4. D.

    Starts from 0; returns 0 if not found

  5. E.

    Starts from 1; returns 0 if not found

Attempted by 53 students.

Sign up free to check your answer

Sign up free

Explore the full course: Ibps So It Mains

Loading lesson…