SQL MCQ Quiz Hub

1. The context in which the privilege ‘CREATE TABLESPACE’ applies is ________
Server administration
Tables
Stored routines
Views

2. The language that is the core for APIs and communication in MySQL is ________
C
C++
Python
Ruby

3. The most general purpose language is _______
C
Perl
Python
PHP

4. The language in which image processing is least simple is ______
PHP
Perl
Python
C

5. The option necessary to compile a C program havin math functions is ____
-lm
-ln
-lp
-lq

6. For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______
multiple-transaction
single-transaction
double-transaction
no-transaction

7. To reload a delimited text data file use ______
mysqldump
mysqld
mysqlimport
mysqlnaive

8. SBR replication is _____
Statement based
Row based
Column based
Table based

9. The library file that contains various portability macros and definitions is ______
my_global.h
my_sys.h
mysql.h
my_local.h

10. The header that should be included first is _____
my_global.h
my_sys.h
mysql.h
my_local.h

11. What is the general statement-issuing routine?
mysql_real_query()
mysql_query_real()
mysql_image_query()
mysql_query_image()

12. The most restrictive among the following is ______
mysql_query()
mysql_real_query()
same
machine dependent

13. The option that specifies the data directory location at server startup is _____
–data
–data_dir
–data-dir
–datadir

14. The datadir variable value can be seen using ______________
SHOW VARIABLES
DISP VARIABLES
CONNECT VARIABLES
SHOW VARIABLE

15. Which data directory subdirectory provides the information used to inspect the internal execution of the server at runtime.
mysql
performance_schema
sys
nbdinfo

16. Encrypted connections can be established using ______________
exec_stmt_ssl
exec_ssl_stmt
exec_stmnt_ssl
exec_ssl_stmnt

17. What is exec_stmt_ssl written in?
C++
C
Python
Perl

18. What is the embedded server library containing the MySQL server linkable into applications?
libmysqla
libmysqlb
libmysqlc
libmysqld

19. What is the embedded server library when building from source enabled by?
with-embedded-server
with-server-embedded
with-embedded-library
with-library-embedded

20. In the database directory of the database each view and trigger object is associated with how many files?
0
1
2
3

21. What is the maximum number of characters allowed for a database name to have?
16
32
64
128

22. The data directory subdirectory that corresponds to the nbdinfo database is ______________
mysql
performance_schema
sys
nbdinfo

23. The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______________
ensure
force
violent
run

24. What is the synonym for CHARACTER SET?
CSET
CHSET
CHARSET
CHCSET

25. What is the statement used to select a default database?
USE
CREATE
DROP
SCHEMA

26. Symlink is an applicable relocation method for ______________
entire data directory
individual database tables
server PID file
log files

27. For which of these is the startup option best suited?
entire data directory
individual database tables
server PID file
individual database directories

28. When relocating an individual table, the table to be relocated should be ______________
MyISAM
InnoDB
TRANSACTION
ENGINE

29. What is the special database that always exists after setting up MySQL on a computer?
sampdb
mysql
information_schema
readme_db

30. In which file are the statements entered in ‘mysql’ saved?
.mysql_queries
queries
mysql_history
history

31. Which command is used to make a script file ‘run_me.sh’ executable?
chmod +e run_me.sh
chmod +a run_me.sh
chmod +y run_me.sh
chmod +x run_me.sh

32. The superuser account of the grant tables in the mysql database is called ______________
super
prime
root
leaf

33. Which script initializes the data directory during installation?
mysql_install_db
mysql_install_dbm
mysql_init_db
mysql_init_dbm

34. Anonymous accounts have user name ______________
root
blank
super
prime

35. What does the default case sensitivity of database and table names depend on?
SQL server
Server SQL mode
Operating system of machine
Does not depend on anything

36. The case sensitive among these is ______________
Stored function name
Stored procedure name
Trigger name
Event name

37. The variable used to set table alias names as non case sensitive is ______________
lower_case_table_names
lower_case_all
lower_case_alias
lower_case_aliases

38. The clause that can be used to sort string values according to a specific collation is ______________
SORT
GROUP
FILTER
COLLATE

39. The statement used to find out which character sets are available is ______________
SHOW CHARACTER SET
SHOW COLLATION
SHOW CHARACTER SETS
SHOW COLLATIONS

40. The error log file has a suffix ______________
.err
.er
.error
.log

41. The option which finds the startup options supported by the server through mysqld is ______________
verbose
vertex
startup
shutdown

42. Server startup can also be done by the ______________
option file
log file
error file
system file

43. The keyword used to create a database is __________
CREATE
SET
SETUP
LINK

44. Which file is created by the server to store the database attributes?
db.otp
dp.zip
db.opt
db.cls

45. What is the default storage engine?
EXAMPLE
ARCHIVE
MyISAM
NDB

46. The name of the format file for a table named my_tbl is __________
my_tbl.fmt
my_tbl.frm
my_tbl.fmr
my_tbl.ftm

47. The server listens on a network port for TCP/IP connections unless started with the option _____
networking
skip-networking
skip-networks
quit-networking

48. Which option is used to specify to the server the IP number of the server host on which the server should listen?
–verbose
–bind-address
–startup
–shutdown

49. The option used to specify the socket file pathname is ______
–socket
–pathtosocket
–path_socket
–socket_pathfile

50. The disk data that the FILES table in INFORMATION_SCHEMA stores is ______
NDB
NBD
NBK
NCD