MySQL Functions


  1. CGI.pm does not support an object oriented style of use.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    ‘CGI.pm’ supports an object oriented style of use which allows to invoke its functions without importing the names. To do this, a use statement is included and a CGI object is created.


  1. The string function that returns the index of the first occurrence of substring is _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    The string function ‘INSTR()’ is used to return the index of the first occurrence of the substring. The function ‘INSERT()’ is used to insert a substring at the specified position up to the specified number of characters.



  1. The operator that compares sounds is _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    The operator ‘SOUNDS LIKE’ is used to compare sound. The ‘RLIKE’ is a synonym for ‘REGEXP’, which is a pattern matching using regular expressions. There are a lot of other operators for use.


  1. Which function returns NULL if expr1 = expr2?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    The ‘CASE’ is used for the case operator. The function ‘IF()’ is used for the if/else construct. The function ‘IFNULL()’ is the Null if/else construct. ‘NULLIF()’ returns NULL if expr1 = expr2.



  1. The server is told to accept spaces after function names by _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    The MySQL server is told to accept spaces after function names by starting it with the ‘–sql-mode=IGNORE_SPACE’ option. Individual client programs can request this behavior by using the ‘CLIENT_IGNORE_SPACE’ option for ‘mysql_real_connect()’.