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