The string function that returns the index of the first occurrence of substring is ______

  1. Home
  2. Back

SQL - Online Exam Test Papers | SQL - MCQs[multiple choice questions and answers ] | SQL - Mock Test Papers | SQL - Practice Papers | SQL - Sample Test Papers |

Question:
The string function that returns the index of the first occurrence of substring is ______

1.INSERT()

2.INSTR()

3.INSTRING()

4.INFSTR()

Posted Date:-2021-07-18 21:17:05

More MCQS Questions and answers

  1. ‘fetchrow_hashref()’ returns a reference to the hash of row values keyed by what?
  2. For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?
  3. In which mode is the indicator of the presence/absence of a word in search used?
  4. The Audit_log_events system variable is of type ________
  5. The facility that allows nesting one select statement into another is ________
  6. The functions in Perl DBI called?
  7. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is _________
  8. The line that is written at the top of the script to write a Perl script using CGI.pm is ___________
  9. The mode of search is the search string parsed into words and the search looks for rows is _________
  10. The mode that does not remove trailing spaces when CHAR values are retrieved is ________
  11. The operator that compares sounds is ________
  12. The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______
  13. The permitted value type for the variable ‘character_set_client’ is ________
  14. The server is told to accept spaces after function names by _______
  15. The statement that views status variables by aggregating the values over all connections is _________
  16. The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____
  17. The string function that returns the index of the first occurrence of substring is ______
  18. The synonym for last_insert_id session variable is ______
  19. The variable used as a handle to an open file is _______
  20. To disallow zero month or day parts in dates, the option used is _______
  21. What does CGI stand for?
  22. What does RTF refer to?
  23. What does the AUTO_INCREMENT sequences begin at by default?
  24. What is SBR replication?
  25. What is the generic handle whose meaning depends on context?
  26. What is the minimum value stored by signed TINYINT?
  27. What is the non handle array representing a row of values?
  28. What is the shebang line?
  29. What is the synonym for last_insert_id session variable?
  30. What is used to reload a delimited text data file?
  31. What returns a string containing an error message?
  32. When building from source, the embedded server library is enabled by what?
  33. Which classes does spatial data types in MySQL correspond to?
  34. Which function returns a reference to hash of row values?
  35. Which function returns an array of row values?
  36. Which function returns NULL if expr1 = expr2?
  37. Which is the header that should be included first?
  38. Which is the library file that contains various portability macros and definitions?
  39. Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?
  40. Which mode does not remove trailing spaces when CHAR values are retrieved?
  41. Which module links DBI to the web?
  42. Which of these has special automatic update behavior?
  43. Which of these is a read only variable?
  44. Which operator compares sounds?
  45. Which operator is used to return value from JSON columns after evaluating the path and unquoting the result?
  46. Which string function returns the index of the first occurrence of substring?
  47. Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory?
  48. Which type can store a collection of objects of any type?
  49. Which variable is a handle to a database object?
  50. Which variable when set to 1 would enable foreign key checking for InnoDB tables?

Question :- ‘fetchrow_hashref()’ returns a reference to the hash of row values keyed by what?

1.row name

2.column name

3.table name

4.database name

Answer 2

Question :- For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

1.–multiple-transaction

2.–single-transaction

3.–double-transaction

4. –no-transaction

Answer 2

Question :- In which mode is the indicator of the presence/absence of a word in search used?

1.Natural language

2.Boolean mode

3.Query expansion

4.Cross mode

Answer 2

Question :- The Audit_log_events system variable is of type ________

1.string

2.integer

3.float

4.double

Answer 2

Question :- The facility that allows nesting one select statement into another is ________

1.nesting

2.binding

3.subquerying

4.encapsulating

Answer 3

Question :- The functions in Perl DBI called?

1.functions

2.procedures

3.methods

4.programs

Answer 3

Question :- The join in which all the rows from the right table appear in the output irrespective of the content of the other table is _________

1.CARTESIAN JOIN

2.CROSS JOIN

3.INNER JOIN

4.RIGHT JOIN

Answer 4

Question :- The line that is written at the top of the script to write a Perl script using CGI.pm is ___________

1.use this CGI

2.put CGI

3.use CGI

4.include CGI

Answer 3

Question :- The mode of search is the search string parsed into words and the search looks for rows is _________

1.Boolean mode

2.Natural language

3.Query expansion

4.Cross mode

Answer 2

Question :- The mode that does not remove trailing spaces when CHAR values are retrieved is ________

1.PAD_CHAR_TO_FULL_LENGTH

2.TO_FULL_LENGTH_CHAR_PAD

3.CHAR_PAD_TO_FULL_LENGTH

4.PAD_CHAR_TO_LENGTH

Answer 1

Question :- The operator that compares sounds is ________

1.MATCH SOUNDS

2.CHECK SOUNDS

3.SOUNDS LIKE

4.SOUNDS SIMILAR

Answer 3

Question :- The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______

1.–ensure

2.–force

3.–violent

4.–run

Answer 2

Question :- The permitted value type for the variable ‘character_set_client’ is ________

1.integer

2.float

3.double

4.string

Answer 4

Question :- The server is told to accept spaces after function names by _______

1.–sql-mode=SKIP_SPACE

2.–sql-mode=IGNORE_SPACE

3.–sql-mode=SPACE_IGNORE

4.–sql-mode=SPACE_SKIP

