‘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
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
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
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
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
The functions in Perl DBI called?
1.functions
2.procedures
3.methods
4.programs
Posted Date:-2021-07-19 04:17:05
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
What is SBR replication?
1.Statement based
2.Row based
3.Column based
4.Table based
Posted Date:-2021-07-19 04:17:05
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
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
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
What is the shebang line?
1.#!
2.!#
3.#$
4.$#
Posted Date:-2021-07-19 04:17:05
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
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
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
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
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
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
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
Which function returns NULL if expr1 = expr2?
1.CASE
2.IF()
3.IFNULL()
4.NULLIF()
Posted Date:-2021-07-19 04:17:05
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
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
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
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
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
Which of these has special automatic update behavior?
1.DATE
2.TIME
3.TIMESTAMP
4.YEAR
Posted Date:-2021-07-19 04:17:05
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
Which operator compares sounds?
1.MATCH SOUNDS
2.CHECK SOUNDS
3.SOUNDS LIKE
4.SOUNDS SIMILAR
Posted Date:-2021-07-19 04:17:05
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
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
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
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
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
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