‘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
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
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
The Audit_log_events system variable is of type ________
1.string
2.integer
3.float
4.double
The facility that allows nesting one select statement into another is ________
1.nesting
2.binding
3.subquerying
4.encapsulating
The functions in Perl DBI called?
1.functions
2.procedures
3.methods
4.programs
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
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
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
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
The operator that compares sounds is ________
1.MATCH SOUNDS
2.CHECK SOUNDS
3.SOUNDS LIKE
4.SOUNDS SIMILAR
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
The permitted value type for the variable ‘character_set_client’ is ________
1.integer
2.float
3.double
4.string
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
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
The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____
1.1
2.3
3.5
4.6
The string function that returns the index of the first occurrence of substring is ______
1.INSERT()
2.INSTR()
3.INSTRING()
4.INFSTR()
The synonym for last_insert_id session variable is ______
1.insert_id
2.identity
3.sql_auto_is_null
4.sql_big_selects
The variable used as a handle to an open file is _______
1.$dbh
2.$sth
3.$fh
4.$h
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
What does CGI stand for?
1.Computer Gateway Interface
2.Common Gateway Interface
3.Computer Generated Interface
4.Common Generated Interface
What does RTF refer to?
1.Rich Text Format
2.Right Text Format
3.Rich Text Function
4.Right Text Function
What does the AUTO_INCREMENT sequences begin at by default?
1.0
2.1
3.-1
4.2
What is SBR replication?
1.Statement based
2.Row based
3.Column based
4.Table based
What is the generic handle whose meaning depends on context?
1.$dbh
2.$sth
3.$fh
4.$h
What is the minimum value stored by signed TINYINT?
1.-256
2.-128
3.0
4.128
What is the non handle array representing a row of values?
1.$rc
2.$rv
3.$rows
4.$ary
What is the shebang line?
1.#!
2.!#
3.#$
4.$#
What is the synonym for last_insert_id session variable?
1.insert_id
2.identity
3.sql_auto_is_null
4.sql_big_selects
What is used to reload a delimited text data file?
1.mysqldump
2.mysqld
3.mysqlimport
4.mysqlnaive
What returns a string containing an error message?
1.mysql_error()
2.mysql_errno()
3.mysql_sqlstate()
4.mysql_close()
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
Which classes does spatial data types in MySQL correspond to?
1.OpenGSS
2.OpenGIS
3.ClosedGSS
4.ClosedGIS
Which function returns a reference to hash of row values?
1.fetchrow_array()
2.fetchrow_arrayref()
3.fetch()
4.fetchrow_hashref()
Which function returns an array of row values?
1.fetchrow_array()
2.fetchrow_arrayref()
3.fetch()
4.fetchrow_hashref()
Which function returns NULL if expr1 = expr2?
1.CASE
2.IF()
3.IFNULL()
4.NULLIF()
Which is the header that should be included first?
1.my_global.h
2.my_sys.h
3.mysql.h
4.my_local.h
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
Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?
1.GLOBAL
2.SESSION
3.LOCAL
4.DEFAULT
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
Which module links DBI to the web?
1.CGI.pn
2.CGI.pem
3.CGI.pm
4.CGI.po
Which of these has special automatic update behavior?
1.DATE
2.TIME
3.TIMESTAMP
4.YEAR
Which of these is a read only variable?
1.error_count
2.big_tables
3.autocommit
4.foreign_key_checks
Which operator compares sounds?
1.MATCH SOUNDS
2.CHECK SOUNDS
3.SOUNDS LIKE
4.SOUNDS SIMILAR
Which operator is used to return value from JSON columns after evaluating the path and unquoting the result?
1.->
2.->>
3.<<
4.>>
Which string function returns the index of the first occurrence of substring?
1.INSERT()
2.INSTR()
3.INSTRING()
4.INFSTR()
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
Which type can store a collection of objects of any type?
1.GEOMETRYCOLLECTION
2.MULTIPOINT
3.MULTILINESTRING
4.MULTIPOLYGON
Which variable is a handle to a database object?
1.$dbh
2.$sth
3.$fh
4.$h
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