MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
How many of the following is considered as a special character by ‘mysql_real_escape_string()’? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3View Answer |
| Answer» E. | |
| 2. |
Which of these has a lower memory requirements? |
| A. | mysql_use_result() |
| B. | mysql_store_result() |
| C. | same |
| D. | machine dependentView Answer |
| Answer» B. mysql_store_result() | |
| 3. |
How many of the following take a connection handler as an argument? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3View Answer |
| Answer» D. 3View Answer | |
| 4. |
mysql_store_result() does not return a result set. |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
How many of the following return rows? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3View Answer |
| Answer» E. | |
| 6. |
Which of these is more restrictive? |
| A. | mysql_query() |
| B. | mysql_real_query() |
| C. | same |
| D. | machine dependentView Answer |
| Answer» B. mysql_real_query() | |
| 7. |
The columns containing binary value that include null bytes will not print properly using the %s printf() format specifier. |
| A. | True |
| B. | False |
| Answer» C. | |
| 8. |
mysql_fetch_row() returns _______________ |
| A. | integer |
| B. | float |
| C. | structure |
| D. | pointer |
| Answer» B. float | |
| 9. |
For failure, mysql_query() returns _______________ |
| A. | 0 |
| B. | 1 |
| C. | -1 |
| D. | a non-zero |
| Answer» E. | |
| 10. |
The general statement-issuing routine is _______________ |
| A. | mysql_real_query() |
| B. | mysql_query_real() |
| C. | mysql_image_query() |
| D. | mysql_query_image() |
| Answer» B. mysql_query_real() | |