"MODIFY" is used with which "Query clause"?
1.ALTER
2.FROM
3.WHERE
4.ORDER BY
Among the following, for which language is image processing least simple?
1.PHP
2.Perl
3.Python
4.C
For a heavily used program, which of these languages should be preferred?
1.C
2.Perl
3.PHP
4.Python
For which language is the engine specific interface PDO defined?
1.Python
2.Perl
3.PHP
4.C
For which language is the PEAR module used?
1.Python
2.Perl
3.PHP
4.C
mysql_init() returns a _____
1.integer
2.float
3.structure
4.pointer to a structure
Select the sequence for how the query mechanism works?
1.Authentication-> DDL->DML->query optimizer->output
2.DDL->DML->query optimizer-> Authentication->output
3.DML->query optimizer-> Authentication-> DDL-> output
4.All of the mentioned
The "protocol value TCP' runs on which operating systems?
1.all
2.unix only
3.windows only
4.none
The CGI.pm module for website development is a part of _____
1.Perl
2.Java
3.Python
4.C++
The DBI API for Perl is _____
1.database interface
2.database id
3.database identity
4.database integrity
The JDBI interface is available for ____
1.C
2.C++
3.Python
4.Java
The MySQL clients are linked with ____
1.#NAME?
2.-cmysqlclient
3.-dmysqlclient
4.-vmysqlclient
The primary programming interface to MySQL is _______
1.C API
2.C++ API
3.Java API
4.Python API
The protocol CGI is ____
1.computer graphics interface
2.common graphics interface
3.computer gateway interface
4.common gateway interface
The SOCKET protocol is permitted on which operating systems?
1.all
2.unix only
3.windows only
4.none
The static C library client in Windows is ____
1.mysqlclient.lib
2.mysqlclient.lb
3.mysqlclient.lm
4.myclient.lib
The users responsible for query processing in database system are ____
1.Native users
2.Application programmers
3.Sophisticated users
4.Specialized users
What can be used as an alternative to mysqlconfig?
1.pkg-config
2.dkg-config
3.rkg-config
4.qkg-config
What exports table definitions and contents?
1.mysqldump
2.mysqladmin
3.mysqlimport
4.mysqlexport
What loads data files into tables?
1.mysqldump
2.mysqladmin
3.mysqlimport
4.mysqlexport
What performs administrative operations?
1.mysqldump
2.mysqladmin
3.mysqlimport
4.mysqlexport
Which among the following is not a "query clause"?
1.WHERE
2.MODIFY
3.ALTER
4.FROM
Which API provides the lowest level interface to the server?
1.C API
2.Perl
3.PHP
4.Python
Which clause is used to determine which column to include in the query sets?
1.SELECT
2.FROM
3.WHERE
4.ORDER BY
Which clause is used to filter out unwanted Groups?
1.HAVING
2.FROM
3.WHERE
4.SELECT
Which clause is used to Filters out unwanted data?
1.FROM
2.WHERE
3.SELECT
4.ORDER BY
Which clause is used to group rows together by common columns values?
1.SELECT
2.GROUP BY
3.FROM
4.WHERE
Which clause is used to Identifies table from which to draw table and how the table should be joined?
1.FROM
2.SELECT
3.ORDER By
4.WHERE
Which clause is used to Modify the existing field of the table?
1.ALTER
2.FROM
3.SELECT
4.MODIFY
Which clause is used to sort the rows of the final result set by one or more columns?
1.HAVING
2.ORDER BY
3.WHERE
4.FROM
Which file can be used to execute multiple compile statements?
1.makefile
2.dofile
3.putfile
4.pushfile
Which flag is used to compile client programs that use MySQL header files?
1.-O
2.-I
3.-U
4.-A
Which header should be included first?
1.my_global.h
2.my_sys.h
3.mysql.h
4.my_local.h
Which is the correct decreasing order for highly developed text manipulation capabilities?
1.Perl, PHP, C
2.Perl, C, PHP
3.PHP, Perl, C
4.C, PHP, Perl
Which language is the core for APIs and communication in MySQL?
1.C
2.C++
3.Python
4.Ruby
Which library file contains various portability macros and definitions?
1.my_global.h
2.my_sys.h
3.mysql.h
4.my_local.h
Which of the following can be used interchangeably with MYSQL_VERSION_ID?
1.LIBMYSQL_VERSION
2.LIBMYSQL_VERSION_ID
3.MYSQL_VERSION_ID
4.MYSQL_ID
Which of the following is used on Solaris?
1.gcc
2.clang
3.Sun Studio
4.FreeBSD
Which of the following returns a MySQL-specific numeric code?
1.mysql_error()
2.mysql_errno()
3.mysql_sqlstate()
4.mysql_close()
Which of the following returns an SQLSTATE code?
1.mysql_error()
2.mysql_errno()
3.mysql_sqlstate()
4.mysql_close()
Which of these can be used in place of MYSQL_SERVER_VERSION?
1.LIBMYSQL_VERSION
2.LIBMYSQL_VERSION_ID
3.MYSQL_VERSION_ID
4.MYSQL_ID
Which of these has a smaller memory footprint?
1.Perl
2.PHP
3.Same
4.Machine dependent
Which of these is not used to connect to the MySQL server?
1.mysql
2.mysqladmin
3.mysqlcheck
4.mysql_upgrade
Which of these is the most general purpose language?
1.C
2.Perl
3.Python
4.PHP
Which of these is used during MySQL setup?
1.mysqld_multi
2.mysql.server
3.mysqld_safe
4.comp_err
Which of these returns a string containing an error message?
1.mysql_error()
2.mysql_errno()
3.mysql_sqlstate()
4.mysql_close()
Which option executes all SQL statements in a SQL script irrespective of the number of errors?
1.ensure
2.violent
3.force
4.run
Which option is necessary to compile a C program havin math functions?
1.-lm
2.-ln
3. -lp
4.-lq
Which option is supplied to ensure TCP/IP connection to local server?
1.localhost
2.host
3.hostlocal
4.connectlocal
Which program emulates the client load for a MySQL server?
1.mysqlslap
2.mysqldump
3.mysqladmin
4.mysqlimport