Q759
The name of the format file for a table named my_tbl is . . . . . . . .
A.
my_tbl.fmt
B.
my_tbl.frm
AnswerC.
my_tbl.fmr
D.
my_tbl.ftm
Answer: Option B
Solution
Answer: Option B
Solution:
This question is about how MySQL stores table information on your computer. Imagine each table in your database as a set of drawers, holding your data.
To know where to find the drawers (the data), MySQL uses a special file called a format file.
This file tells MySQL the structure of your table:
* What are the column names?
* What types of data are stored in each column?
* How big are the columns?
Out of the choices given, the correct format file name is:
Option B: my_tbl.frm
The other options are not used by MySQL.