MySQL Database Multiple Choice Questions on “Internationalization and Localization Issues”.
1. The server sets its default time zone by examining its environment.
a) True
b) False
Answer: a
Clarification: 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 the server startup.
2. The system variable ‘system_time_zone’ can be reset at runtime.
a) True
b) False
Answer: b
Clarification: 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.
3. The variable which represents the default time zone of the MySQL server is _____________
a) time_zone
b) system_time_zone
c) date_and_time
d) system_time
Answer: a
Clarification: 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.
4. The number of options that can be used to control LOCAL capability at runtime is _____________
a) 0
b) 1
c) 2
d) 3
Answer: c
Clarification: 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.
5. If an error occurs during the transaction the troubleshoot is ____________
a) delete
b) rollback
c) commit
d) update
Answer: b
Clarification: Whenever an error occurs during a transaction, it is generally taken to the state prior to the beginning of transaction execution. This is known as rollback. It is a set of undo operations.
6. The ‘A’ in the ACID property of transactions is _______________
a) Availability
b) Accuracy
c) Adjustability
d) Atomicity
Answer: d
Clarification: All the transaction systems have an important set of characteristics in common. This is known as the ‘ACID’ property of the transaction. It refers to the four elementary characteristics of a transaction.
7. The ‘C’ in the ACID property of transactions is _______________
a) Compound
b) Concrete
c) Collision
d) Consistency
Answer: d
Clarification: The elementary characteristics of a transaction are known as the ‘ACID’ properties. ‘ACID’ is the acronym for the four basic characteristics that a transaction must have for smooth processing.
8. The datatype that means a variable length non binary string is __________
a) VARCHAR
b) BINARY
c) VARBINARY
d) BLOB
Answer: a
Clarification: In MySQL, there is a wide variety of string datatypes for use. Strings can even hold image and sound data. All four options are string type names. VARCHAR represents a variable length non binary string.
9. The date and time datatype that stores time value in ‘hh:mm:ss’ format is ___________
a) DATE
b) TIME
c) DATETIME
d) TIMESTAMP
Answer: b
Clarification: MySQL has some variety of date and time datatypes. These datatypes are crucial for representing records in a table. The ‘TIME’ type represents a time value, stored in the ‘hh:mm:ss’ format.
10. The spatial datatype used to store a curve is _____________
a) GEOMETRY
b) POINT
c) LINESTRING
d) POLYGON
Answer: c
Clarification: In MySQL, there are many spatial datatypes available for use. Some examples are GEOMETRY, POINT, LINESTRING and POLYGON. The LINESTRING type is used to represent a curve.