MySQL Database Multiple choice Questions and Answers-MySQL Administration

41.	The datadir variable value can be seen using ______________
a.	SHOW VARIABLES
b.	DISP VARIABLES
c.	CONNECT VARIABLES
d.	SHOW VARIABLE

Discuss

Answer: (a).SHOW VARIABLES

42.	Which data directory subdirectory provides the information used to inspect the internal execution of the server at runtime.
a.	mysql
b.	performance_schema
c.	sys
d.	nbdinfo

Discuss

Answer: (b).performance_schema

43.	Which data directory subdirectory corresponds to the nbdinfo database?
a.	mysql
b.	performance_schema
c.	sys
d.	nbdinfo

Discuss

Answer: (b).performance_schema

44.	Encrypted connections can be established using ______________
a.	exec_stmt_ssl
b.	exec_ssl_stmt
c.	exec_stmnt_ssl
d.	exec_ssl_stmnt

Discuss

Answer: (a).exec_stmt_ssl

45.	What is exec_stmt_ssl written in?
a.	C++
b.	C
c.	Python
d.	Perl

Discuss

Answer: (b).C

46.	What is the embedded server library containing the MySQL server linkable into applications?
a.	libmysqla
b.	libmysqlb
c.	libmysqlc
d.	libmysqld

Discuss

Answer: (d).libmysqld

47.	What is the embedded server library when building from source enabled by?
a.	–with-embedded-server
b.	–with-server-embedded
c.	–with-embedded-library
d.	–with-library-embedded

Discuss

Answer: (a).–with-embedded-server

48.	Multiple statement execution is not enabled by default.
a.	True
b.	False
c.	May be True or False
d.	Can't say

Discuss

Answer: (a).True

49.	An embedded application includes the server side and client side.
a.	True
b.	False
c.	May be True or False
d.	Can't say

Discuss

Answer: (a).True

50.	Each database has a data directory located under database directory.
a.	True
b.	False
c.	May be True or False
d.	Can't say

Discuss

Answer: (b).False