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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network

Join The Discussion