Which string function returns the index of the first occurrence of substring?(a) INSERT()(b) INSTR()(c) INSTRING()(d) INFSTR()This question was addressed to me by my school principal while I was bunking the class.My doubt stems from System Variables in section System, Status and User Variables of MySQL

Which string function returns the index of the first occurrence of sub

1.	Which string function returns the index of the first occurrence of substring?(a) INSERT()(b) INSTR()(c) INSTRING()(d) INFSTR()This question was addressed to me by my school principal while I was bunking the class.My doubt stems from System Variables in section System, Status and User Variables of MySQL
Answer» Right choice is (b) INSTR() The best I can explain: The string funtion ‘INSTR()’ is used to return the index of the FIRST occurrence of the substring. The FUNCTION ‘INSERT()’ is used to insert a substring at the SPECIFIED POSITION up to the specified number of characters.

Discussion

No Comment Found

Related InterviewSolutions

What does mysql_query() return on failure?(a) 0(b) 1(c) -1(d) a non-zeroI got this question in an internship interview.This key question is from User-Defined Variables in division System, Status and User Variables of MySQL
The option that enables multiple-statement execution is ____________(a) CLIENT_MULTI_STATEMENTS(b) CLIENT_STATEMENTS_MULTI(c) MULTI_STATEMENTS_CLIENT(d) MULTI_CLIENTS_STATEMENTSThe question was posed to me in a national level competition.I want to ask this question from User-Defined Variables in division System, Status and User Variables of MySQL
Multiple statement execution is disabled by default.(a) True(b) FalseI got this question during an internship interview.My question is taken from User-Defined Variables topic in chapter System, Status and User Variables of MySQL
What is the type of Audit_log_events system variable?(a) string(b) integer(c) float(d) doubleThe question was asked during an online interview.Question is taken from User-Defined Variables topic in chapter System, Status and User Variables of MySQL
Hexadecimal values assigned to user variables are treated as _____________(a) strings(b) non binary strings(c) binary strings(d) integersThis question was posed to me in class test.I would like to ask this question from User-Defined Variables topic in section System, Status and User Variables of MySQL
User defined variables are session specific.(a) True(b) FalseI got this question during a job interview.Question is from User-Defined Variables in portion System, Status and User Variables of MySQL
The columns containing a binary value that include null bytes will print properly using the %s printf() format specifier.(a) True(b) FalseI have been asked this question during an interview.My question is taken from Status Variables topic in section System, Status and User Variables of MySQL
What does mysql_fetch_row() return?(a) integer(b) float(c) structure(d) pointerThe question was posed to me during an interview for a job.The doubt is from Status Variables topic in division System, Status and User Variables of MySQL
The option that executes all SQL statements in a SQL script irrespective of the number of errors is ____________(a) –ensure(b) –force(c) –violent(d) –runThis question was posed to me during an interview.My enquiry is from Status Variables topic in section System, Status and User Variables of MySQL
mysql_next_result() does not return a status.(a) True(b) FalseThe question was asked in an online interview.I want to ask this question from Status Variables in chapter System, Status and User Variables of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment