Question

In the database directory of the database each view and trigger object is associated with how many files?

(a) 0

(b) 1

(c) 2

(d) 3

This question was posed to me at a job interview.

My question comes from Structure of the Data Directory topic in chapter MySQL Data Directory of MySQL

Answer 1

Right option is (b) 1

Easy explanation: Each view and trigger object is associated with one file in the database directory of the database containing that object. A view consists of a .frm file that contains the view definition.