SQL/SQL MCQ SET 10 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


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


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


Question:
The Audit_log_events system variable is of type ________

1.string

2.integer

3.float

4.double


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

1.nesting

2.binding

3.subquerying

4.encapsulating


Question:
The functions in Perl DBI called?

1.functions

2.procedures

3.methods

4.programs


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


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


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


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


Question:
The operator that compares sounds is ________

1.MATCH SOUNDS

2.CHECK SOUNDS

3.SOUNDS LIKE

4.SOUNDS SIMILAR


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


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

1.integer

2.float

3.double

4.string


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


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


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

1.1

2.3

3.5

4.6


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

1.INSERT()

2.INSTR()

3.INSTRING()

4.INFSTR()


Question:
The synonym for last_insert_id session variable is ______

1.insert_id

2.identity

3.sql_auto_is_null

4.sql_big_selects


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

1.$dbh

2.$sth

3.$fh

4.$h


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


Question:
What does CGI stand for?

1.Computer Gateway Interface

2.Common Gateway Interface

3.Computer Generated Interface

4.Common Generated Interface


Question:
What does RTF refer to?

1.Rich Text Format

2.Right Text Format

3.Rich Text Function

4.Right Text Function


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

1.0

2.1

3.-1

4.2


Question:
What is SBR replication?

1.Statement based

2.Row based

3.Column based

4.Table based


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

1.$dbh

2.$sth

3.$fh

4.$h


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

1.-256

2.-128

3.0

4.128


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

1.$rc

2.$rv

3.$rows

4.$ary


Question:
What is the shebang line?

1.#!

2.!#

3.#$

4.$#


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


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

1.mysqldump

2.mysqld

3.mysqlimport

4.mysqlnaive


Question:
What returns a string containing an error message?

1.mysql_error()

2.mysql_errno()

3.mysql_sqlstate()

4.mysql_close()


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


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

1.OpenGSS

2.OpenGIS

3.ClosedGSS

4.ClosedGIS


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

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()


Question:
Which function returns an array of row values?

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()


Question:
Which function returns NULL if expr1 = expr2?

1.CASE

2.IF()

3.IFNULL()

4.NULLIF()


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


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


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

1.GLOBAL

2.SESSION

3.LOCAL

4.DEFAULT


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


Question:
Which module links DBI to the web?

1.CGI.pn

2.CGI.pem

3.CGI.pm

4.CGI.po


Question:
Which of these has special automatic update behavior?

1.DATE

2.TIME

3.TIMESTAMP

4.YEAR


Question:
Which of these is a read only variable?

1.error_count

2.big_tables

3.autocommit

4.foreign_key_checks


Question:
Which operator compares sounds?

1.MATCH SOUNDS

2.CHECK SOUNDS

3.SOUNDS LIKE

4.SOUNDS SIMILAR


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

1.->

2.->>

3.<<

4.>>


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

1.INSERT()

2.INSTR()

3.INSTRING()

4.INFSTR()


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


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

1.GEOMETRYCOLLECTION

2.MULTIPOINT

3.MULTILINESTRING

4.MULTIPOLYGON


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

1.$dbh

2.$sth

3.$fh

4.$h


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


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!