SQL/SQL MCQ SET 3 Sample Test,Sample questions

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


More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL – Basics
  20. MCQ | SQL – Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!