MySQL Internationalization and Localization

MySQL Internationalization and Localization

Easy Questions

MYSQL

MySQL Subquery
MySQL Character Set
MySQL Views
Mysql Basic
Mysql Setup
Mysql Foreign Keys
Mysql Query Optimization
Interacting With MySQL
Server SQL Mode
MySQL Events
MySQL UNION
MySQL Full-Text Search
MySQL Command Line Tool
Mysql Error handling
Mysql Compound Statements
MySQL Stored Procedures
MySQL Stored Functions
MySQL Triggers
MySQL Connectors and APIs
Connection
MySQL Functions
MySQL Operators
MySQL Table Operations
MySQL Internationalization and Localization
MySQL Database Operations
MySQL Access Control and Security
MySQL Type Conversion in Expression Evaluation
MySQL Scheduling and Locking Issues
MySQL ORDER BY
MySQL HAVING
MySQL GROUP BY
MySQL Optimization
Managing MySQL Users
MySQL Programs
Access Control for MySQL Stored Programs and Views
Create Database
Drop Database
Select Database
Data Types
Create Tables
Insert Query
Select Query
Mysql miscellaneous
Where Clause
Update Query
Delete Query
Sorting Results
Using Join
NULL Values
Transactions
Alter Command
Indexes
Database Info
Using Sequences
  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.