🧪 SQL MCQ Quiz Hub

1. The users responsible for query processing in database system are ____
Native users
Application programmers
Sophisticated users
Specialized users

2. Select the sequence for how the query mechanism works?
Authentication-> DDL->DML->query optimizer->output
DDL->DML->query optimizer-> Authentication->output
DML->query optimizer-> Authentication-> DDL-> output
All of the mentioned

3. Which clause is used to determine which column to include in the query sets?
SELECT
FROM
WHERE
ORDER BY

4. Which clause is used to Identifies table from which to draw table and how the table should be joined?
FROM
SELECT
ORDER By
WHERE

5. Which clause is used to Filters out unwanted data?
FROM
WHERE
SELECT
ORDER BY

6. Which clause is used to group rows together by common columns values?
SELECT
GROUP BY
FROM
WHERE

7. Which clause is used to filter out unwanted Groups?
HAVING
FROM
WHERE
SELECT

8. Which clause is used to sort the rows of the final result set by one or more columns?
HAVING
ORDER BY
WHERE
FROM

9. Which clause is used to Modify the existing field of the table?
ALTER
FROM
SELECT
MODIFY

10. Which among the following is not a "query clause"?
WHERE
MODIFY
ALTER
FROM

11. "MODIFY" is used with which "Query clause"?
ALTER
FROM
WHERE
ORDER BY

12. What exports table definitions and contents?
mysqldump
mysqladmin
mysqlimport
mysqlexport

13. What loads data files into tables?
mysqldump
mysqladmin
mysqlimport
mysqlexport

14. What performs administrative operations?
mysqldump
mysqladmin
mysqlimport
mysqlexport

15. Which option executes all SQL statements in a SQL script irrespective of the number of errors?
ensure
violent
force
run

16. Which of these is used during MySQL setup?
mysqld_multi
mysql.server
mysqld_safe
comp_err

17. Which of these is not used to connect to the MySQL server?
mysql
mysqladmin
mysqlcheck
mysql_upgrade

18. Which program emulates the client load for a MySQL server?
mysqlslap
mysqldump
mysqladmin
mysqlimport

19. Which language is the core for APIs and communication in MySQL?
C
C++
Python
Ruby

20. The primary programming interface to MySQL is _______
C API
C++ API
Java API
Python API

21. The DBI API for Perl is _____
database interface
database id
database identity
database integrity

22. For which language is the engine specific interface PDO defined?
Python
Perl
PHP
C

23. For which language is the PEAR module used?
Python
Perl
PHP
C

24. The JDBI interface is available for ____
C
C++
Python
Java

25. Which of these is the most general purpose language?
C
Perl
Python
PHP

26. Among the following, for which language is image processing least simple?
PHP
Perl
Python
C

27. The CGI.pm module for website development is a part of _____
Perl
Java
Python
C++

28. For a heavily used program, which of these languages should be preferred?
C
Perl
PHP
Python

29. The protocol CGI is ____
computer graphics interface
common graphics interface
computer gateway interface
common gateway interface

30. Which is the correct decreasing order for highly developed text manipulation capabilities?
Perl, PHP, C
Perl, C, PHP
PHP, Perl, C
C, PHP, Perl

31. Which API provides the lowest level interface to the server?
C API
Perl
PHP
Python

32. Which option is necessary to compile a C program havin math functions?
-lm
-ln
-lp
-lq

33. Which file can be used to execute multiple compile statements?
makefile
dofile
putfile
pushfile

34. Which flag is used to compile client programs that use MySQL header files?
-O
-I
-U
-A

35. The MySQL clients are linked with ____
#NAME?
-cmysqlclient
-dmysqlclient
-vmysqlclient

36. What can be used as an alternative to mysqlconfig?
pkg-config
dkg-config
rkg-config
qkg-config

37. Which of these has a smaller memory footprint?
Perl
PHP
Same
Machine dependent

38. The static C library client in Windows is ____
mysqlclient.lib
mysqlclient.lb
mysqlclient.lm
myclient.lib

39. Which of the following is used on Solaris?
gcc
clang
Sun Studio
FreeBSD

40. Which library file contains various portability macros and definitions?
my_global.h
my_sys.h
mysql.h
my_local.h

41. Which header should be included first?
my_global.h
my_sys.h
mysql.h
my_local.h

42. mysql_init() returns a _____
integer
float
structure
pointer to a structure

43. Which of these can be used in place of MYSQL_SERVER_VERSION?
LIBMYSQL_VERSION
LIBMYSQL_VERSION_ID
MYSQL_VERSION_ID
MYSQL_ID

44. Which of the following can be used interchangeably with MYSQL_VERSION_ID?
LIBMYSQL_VERSION
LIBMYSQL_VERSION_ID
MYSQL_VERSION_ID
MYSQL_ID

45. Which option is supplied to ensure TCP/IP connection to local server?
localhost
host
hostlocal
connectlocal

46. The "protocol value TCP' runs on which operating systems?
all
unix only
windows only
none

47. The SOCKET protocol is permitted on which operating systems?
all
unix only
windows only
none

48. Which of these returns a string containing an error message?
mysql_error()
mysql_errno()
mysql_sqlstate()
mysql_close()

49. Which of the following returns a MySQL-specific numeric code?
mysql_error()
mysql_errno()
mysql_sqlstate()
mysql_close()

50. Which of the following returns an SQLSTATE code?
mysql_error()
mysql_errno()
mysql_sqlstate()
mysql_close()