Examveda

The name of the format file for a table named my_tbl is . . . . . . . .

A. my_tbl.fmt

B. my_tbl.frm

C. my_tbl.fmr

D. my_tbl.ftm

Answer: Option B

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous