Question

The file created by the server to store the database attributes is __________

(a) db.otp

(b) dp.zip

(c) db.opt

(d) db.cls

This question was posed to me in an interview for job.

I would like to ask this question from Selecting, Creating, Dropping and Altering Databases topic in portion Using SQL to Manage Data of MySQL

Answer 1

Right choice is (c) db.opt

Explanation: Whenever a database is created in MySQL, the MySQL server creates a directory with the same name as the database. It creates the file db.opt to store the attributes.