Data Types


  1. A BIT value in a result set is displayed as a binary string.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In MySQL, the BIT values in the result set are displayed as binary strings. In order to convert them to integers, either a zero is added or the ‘CAST()’ operator is used to cast them.


  1. The bit-field values are prefixed with __________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    In MySQL, the bit-field values can be either written as b’value’ or 0bvalue. Here, value is a sequence of digits zero or/and one. For example, b’1010′ and 0b1010 are decimal value 10.



  1. If a string is to be converted to a number, it is converted into a _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    When there is a need to convert a string to a number to evaluate an expression, it is first converted to a double precision floating point value. Then, it can be used to do arithmetic.


  1. The DECIMAL used for expressions containing only exact values with fractional part is of digit precision _________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In MySQL, for the expressions containing only exact values and where one or more values have a fractional part, the DECIMAL arithmetic is used with digits of precision equal to 65.



  1. The BIGINT precision is of bit _________











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    In MySQL, for the expressions containing only exact values that are all integers, the evaluation uses BIGINT (64 – bit) precision. MySQL evaluates expressions using exact/approximate math.