MySQL Internationalization and Localization


  1. If an error occurs during the transaction the troubleshoot is ____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    Whenever an error occurs during a transaction, it is generally taken to the state prior to the beginning of transaction execution. This is know as rollback. It is a set of undo operations.


  1. The number of options that can be used to control LOCAL capability at runtime is _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    At runtime, the server can be started with the ‘–local-infile’ or ‘–skip-local-infile’ options to enable or disable ‘LOCAL’ capability on the server side. It can be enabled at build time too.



  1. The variable which represents the default time zone of the MySQL server is _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The system variable ‘time_zone’ represents the default time zone of the MySQL server. By default, this variable is set to ‘SYSTEM’ which means to use the system_time_zone setting.


  1. The system variable ‘system_time_zone’ can be reset at runtime.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    The ‘system_time_zone’ represents the time zone that the server determines to be the server host time zone at startup time. It exists only as a global system variable and cannot be reset at runtime.



  1. The server sets its default time zone by examining its environment.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In MySQL the server sets its default time zone by examining its environment. This is the local time zone of the server host. The time zone can be specified explicitly at server startup.