MySQL Operators


  1. The maximum non zero value for FLOAT is ______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    In MySQL, each datatype has its own range. Data types give an idea of the kind of values and the ranges that a variable is allowed to store. The maximum non zero value for FLOAT is 3.402823466E+38.


  1. Which function returns reference to array of row values?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    ‘fetchrow_arrayref()’ returns a reference to an array of row values. The function ‘fetchrow_hashref()’ returns reference to hash of row values. ‘fetch()’ is the same as fetchrow_arrayref().



  1. ‘fetchrow_hashref()’ returns reference to hash of row values keyed by what?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The function ‘fetchrow_hashref()’ returns reference to hash of row values, keyed by the column name. The function ‘fetchrow_arrayref()’ returns a reference to an array of row values.


  1. Which function returns a reference to hash of row values?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    The function ‘fetchrow_hashref()’ returns reference to hash of row values. ‘fetchrow_arrayref()’ returns a reference to an array of row values. ‘fetch()’ is the same as fetchrow_arrayref().



  1. Which function returns an array of row values?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The function ‘fetchrow_array()’ returns an array of row values. ‘fetchrow_arrayref()’ returns a reference to an array of row values. ‘fetch()’ is the same as fetchrow_arrayref().