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.
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