Answer 2

Question :- The statement that views status variables by aggregating the values over all connections is _________

1.SHOW SESSION STATUS

2.SHOW LOCAL STATUS

3.SHOW GLOBAL STATUS

4.SHOW STATUS

Answer 3

Question :- The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____

1.1

2.3

3.5

4.6

Answer 3

Question :- The string function that returns the index of the first occurrence of substring is ______

1.INSERT()

2.INSTR()

3.INSTRING()

4.INFSTR()

Answer 2

Question :- The synonym for last_insert_id session variable is ______

1.insert_id

2.identity

3.sql_auto_is_null

4.sql_big_selects

Answer 2

Question :- The variable used as a handle to an open file is _______

1.$dbh

2.$sth

3.$fh

4.$h

Answer 3

Question :- To disallow zero month or day parts in dates, the option used is _______

1.NO_ZERO_IN_DATE

2.NO_DATE_WITH_ZERO

3.ZERO_IN_DATE

4.DATE_WITH_ZERO

Answer 1

Question :- What does CGI stand for?

1.Computer Gateway Interface

2.Common Gateway Interface

3.Computer Generated Interface

4.Common Generated Interface

Answer 2

Question :- What does RTF refer to?

1.Rich Text Format

2.Right Text Format

3.Rich Text Function

4.Right Text Function

Answer 1

Question :- What does the AUTO_INCREMENT sequences begin at by default?

1.0

2.1

3.-1

4.2

Answer 2

Question :- What is SBR replication?

1.Statement based

2.Row based

3.Column based

4.Table based

Answer 1

Question :- What is the generic handle whose meaning depends on context?

1.$dbh

2.$sth

3.$fh

4.$h

Answer 4

Question :- What is the minimum value stored by signed TINYINT?

1.-256

2.-128

3.0

4.128

Answer 2

Question :- What is the non handle array representing a row of values?

1.$rc

2.$rv

3.$rows

4.$ary

Answer 4

Question :- What is the shebang line?

1.#!

2.!#

3.#$

4.$#

Answer 1

Question :- What is the synonym for last_insert_id session variable?

1.insert_id

2.identity

3.sql_auto_is_null

4.sql_big_selects

Answer 2

Question :- What is used to reload a delimited text data file?

1.mysqldump

2.mysqld

3.mysqlimport

4.mysqlnaive

Answer 3

Question :- What returns a string containing an error message?

1.mysql_error()

2.mysql_errno()

3.mysql_sqlstate()

4.mysql_close()

Answer 1

Question :- When building from source, the embedded server library is enabled by what?

1.–with-embedded-server

2.with-server-embedded

3.–with-embedded-library

4.–with-library-embedded

Answer 1

Question :- Which classes does spatial data types in MySQL correspond to?

1.OpenGSS

2.OpenGIS

3.ClosedGSS

4.ClosedGIS

Answer 2

Question :- Which function returns a reference to hash of row values?

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Answer 4

Question :- Which function returns an array of row values?

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Answer 1

Question :- Which function returns NULL if expr1 = expr2?

1.CASE

2.IF()

3.IFNULL()

4.NULLIF()

Answer 4

Question :- Which is the header that should be included first?

1.my_global.h

2.my_sys.h

3.mysql.h

4.my_local.h

Answer 1

Question :- Which is the library file that contains various portability macros and definitions?

1.my_global.h

2.my_sys.h

3.mysql.h

4.my_local.h

Answer 2

Question :- Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?

1.GLOBAL

2.SESSION

3.LOCAL

4.DEFAULT

Answer 2

Question :- Which mode does not remove trailing spaces when CHAR values are retrieved?

1.PAD_CHAR_TO_FULL_LENGTH

2.TO_FULL_LENGTH_CHAR_PAD

3.CHAR_PAD_TO_FULL_LENGTH

4.PAD_CHAR_TO_LENGTH

Answer 1

Question :- Which module links DBI to the web?

1.CGI.pn

2.CGI.pem

3.CGI.pm

4.CGI.po

Answer 3

Question :- Which of these has special automatic update behavior?

1.DATE

2.TIME

3.TIMESTAMP

4.YEAR

Answer 3

Question :- Which of these is a read only variable?

1.error_count

2.big_tables

3.autocommit

4.foreign_key_checks

Answer 1

Question :- Which operator compares sounds?

1.MATCH SOUNDS

2.CHECK SOUNDS

3.SOUNDS LIKE

4.SOUNDS SIMILAR

Answer 3

Question :- Which operator is used to return value from JSON columns after evaluating the path and unquoting the result?

1.->

2.->>

3.<<

4.>>

Answer 2

Question :- Which string function returns the index of the first occurrence of substring?

1.INSERT()

2.INSTR()

3.INSTRING()

4.INFSTR()

Answer 2

Question :- Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory?

1.basedir

2.back_log

3.big_tables

4.bind_address

Answer 3

Question :- Which type can store a collection of objects of any type?

1.GEOMETRYCOLLECTION

2.MULTIPOINT

3.MULTILINESTRING

4.MULTIPOLYGON

Answer 1

Question :- Which variable is a handle to a database object?

1.$dbh

2.$sth

3.$fh

4.$h

Answer 1

Question :- Which variable when set to 1 would enable foreign key checking for InnoDB tables?

1.error_count

2.identity

3.foreign_key_checks

4.autocommit

Answer 3
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!