Which of the following scripts is used to convert Unix-type zone files into SQL statements, and loads
the time zone tables in a mysql database?
A.
mysql_tzinfo_to_sql
B.
mysql_time_to_sql
C.
mysql_timezone_to_sql
D.
mysql_tz_to_sql
Explanation:
mysql_tzinfo_to_sql script converts the Unix-type zone files into SQL statements and loads time
zone tables in the mysql database. It is used
on systems that have a zoneinfo database. A zoneinfo database is a set of files describing time zones.
Answer C, D, and B are incorrect. No such scripts are available in a MySQL database.
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database.