Vidyalelo
MySQL · Q759

MySQL

Programming · MySQL · question 759

Q759

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

A.
my_tbl.fmt
B.
my_tbl.frm
Answer
C.
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.