The shebang line is ______
1.#!
2.!#
3.#$
4.$#
Posted Date:-2021-07-19 04:13:06
A synonym for CHARACTER SET is ______
1.CSET
2.CHSET
3.CHARSET
4.CHCSET
Posted Date:-2021-07-19 04:13:06
Comparing a known value with NULL results into _______
1.null
2.zero
3.a positive value
4.a negative value
Posted Date:-2021-07-19 04:13:06
For failure, mysql_query() returns ______
1.0
2.1
3.-1
4.a non-zero
Posted Date:-2021-07-19 04:13:06
In Perl DBI, functions are called ______
1.functions
2.procedures
3.methods
4.programs
Posted Date:-2021-07-19 04:13:06
Issuing ‘SELECT’ on a MERGE table is like ______
1.UNION
2.UNION ALL
3.UNION DISTINCT
4.JOIN
Posted Date:-2021-07-19 04:13:06
mysql_fetch_row() returns ______
1.integer
2.float
3.structure
4.pointer
Posted Date:-2021-07-19 04:13:06
On failure, ‘mysql_query()’ returns ______
1.0
2.1
3.-1
4.a non-zero value
Posted Date:-2021-07-19 04:13:06
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
Posted Date:-2021-07-19 04:13:06
The argument to the function mysql_error() is ________
1.integer
2.float
3.structure
4.pointer
Posted Date:-2021-07-19 04:13:06
The –protocol value ‘TCP’ runs on which operating systems?
1.unix only
2.windows only
3.all
4.none
Posted Date:-2021-07-19 04:13:06
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
Posted Date:-2021-07-19 04:13:06
The default path to perl in Unix is ______
1./usr/bin/perl
2./usr/bin
3./usr/perl
4./usr/perl/bin
Posted Date:-2021-07-19 04:13:06
The embedded server library containing the MySQL server linkable into applications is ______
1.libmysqla
2.libmysqlb
3.libmysqlc
4.libmysqld
Posted Date:-2021-07-19 04:13:06
The exec_stmt_ssl is written in ______
1.C++
2.C
3.Python
4.Perl
Posted Date:-2021-07-19 04:13:06
The general statement-issuing routine is _______
1.mysql_real_query()
2.mysql_query_real()
3.mysql_image_query()
4.mysql_query_image()
Posted Date:-2021-07-19 04:13:06
The generic handle whose meaning depends on context is _____
1.$dbh
2.$sth
3.$fh
4.$h
Posted Date:-2021-07-19 04:13:06
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
Posted Date:-2021-07-19 04:13:06
The maximum collations a character set can have is ______________
1.0
2.1
3.2
4.more than 1
Posted Date:-2021-07-19 04:13:06
The name of the option file in Unix is ______
1..my.cnf
2..my.ini
3.my.opt
4.my.opc
Posted Date:-2021-07-19 04:13:06
The non handle array representing a row of values is ________
1.$rc
2.$rv
3.$rows
4.$ary
Posted Date:-2021-07-19 04:13:06
The operator that does not perform relative-value comparisons is ________
1.=
2.==
3.<=
4.>=
Posted Date:-2021-07-19 04:13:06
The Perl DBI is _______
1.database inheritance
2.database integrity
3.database interface
4.database isolation
Posted Date:-2021-07-19 04:13:06
The statement that makes changes to the global attributes of the database is ______
1.CHANGE
2.ALTER
3.ALTERNATE
4.UPDATE
Posted Date:-2021-07-19 04:13:06
The statement to remove indexes on tables is _______
1.DROP INDEX
2.DELETE INDEX
3.REMOVE INDEX
4.FLUSH INDEX
Posted Date:-2021-07-19 04:13:06
The statement used to change the table name is ____
1.RENAME
2.CHANGE
3.CHANGENAME
4.CHANGENM
Posted Date:-2021-07-19 04:13:06
The statement used to remove indexes on tables is _____
1.DROP INDEX
2.DELETE INDEX
3.REMOVE INDEX
4.FLUSH INDEX
Posted Date:-2021-07-19 04:13:06
The statement used to select a default database is ______
1.USE
2.CREATE
3.DROP
4.SCHEMA
Posted Date:-2021-07-19 04:13:06
The variable that is a handle to a database object is ______
1.$dbh
2.$sth
3.$fh
4.$h
Posted Date:-2021-07-19 04:13:06
To combine multiple retrievals, which keyword is used to write several SELECT statements between them?
1.COMBINE
2.CONCAT
3.JOIN
4.UNION
Posted Date:-2021-07-19 04:13:06
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;
Posted Date:-2021-07-19 04:13:06
What allows nesting one select statement into another?
1.nesting
2.binding
3.subquerying
4.encapsulating
Posted Date:-2021-07-19 04:13:06
What does mysql_real_connect() return if it fails?
1.integer
2.float
3.structure
4.NULL
Posted Date:-2021-07-19 04:13:06
What enables encrypted connections to be established?
1.exec_stmt_ssl
2.exec_ssl_stmt
3.exec_stmnt_ssl
4.exec_ssl_stmnt
Posted Date:-2021-07-19 04:13:06
What is the facility that allows nesting one select statement into another?
1.nesting
2.binding
3.subquerying
4.encapsulating
Posted Date:-2021-07-19 04:13:06
What is the general term for information about databases and the objects in MySQL?
1.datum
2.info
3.record
4.metadata
Posted Date:-2021-07-19 04:13:06
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
Posted Date:-2021-07-19 04:13:06
Which character is illegal in naming an unquoted identifier in SQL?
1..
2._
3.$
4.2
Posted Date:-2021-07-19 04:13:06
Which clause is used to display information that matches a given pattern?
1.WHERE
2.IS
3.SAME
4.LIKE
Posted Date:-2021-07-19 04:13:06
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
Posted Date:-2021-07-19 04:13:06
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
Posted Date:-2021-07-19 04:13:06
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
Posted Date:-2021-07-19 04:13:06
Which of these operators does not perform relative value comparisons?
1.=
2.==
3.<=
4.>=
Posted Date:-2021-07-19 04:13:06
Which option enables multiple-statement execution?
1.CLIENT_MULTI_STATEMENTS
2.CLIENT_STATEMENTS_MULTI
3.MULTI_STATEMENTS_CLIENT
4.MULTI_CLIENTS_STATEMENTS
Posted Date:-2021-07-19 04:13:06
Which option executes all SQL statements in a SQL script irrespective of the number of errors?
1.ensure
2.force
3.violent
4.run
Posted Date:-2021-07-19 04:13:06
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
Posted Date:-2021-07-19 04:13:06
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`
Posted Date:-2021-07-19 04:13:06
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
Posted Date:-2021-07-19 04:13:06
Which variable is used as a handle to an open file?
1.$dbh
2.$sth
3.$fh
4.$h
Posted Date:-2021-07-19 04:13:06
Which variable returns code from operations that return true or false?
1.$rc
2.$rv
3.$rows
4.$ary
Posted Date:-2021-07-19 04:13:06