MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
0x61 + 0 results in _____________. |
| A. | 97 |
| B. | 0 |
| C. | arbitrary |
| D. | a |
| E. | None of these |
| Answer» D. a | |
| 2. |
The number of strings among the following matched with %all% is _____________. |
| A. | 4 |
| B. | 3 |
| C. | 2 |
| D. | 1 |
| E. | None of these |
| Answer» B. 3 | |
| 3. |
abc || xyz , when PIPES_AS_CONCAT is enabled, results in ____________. |
| A. | xyzabc |
| B. | abcxyz |
| C. | 0 |
| D. | 1 |
| E. | None of these |
| Answer» C. 0 | |
| 4. |
The expression 2 BETWEEN 2 AND 5 results in ____________. |
| A. | 2 |
| B. | -1 |
| C. | False |
| D. | True |
| E. | None of these |
| Answer» E. None of these | |
| 5. |
If the PIPES_AS_CONCAT is disabled, abc || xyz results in ____________. |
| A. | -1 |
| B. | 1 |
| C. | 0 |
| D. | error |
| E. | None of these |
| Answer» D. error | |
| 6. |
The expression 12 DIV 5 evaluates to ____________. |
| A. | 2 |
| B. | 2.4 |
| C. | 0 |
| D. | error |
| E. | None of these |
| Answer» B. 2.4 | |
| 7. |
The expression HI LIKE NULL results in _____________. |
| A. | 0 |
| B. | NULL |
| C. | False |
| D. | True |
| E. | None of these |
| Answer» C. False | |