MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
How many of the following use NULL to indicate failure?mysql_init(), mysql_real_connect() |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» C. 1 | |
| 2. |
How many of the following does not return a value?mysql_close(), mysql_init, mysql_real_connect |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» D. 0 | |
| 3. |
The protocol value TCP runs on which operating systems? |
| A. | windows only |
| B. | all |
| C. | unix only |
| D. | mac |
| E. | None of these |
| Answer» C. unix only | |
| 4. |
The argument to the function mysql_error() is _______________. |
| A. | pointer |
| B. | structure |
| C. | float |
| D. | integer |
| E. | None of these |
| Answer» B. structure | |
| 5. |
The SQL mode to check for divide by zero error is ________________. |
| A. | ERROR_DIVIDE_BY_ZERO |
| B. | ERROR_WHEN_DIVIDE_BY_ZERO |
| C. | ERROR_FOR_DIVISION_BY_ZERO |
| D. | STRICT_ALL_TABLES |
| E. | None of these |
| Answer» D. STRICT_ALL_TABLES | |
| 6. |
For which type are illegal values converted to the appropriate zero value? |
| A. | TIME |
| B. | ENUM |
| C. | String |
| D. | Numeric |
| E. | None of these |
| Answer» B. ENUM | |
| 7. |
Which mode prevents entry of the zero date value in strict mode? |
| A. | NO_ZERO_IN_DATE |
| B. | PREVENT |
| C. | SUPPRESS |
| D. | NO_ZERO_DATE |
| E. | None of these |
| Answer» E. None of these | |
| 8. |
Which mode is a shorthand for both strict modes plus a bunch of other restrictions ? |
| A. | TRADITIONAL |
| B. | ERROR_WHEN_DIVIDE_BY_ZERO |
| C. | STRICT_TRANS_TABLES |
| D. | STRICT_ALL_TABLES |
| E. | None of these |
| Answer» B. ERROR_WHEN_DIVIDE_BY_ZERO | |