Question 63: What is the absolute path of e1tst.frm?

See the following example:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| iff                |
| mysql              |
| test               |
| tt                 |
| tt3                |
+--------------------+
6 rows in set (0.02 sec)

mysql> show global variables like 'datadir';
+---------------+----------------------------------------+
| Variable_name | Value                                  |
+---------------+----------------------------------------+
| datadir       | c:\mysql-noinstall-5.0.51b-win32\data\ |
+---------------+----------------------------------------+
1 row in set (0.00 sec)

mysql> show table status from tt3;
+------------+--------+---------+------------+--------+- .
| Name       | Engine | Version | Row_format | Rows   | A .
+------------+--------+---------+------------+--------+--- .
| e1tst      | MyISAM |      10 | Fixed      | 100000 |   .
| e2tst      | MyISAM |      10 | Dynamic    |     10 | .
| egen       | MyISAM |      10 | Fixed      |     10 | .
| r_date_dim | MyISAM |      10 | Dynamic    |   1000 | .
| rgen       | MyISAM |      10 | Fixed      |     10 |    .
+------------+--------+---------+------------+--------+---- .
5 rows in set (0.06 sec)

 
What is the absolute path of e1tst.frm?

a) c:\mysql-noinstall-5.0.51b-win32\data\mysql\tt3\e1tst.frm
b) c:\mysql-noinstall-5.0.51b-win32\data\tt3\e1tst.frm
c) c:\mysql-noinstall-5.0.51b-win32\data\e1tst.frm
d) c:\data\databases\tt3\e1tst.frm

 
[ MySQL Architecture (10%) - How MySQL uses Disk Space ]