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. |
What does mysql_query() return on failure? |
| A. | 0 |
| B. | 1 |
| C. | -1 |
| D. | a non-zero |
| Answer» E. | |
| 2. |
The one that is more restrictive is __________ |
| A. | mysql_query() |
| B. | mysql_real_query() |
| C. | same |
| D. | machine dependentView Answer |
| Answer» B. mysql_real_query() | |
| 3. |
What is preferred when stored procedures are not being used? |
| A. | CLIENT_MULTI_STATEMENTS |
| B. | mysql_set_server_option() |
| C. | any of the two |
| D. | neither of the twoView Answer |
| Answer» D. neither of the twoView Answer | |
| 4. |
WHAT_IS_THE_GENERAL_STATEMENT-ISSUING_ROUTINE??$ |
| A. | mysql_real_query() |
| B. | mysql_query_real() |
| C. | mysql_image_query() |
| D. | mysql_query_image() |
| Answer» B. mysql_query_real() | |
| 5. |
CLIENT_MULTI_STATEMENT? |
| A. | mysql_set_server_option() |
| B. | any of the two |
| C. | neither of the two |
| Answer» B. any of the two | |
| 6. |
The option that enables multiple-statement execution is ____________ |
| A. | CLIENT_MULTI_STATEMENTS |
| B. | CLIENT_STATEMENTS_MULTI |
| C. | MULTI_STATEMENTS_CLIENT |
| D. | MULTI_CLIENTS_STATEMENTS |
| Answer» B. CLIENT_STATEMENTS_MULTI | |
| 7. |
Multiple statement execution is disabled by default. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
What is the type of Audit_log_events system variable? |
| A. | string |
| B. | integer |
| C. | float |
| D. | double |
| Answer» C. float | |
| 9. |
Hexadecimal values assigned to user variables are treated as _____________ |
| A. | strings |
| B. | non binary strings |
| C. | binary strings |
| D. | integers |
| Answer» D. integers | |
| 10. |
User defined variables are session specific. |
| A. | True |
| B. | False |
| Answer» B. False | |