Mysql Setup


  1. What are X’61626364′ and X’61626364′?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In the numeric contexts, each hexadecimal number constant is treated as a number. Without adding a zero to it, a hexadecimal literal is treated as a string. Hence it is displayed as abcd.


  1. What is x’ffff’ in decimal?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In MySQL, string values are specified using the standard SQL notation x’val’. Here, val is pairs of hexadecimal digits ( ‘0’ through ‘ 9 ’ and ‘ a ’ through ‘ f ’). x’ffff’ is 65536 in decimal.



  1. The mode used to turn off the special meaning of backslash and treat it as an ordinary character is _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    To turn off the special meaning of backslash in MySQL, and treat it as an ordinary character, the SQL mode named NO_BACKSLASH_ESCAPES is enabled. The escape sequence is treated as characters.


  1. ‘x’ in the following statement is ____________.
    DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    The ‘DELETE’ operation is being performed in the statement. The table names are ‘x’ and ‘y’. The column name is ‘col’. The rows from left join of x and y get deleted according to the condition given.



  1. abc in the following statement is ___________.
    DELETE FROM xyz WHERE abc = 5;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    Here, the operation that is being performed in the statement is the ‘DELETE’ operation. The table name is ‘xyz’ and column name is ‘abc’. The rows having abc value equal to 5 get deleted.