MySQL Database Multiple Choice Questions on “Secure Connections”.
1. The number of files that each end of a client/server connection including SSL support use to set up secure communications is __________
a) 0
b) 1
c) 2
d) 3
Answer: d
Clarification: With a MySQL installation that includes SSL support the server and its clients can communicate securely. Each end of a connection uses three files to set up secure communications.
2. What is the TLS protocol?
a) transparent layer security
b) transport layer security
c) transparent level security
d) transport level security
Answer: b
Clarification: MySQL supports encrypted connections between clients and the server using the TLS protocol. It is also referred to as SSL but MySQL does not actually use the SSL protocol for encrypted connections.
3. Which grant table scope columns are case insensitive?
a) Host
b) User
c) Password
d) Db
Answer: a
Clarification: ‘Db’ and ‘Table_name’ values are always treated as case sensitive even though the treatment of database and table names in SQL statements depends on the filesystem case sensitivity of the host.
4. The variable that checks for availability of SSL support is ____________
a) have_ssl
b) has_ssl
c) avail_ssl
d) ssl_avail
Answer: a
Clarification: After the SSL-capable server is started, to verify that it supports SSL, connection is established with ‘mysql’ and the following query is issued: SHOW VARIABLES LIKE ‘have_ssl’.
5. MySQL does provides a date type that has an optional time part.
a) True
b) False
Answer: a
Clarification: In MySQL, there is no data type provided which has an optional time part. The ‘DATE’ type values never have a time part. The ‘DATETIME’ type values must have a time part in them.
6. The function that returns a reference to an array of row values is ______________
a) fetchrow_array()
b) fetchrow_arrayref()
c) fetch()
d) fetchrow_hashref()
Answer: b
Clarification: ‘fetchrow_arrayref()’ returns a reference to an array of row values. The function ‘fetchrow_hashref()’ returns reference to hash of row values. ‘fetch()’ is the same as fetchrow_arrayref().
7. The MySQL server is configurable.
a) True
b) False
Answer: a
Clarification: The MySQL server is highly configurable. Some of the operational characteristics that you can control include which storage engines the server supports, the default character set, and its default time zone.
8. The log in which data changes received from a replication master server are written is _____________
a) error log
b) general query log
c) binary log
d) relay log
Answer: d
Clarification: The Relay Log has the data changes received from a replication master server written in it. The problems encountered during the starting, running or stopping of ‘mysqld’ are written in error log.