adplus-dvertising
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

Page 5 of 18