Microsoft
98-364 · Question #32
98-364 Question #32: Real Exam Question with Answer & Explanation
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
Community Discussion
No community discussion yet for this question.