Database Fundamentals — Question 142

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?

Answer options

• A. mysql_tzinfo_to_sql
• B. mysql_time_to_sql
• C. mysql_timezone_to_sql
• D. mysql_tz_to_sql

Correct answer: A

Explanation

The correct answer is A, mysql_tzinfo_to_sql, as it specifically serves the purpose of converting Unix time zone files into SQL for MySQL databases. The other options do not exist or do not fulfill this function, making them incorrect.