Microsoft
98-364 · Question #32
You are the database administrator for a MySQL database. The database server is installed on a Unix system. The time zone files for the system are located at /usr/share/zoneinfo. You need to ensure…
The correct answer is D. shell> mysql_tzinfo_to_sql /ust/share/zoneinfo | mysql -u root mysql. See the full explanation below for the reasoning.
Question
You are the database administrator for a MySQL database. The database server is installed on a Unix system. The time zone files for the system are located at /usr/share/zoneinfo. You need to ensure that the system and MySQL time zones are based on the same information. Which of the following statements will you use to accomplish the task?
Options
- Ashell> /ust/share/zoneinfo mysql_tzinfo_to_sql | mysql -u root mysql
- Bshell> /ust/share/zoneinfo mysql_tz_to_sql | mysql -u root mysql
- Cshell> mysql_tz_to_sql /ust/share/zoneinfo | mysql -u root mysql
- Dshell> mysql_tzinfo_to_sql /ust/share/zoneinfo | mysql -u root mysql
How the community answered
(30 responses)- A3% (1)
- B3% (1)
- C10% (3)
- D83% (25)
Community Discussion
No community discussion yet for this question.