Mysql Compound Statements
- The columns containing binary value that include null bytes will not print properly using the %s printf() format specifier.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
The columns containing binary value including null bytes do not print properly using the %s printf() format specifier. printf() expects a null terminated string. It prints the column value only up to the first null byte.
- Which of these has lower memory requirement?
mysql_use_result(), mysql_store_result()
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
The function ‘mysql_use_result()’ has lower memory requirements than ‘mysql_store_result()’ because only enough space to handle a single row at a time needs to be allocated. This can be faster.
- How many of the following take a connection handler as argument?
mysql_store_result(), mysql_use_result()
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
The functions ‘mysql_store_result()’ and ‘mysql_use_result()’ are similar because both of them take a connection handler argument and then return a result set after carrying out the processes.
- mysql_store_result() does not return a result set.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
The functions ‘mysql_store_result()’ and ‘mysql_use_result()’ are similar because both of them take a connection handler argument and then return a result set after carrying out processes.
- How many of the following is considered as a special character by ‘mysql_real_escape_string()’?
null byte, single quote, backslash
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
The characters that ‘mysql_real_escape_string()’ considers special are the null byte, single quote, double quote, ‘backslash’, ‘newline’, ‘carriage return’ and the ‘Control-Z’.