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 returns a string containing an error message? |
| A. | mysql_error() |
| B. | mysql_errno() |
| C. | mysql_sqlstate() |
| D. | mysql_close() |
| Answer» B. mysql_errno() | |
| 2. |
How many among the following does not return a value? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3View Answer |
| Answer» C. 2 | |
| 3. |
How many among the following use NULL to indicate failure? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3View Answer |
| Answer» D. 3View Answer | |
| 4. |
0?$ |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| Answer» C. 3 | |
| 5. |
When building from source, the embedded server library is enabled by what? |
| A. | –with-embedded-server |
| B. | –with-server-embedded |
| C. | –with-embedded-library |
| D. | –with-library-embedded |
| Answer» B. ‚Äö√Ñ√∂‚àö√ë‚àö¬®with-server-embedded | |
| 6. |
What is the embedded server library containing the MySQL server linkable into applications? |
| A. | libmysqla |
| B. | libmysqlb |
| C. | libmysqlc |
| D. | libmysqld |
| Answer» E. | |
| 7. |
The string function that returns the index of the first occurrence of substring is _____________ |
| A. | INSERT() |
| B. | INSTR() |
| C. | INSTRING() |
| D. | INFSTR() |
| Answer» C. INSTRING() | |
| 8. |
The synonym for last_insert_id session variable is _____________ |
| A. | insert_id |
| B. | identity |
| C. | sql_auto_is_null |
| D. | sql_big_selects |
| Answer» C. sql_auto_is_null | |
| 9. |
Which variable when set to 1 would enable foreign key checking for InnoDB tables? |
| A. | error_count |
| B. | identity |
| C. | foreign_key_checks |
| D. | autocommit |
| Answer» D. autocommit | |
| 10. |
Which of these is a read only variable? |
| A. | error_count |
| B. | big_tables |
| C. | autocommit |
| D. | foreign_key_checks |
| Answer» B. big_tables | |