MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The string function that returns the index of the first occurrence of substring is ____
A
INSERT()
B
INSTR()
C
INSTRING()
D
INFSTR()
Explanation: 

Detailed explanation-1: -MySQL INSTR() takes a string and a substring of it as arguments, and returns an integer which indicates the position of the first occurrence of the substring within the string.

Detailed explanation-2: -The indexOf() method, given one argument: a substring to search for, searches the entire calling string, and returns the index of the first occurrence of the specified substring.

Detailed explanation-3: -The INSTR function searches a character string for a specified substring, and returns the character position in that string where an occurrence of that a substring ends, based on a count of substring occurrences.

Detailed explanation-4: -They allow you to change the characters in a string individually, compare strings, search strings, extract substrings, and copy a string. These SQL String Functions may also be used to convert strings to lowercase or uppercase. INSTR() helps to find if a substring is present in the original string.

Detailed explanation-5: -Returns a specified substring from a string.

There is 1 question to complete.
Previous
Next