MySQL Functions
- CGI.pm does not support an object oriented style of use.
-
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.
- The string function that returns the index of the first occurrence of substring is _____________.
-
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.
- The operator that compares sounds is _____________.
-
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.
- Which function returns NULL if expr1 = expr2?
-
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.
- The server is told to accept spaces after function names by _____________.
-
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()’.