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