Examveda

What is the name of the format file for a table named my_tbl?

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 asking about the file format used to store the definition of a table named "my_tbl" in MySQL.

The correct answer is Option B: my_tbl.frm.

Here's why:
* .frm stands for "File Reference Management".
* This file contains the table's structure, including its column definitions, data types, and constraints.
* It doesn't hold any actual data, just the blueprint for the table.
The other options are incorrect.
Let's break down why the other options are wrong:
* Option A: my_tbl.fmt - There's no file format in MySQL called ".fmt" related to table definitions.
* Option C: my_tbl.fmr - Similar to ".fmt", there's no file format called ".fmr" used for storing table structures.
* Option D: my_tbl.ftm - This is not a standard file format used in MySQL for table definitions.
So, remember that the file format for a table definition in MySQL is always .frm.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous