Data Types
- To convert a string to an int, the function is _________________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
In MySQL, the function used to convert a string to an integer is INET_ATON(). On the other hand, the function INET_NTOA() converts a string to the corresponding integer value.
- To convert an int to string, the function is _________________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
In MySQL, the function used to convert an integer to a string is INET_NTOA(). On the other hand, the function INET_ATON() converts a string to the corresponding integer value.
- Calculations involving numbers are faster than those involving string.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
Numbers can be compared in a single operation while string comparisons involve several byte by byte or character by character comparisons. As the strings become longer, the performance gets poor.
- INT3 maps to MySQL type _____________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
In order to facilitate the use of the code written for SQL implementations (reusability of code) from other vendors, MySQL maps the data types from the other vendor types to the appropriate MySQL type.
- INT2 maps to MySQL type _____________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
In order to facilitate the use of code written for SQL implementations from other vendors, MySQL maps the data types from the other vendor types to the appropriate MySQL type.