SQL/SQL%20MCQ%20SET%2010 Sample Test,Sample questions

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

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


Question:
The Audit_log_events system variable is of type ________

1.string

2.integer

3.float

4.double

Posted Date:-2021-07-19 04:17:05


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

1.nesting

2.binding

3.subquerying

4.encapsulating

Posted Date:-2021-07-19 04:17:05


Question:
The functions in Perl DBI called?

1.functions

2.procedures

3.methods

4.programs

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


Question:
The operator that compares sounds is ________

1.MATCH SOUNDS

2.CHECK SOUNDS

3.SOUNDS LIKE

4.SOUNDS SIMILAR

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

1.integer

2.float

3.double

4.string

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

1.1

2.3

3.5

4.6

Posted Date:-2021-07-19 04:17:05


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-19 04:17:05


Question:
The synonym for last_insert_id session variable is ______

1.insert_id

2.identity

3.sql_auto_is_null

4.sql_big_selects

Posted Date:-2021-07-19 04:17:05


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

1.$dbh

2.$sth

3.$fh

4.$h

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


Question:
What does CGI stand for?

1.Computer Gateway Interface

2.Common Gateway Interface

3.Computer Generated Interface

4.Common Generated Interface

Posted Date:-2021-07-19 04:17:05


Question:
What does RTF refer to?

1.Rich Text Format

2.Right Text Format

3.Rich Text Function

4.Right Text Function

Posted Date:-2021-07-19 04:17:05


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

1.0

2.1

3.-1

4.2

Posted Date:-2021-07-19 04:17:05


Question:
What is SBR replication?

1.Statement based

2.Row based

3.Column based

4.Table based

Posted Date:-2021-07-19 04:17:05


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

1.$dbh

2.$sth

3.$fh

4.$h

Posted Date:-2021-07-19 04:17:05


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

1.-256

2.-128

3.0

4.128

Posted Date:-2021-07-19 04:17:05


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

1.$rc

2.$rv

3.$rows

4.$ary

Posted Date:-2021-07-19 04:17:05


Question:
What is the shebang line?

1.#!

2.!#

3.#$

4.$#

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

1.mysqldump

2.mysqld

3.mysqlimport

4.mysqlnaive

Posted Date:-2021-07-19 04:17:05


Question:
What returns a string containing an error message?

1.mysql_error()

2.mysql_errno()

3.mysql_sqlstate()

4.mysql_close()

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

1.OpenGSS

2.OpenGIS

3.ClosedGSS

4.ClosedGIS

Posted Date:-2021-07-19 04:17:05


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

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Posted Date:-2021-07-19 04:17:05


Question:
Which function returns an array of row values?

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Posted Date:-2021-07-19 04:17:05


Question:
Which function returns NULL if expr1 = expr2?

1.CASE

2.IF()

3.IFNULL()

4.NULLIF()

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

1.GLOBAL

2.SESSION

3.LOCAL

4.DEFAULT

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


Question:
Which module links DBI to the web?

1.CGI.pn

2.CGI.pem

3.CGI.pm

4.CGI.po

Posted Date:-2021-07-19 04:17:05


Question:
Which of these has special automatic update behavior?

1.DATE

2.TIME

3.TIMESTAMP

4.YEAR

Posted Date:-2021-07-19 04:17:05


Question:
Which of these is a read only variable?

1.error_count

2.big_tables

3.autocommit

4.foreign_key_checks

Posted Date:-2021-07-19 04:17:05


Question:
Which operator compares sounds?

1.MATCH SOUNDS

2.CHECK SOUNDS

3.SOUNDS LIKE

4.SOUNDS SIMILAR

Posted Date:-2021-07-19 04:17:05


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

1.->

2.->>

3.<<

4.>>

Posted Date:-2021-07-19 04:17:05


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

1.INSERT()

2.INSTR()

3.INSTRING()

4.INFSTR()

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


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

1.GEOMETRYCOLLECTION

2.MULTIPOINT

3.MULTILINESTRING

4.MULTIPOLYGON

Posted Date:-2021-07-19 04:17:05


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

1.$dbh

2.$sth

3.$fh

4.$h

Posted Date:-2021-07-19 04:17:05


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

Posted Date:-2021-07-19 04:17:05


More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL Basics
  20. MCQ | SQL Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
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!