MySQL Questions and Answers – Setting Up Secure Connections

This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Setting Up Secure Connections”.

1. How many files does each end of a client/server connection including SSL support use to set up secure communications?
a) 0
b) 1
c) 2
d) 3
View Answer

Answer: d
Explanation: 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. The TLS protocol is _____________
a) transparent layer security
b) transport layer security
c) transparent level security
d) transport level security
View Answer

Answer: b
Explanation: 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. The grant table scope columns that is case insensitive is _____________
a) Host
b) User
c) Password
d) Db
View Answer

Answer: a
Explanation: ‘Db’ and ‘Table_name’ values are always treated as case sensitive even though treatment of database and table names in SQL statements depends on the filesystem case sensitivity of the host.
advertisement
advertisement

4. Which variable checks for the availability of SSL support?
a) have_ssl
b) has_ssl
c) avail_ssl
d) ssl_avail
View Answer

Answer: a
Explanation: 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 not provide a date type that has an optional time part.
a) True
b) False
View Answer

Answer: a
Explanation: 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.
Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

6. What is the best datatype for a column that is expected to store values up to 2 million?
a) SMALLINT
b) TINYINT
c) MEDIUMINT
d) BIGINT
View Answer

Answer: d
Explanation: The different numeric types used in MySQL are used to store a different range of values. To store values of the order of a million, the MEDIUMINT or BIGINT datatype is sufficient.

7. The datatype that stores the longest length of strings is ______________
a) CHAR
b) VARCHAR
c) TINYTEXT
d) TEXT
View Answer

Answer: d
Explanation: In MySQL, the different string datatypes are used to store different lenghts of the string. Here, the length would refer to the number of characters in the string. TEXT stores longer strings.
advertisement

8. The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is __________
a) good
b) bad
c) illegal
d) fare
View Answer

Answer: b
Explanation: The security context is bad if a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access to that data as its definer.

Sanfoundry Global Education & Learning Series – MySQL Database.

advertisement

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.