The shebang line is ______
1.#!
2.!#
3.#$
4.$#
A synonym for CHARACTER SET is ______
1.CSET
2.CHSET
3.CHARSET
4.CHCSET
Comparing a known value with NULL results into _______
1.null
2.zero
3.a positive value
4.a negative value
For failure, mysql_query() returns ______
1.0
2.1
3.-1
4.a non-zero
In Perl DBI, functions are called ______
1.functions
2.procedures
3.methods
4.programs
Issuing ‘SELECT’ on a MERGE table is like ______
1.UNION
2.UNION ALL
3.UNION DISTINCT
4.JOIN
mysql_fetch_row() returns ______
1.integer
2.float
3.structure
4.pointer
On failure, ‘mysql_query()’ returns ______
1.0
2.1
3.-1
4.a non-zero value
System variable in MySQL server that enables to configure the SQL mode is ____
1.sql_mode
2.sql_config
3.sql_server
4.sql_enable
The argument to the function mysql_error() is ________
1.integer
2.float
3.structure
4.pointer
The –protocol value ‘TCP’ runs on which operating systems?
1.unix only
2.windows only
3.all
4.none
The default case sensitivity of the database and table names depends on ___________
1.Server SQL mode
2.Operating system of machine
3.Does not depend on anything
4.SQL server
The default path to perl in Unix is ______
1./usr/bin/perl
2./usr/bin
3./usr/perl
4./usr/perl/bin
The embedded server library containing the MySQL server linkable into applications is ______
1.libmysqla
2.libmysqlb
3.libmysqlc
4.libmysqld
The exec_stmt_ssl is written in ______
1.C++
2.C
3.Python
4.Perl
The general statement-issuing routine is _______
1.mysql_real_query()
2.mysql_query_real()
3.mysql_image_query()
4.mysql_query_image()
The generic handle whose meaning depends on context is _____
1.$dbh
2.$sth
3.$fh
4.$h
The key declares that an index in one table is related to that in another is called ______
1.primary
2.secondary
3.foreign
4.cross
The maximum collations a character set can have is ______________
1.0
2.1
3.2
4.more than 1
The name of the option file in Unix is ______
1..my.cnf
2..my.ini
3.my.opt
4.my.opc
The non handle array representing a row of values is ________
1.$rc
2.$rv
3.$rows
4.$ary
The operator that does not perform relative-value comparisons is ________
1.=
2.==
3.<=
4.>=
The Perl DBI is _______
1.database inheritance
2.database integrity
3.database interface
4.database isolation
The statement that makes changes to the global attributes of the database is ______
1.CHANGE
2.ALTER
3.ALTERNATE
4.UPDATE
The statement to remove indexes on tables is _______
1.DROP INDEX
2.DELETE INDEX
3.REMOVE INDEX
4.FLUSH INDEX
The statement used to change the table name is ____
1.RENAME
2.CHANGE
3.CHANGENAME
4.CHANGENM
The statement used to remove indexes on tables is _____
1.DROP INDEX
2.DELETE INDEX
3.REMOVE INDEX
4.FLUSH INDEX
The statement used to select a default database is ______
1.USE
2.CREATE
3.DROP
4.SCHEMA
The variable that is a handle to a database object is ______
1.$dbh
2.$sth
3.$fh
4.$h
To combine multiple retrievals, which keyword is used to write several SELECT statements between them?
1.COMBINE
2.CONCAT
3.JOIN
4.UNION
To see the table structure which command is issued?
1.VIEW tbl_name;
2.SELECT TABLE tbl_name;
3.SELECT tbl_name;
4.DESCRIBE tbl_name;
What allows nesting one select statement into another?
1.nesting
2.binding
3.subquerying
4.encapsulating
What does mysql_real_connect() return if it fails?
1.integer
2.float
3.structure
4.NULL
What enables encrypted connections to be established?
1.exec_stmt_ssl
2.exec_ssl_stmt
3.exec_stmnt_ssl
4.exec_ssl_stmnt
What is the facility that allows nesting one select statement into another?
1.nesting
2.binding
3.subquerying
4.encapsulating
What is the general term for information about databases and the objects in MySQL?
1.datum
2.info
3.record
4.metadata
When building from source, the embedded server library is enabled by _____
1.with-embedded-server
2.with-server-embedded
3.with-embedded-library
4.with-library-embedded
Which character is illegal in naming an unquoted identifier in SQL?
1..
2._
3.$
4.2
Which clause is used to display information that matches a given pattern?
1.WHERE
2.IS
3.SAME
4.LIKE
Which is the command to move the cursor to the beginning of line in mysql input editor?
1.Ctrl-E
2.Ctrl-D
3.Esc-a
4.Ctrl-A
Which is the join in which all the rows from the right table appear in the output irrespective of the content of the other table?
1.CARTESIAN JOIN
2.CROSS JOIN
3.INNER JOIN
4.RIGHT JOIN
Which mode prevents MySQL to perform full checking of date parts?
1.PREVENT_DATE_CHECK
2.STOP_DATES_CHECK
3.ALLOW_DATES_INVALID
4.ALLOW_INVALID_DATES
Which of these operators does not perform relative value comparisons?
1.=
2.==
3.<=
4.>=
Which option enables multiple-statement execution?
1.CLIENT_MULTI_STATEMENTS
2.CLIENT_STATEMENTS_MULTI
3.MULTI_STATEMENTS_CLIENT
4.MULTI_CLIENTS_STATEMENTS
Which option executes all SQL statements in a SQL script irrespective of the number of errors?
1.ensure
2.force
3.violent
4.run
Which statement is used to determine the storage engine for individual tables?
1.SHOW TABLE STATUS
2.SHOW DEFAULT STATUS
3.SHOW STATUS OF TABLE
4.SHOW STATUS TABLE
Which statement is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it?
1.SELECT * FROM `sampledb.member`
2.SELECT * FROM `sampledb`.`member`
3.SELECT * FROM `member`.`sampledb`
4.SELECT * FROM `member.sampledb`
Which table in the ‘INFORMATION_SCHEMA’ stores information about storage engines and server plugins?
1.ENGINES, PLUGINS
2.FILES, PLUGINS
3.PLUGINS, STATISTICS
4.ENGINES, FILES
Which variable is used as a handle to an open file?
1.$dbh
2.$sth
3.$fh
4.$h
Which variable returns code from operations that return true or false?
1.$rc
2.$rv
3.$rows
4.$ary