Question

MySQL stores the database character set and collation attributes in the file _________

(a) dp.opt

(b) db.opt

(c) db.sv

(d) db.zip

This question was posed to me in my homework.

This intriguing question comes from Selecting, Creating, Dropping and Altering Databases in section Using SQL to Manage Data of MySQL

Answer 1

Right option is (b) db.opt

For explanation I would say: The file named ‘db.opt’ is of a great significance to MySQL, espectially the MySQL server. It stores the database attributes along with the db charset and collation attributes.