Q.1
What enables encrypted connections to be established?
  • a) exec_stmt_ssl
  • b) exec_ssl_stmt
  • c) exec_stmnt_ssl
  • d) exec_ssl_stmnt
Q.2
The exec_stmt_ssl is written in _______________
  • a) C++
  • b) C
  • c) Python
  • d) Perl
Q.3
On failure, ‘mysql_query()’ returns _______________
  • a) 0
  • b) 1
  • c) -1
  • d) a non-zero value
Q.4
Input handling cannot be customized with MySQL.
  • a) True
  • b) False
Q.5
By default, MySQL does not clip out of range numeric values to the nearest fit value.
  • a) True
  • b) False
Q.6
Which mode prevents MySQL to perform full checking of date parts?
  • a) PREVENT_DATE_CHECK
  • b) STOP_DATES_CHECK
  • c) ALLOW_DATES_INVALID
  • d) ALLOW_INVALID_DATES
Q.7
Which statement is used to determine the storage engine for individual tables?
  • a) SHOW TABLE STATUS
  • b) SHOW DEFAULT STATUS
  • c) SHOW STATUS OF TABLE
  • d) SHOW STATUS TABLE
Q.8
Which table in the ‘INFORMATION_SCHEMA’ stores information about storage engines and server plugins?
  • a) ENGINES, PLUGINS
  • b) FILES, PLUGINS
  • c) PLUGINS, STATISTICS
  • d) ENGINES, FILES
Q.9
How many of the following is (are) considered as a special character by ‘mysql_real_escape_string()’?
  • a) 3
  • b) 1
  • c) 2
  • d) 0
0 h : 0 m : 1 s