Question :- "MODIFY" is used with which "Query clause"?

1.ALTER

2.FROM

3.WHERE

4.ORDER BY

Question :- Among the following, for which language is image processing least simple?

1.PHP

2.Perl

3.Python

4.C

Question :- For a heavily used program, which of these languages should be preferred?

1.C

2.Perl

3.PHP

4.Python

Question :- For which language is the engine specific interface PDO defined?

1.Python

2.Perl

3.PHP

4.C

Question :- For which language is the PEAR module used?

1.Python

2.Perl

3.PHP

4.C

Question :- mysql_init() returns a _____

1.integer

2.float

3.structure

4.pointer to a structure

Question :- 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

Question :- The "protocol value TCP' runs on which operating systems?

1.all

2.unix only

3.windows only

4.none

Question :- The CGI.pm module for website development is a part of _____

1.Perl

2.Java

3.Python

4.C++

Question :- The DBI API for Perl is _____

1.database interface

2.database id

3.database identity

4.database integrity

Question :- The JDBI interface is available for ____

1.C

2.C++

3.Python

4.Java

Question :- The MySQL clients are linked with ____

1.#NAME?

2.-cmysqlclient

3.-dmysqlclient

4.-vmysqlclient

Question :- The primary programming interface to MySQL is _______

1.C API

2.C++ API

3.Java API

4.Python API

Question :- The protocol CGI is ____

1.computer graphics interface

2.common graphics interface

3.computer gateway interface

4.common gateway interface

Question :- The SOCKET protocol is permitted on which operating systems?

1.all

2.unix only

3.windows only

4.none

Question :- The static C library client in Windows is ____

1.mysqlclient.lib

2.mysqlclient.lb

3.mysqlclient.lm

4.myclient.lib

Question :- The users responsible for query processing in database system are ____

1.Native users

2.Application programmers

3.Sophisticated users

4.Specialized users

Question :- What can be used as an alternative to mysqlconfig?

1.pkg-config

2.dkg-config

3.rkg-config

4.qkg-config

Question :- What exports table definitions and contents?

1.mysqldump

2.mysqladmin

3.mysqlimport

4.mysqlexport

Question :- What loads data files into tables?

1.mysqldump

2.mysqladmin

3.mysqlimport

4.mysqlexport

Question :- What performs administrative operations?

1.mysqldump

2.mysqladmin

3.mysqlimport

4.mysqlexport

Question :- Which among the following is not a "query clause"?

1.WHERE

2.MODIFY

3.ALTER

4.FROM

Question :- Which API provides the lowest level interface to the server?

1.C API

2.Perl

3.PHP

4.Python

Question :- Which clause is used to determine which column to include in the query sets?

1.SELECT

2.FROM

3.WHERE

4.ORDER BY

Question :- Which clause is used to filter out unwanted Groups?

1.HAVING

2.FROM

3.WHERE

4.SELECT

Question :- Which clause is used to Filters out unwanted data?

1.FROM

2.WHERE

3.SELECT

4.ORDER BY

Question :- Which clause is used to group rows together by common columns values?

1.SELECT

2.GROUP BY

3.FROM

4.WHERE

Question :- 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

Question :- Which clause is used to Modify the existing field of the table?

1.ALTER

2.FROM

3.SELECT

4.MODIFY

Question :- 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

Question :- Which file can be used to execute multiple compile statements?

1.makefile

2.dofile

3.putfile

4.pushfile

Question :- Which flag is used to compile client programs that use MySQL header files?

1.-O

2.-I

3.-U

4.-A

Question :- Which header should be included first?

1.my_global.h

2.my_sys.h

3.mysql.h

4.my_local.h

Question :- 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

Question :- Which language is the core for APIs and communication in MySQL?

1.C

2.C++

3.Python

4.Ruby

Question :- Which library file contains various portability macros and definitions?

1.my_global.h

2.my_sys.h

3.mysql.h

4.my_local.h

Question :- 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

Question :- Which of the following is used on Solaris?

1.gcc

2.clang

3.Sun Studio

4.FreeBSD

Question :- Which of the following returns a MySQL-specific numeric code?

1.mysql_error()

2.mysql_errno()

3.mysql_sqlstate()

4.mysql_close()

Question :- Which of the following returns an SQLSTATE code?

1.mysql_error()

2.mysql_errno()

3.mysql_sqlstate()

4.mysql_close()

Question :- 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

Question :- Which of these has a smaller memory footprint?

1.Perl

2.PHP

3.Same

4.Machine dependent

Question :- Which of these is not used to connect to the MySQL server?

1.mysql

2.mysqladmin

3.mysqlcheck

4.mysql_upgrade

Question :- Which of these is the most general purpose language?

1.C

2.Perl

3.Python

4.PHP

Question :- Which of these is used during MySQL setup?

1.mysqld_multi

2.mysql.server

3.mysqld_safe

4.comp_err

Question :- Which of these returns a string containing an error message?

1.mysql_error()

2.mysql_errno()

3.mysql_sqlstate()

4.mysql_close()

Question :- Which option executes all SQL statements in a SQL script irrespective of the number of errors?

1.ensure

2.violent

3.force

4.run

Question :- Which option is necessary to compile a C program havin math functions?

1.-lm

2.-ln

3. -lp

4.-lq

Question :- Which option is supplied to ensure TCP/IP connection to local server?

1.localhost

2.host

3.hostlocal

4.connectlocal

Question :- Which program emulates the client load for a MySQL server?

1.mysqlslap

2.mysqldump

3.mysqladmin

4.mysqlimport