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.
mysql_tzinfo_to_sql is a utility that is used to load time zones on systems that have a zoneinfo database