MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 16 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. |
0x61 + 0 results in _____________ |
| A. | 0 |
| B. | ‘a’ |
| C. | 97 |
| D. | arbitrary |
| Answer» D. arbitrary | |
| 2. |
Which of the following is the correct order of precedence (high to low)? |
| A. | !, ^, <<, XOR |
| B. | ^, !, <<, XOR |
| C. | !, <<, XOR, ^ |
| D. | !, ^, XOR, << |
| Answer» B. ^, !, <<, XOR | |
| 3. |
The number of strings among the following matched with ‘%all%’ is _____________ |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4View Answer |
| Answer» E. | |
| 4. |
The expression ‘HI’ LIKE NULL results in _____________ |
| A. | True |
| B. | False |
| C. | NULL |
| D. | 0 |
| Answer» D. 0 | |
| 5. |
The expression ‘2 BETWEEN 2 AND 5’ results in ____________ |
| A. | True |
| B. | False |
| C. | -1 |
| D. | 2 |
| Answer» B. False | |
| 6. |
‘abc’ || ‘xyz’, when PIPES_AS_CONCAT is enabled, results in ____________ |
| A. | 0 |
| B. | 1 |
| C. | abcxyz |
| D. | xyzabc |
| Answer» D. xyzabc | |
| 7. |
If the PIPES_AS_CONCAT is disabled, ‘abc’ || ‘xyz’ results in ____________ |
| A. | 1 |
| B. | 0 |
| C. | error |
| D. | -1 |
| Answer» C. error | |
| 8. |
WHICH_OF_THE_FOLLOWING_IS_THE_CORRECT_ORDER_OF_PRECEDENCE_(HIGH_TO_LOW)??$ |
| A. | !, ^, <<, XOR |
| B. | ^, !, <<, XOR |
| C. | !, <<, XOR, ^ |
| D. | !, ^, XOR, << |
| Answer» B. ^, !, <<, XOR | |
| 9. |
0x61_+_0_results_in______________$ |
| A. | 0 |
| B. | ‘a’ |
| C. | 97 |
| D. | arbitrary |
| Answer» D. arbitrary | |
| 10. |
If the operands are non binary strings, LIKE compares them according to their collation. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
The expression ‘HI’ LIKE NULL results in _____________$ |
| A. | True |
| B. | False |
| C. | NULL |
| D. | 0 |
| Answer» D. 0 | |
| 12. |
REGEXP takes collation into account. |
| A. | True |
| B. | False |
| Answer» C. | |
| 13. |
The expression ‘2 BETWEEN 2 AND 5’ results in ____________$ |
| A. | True |
| B. | False |
| C. | -1 |
| D. | 2 |
| Answer» B. False | |
| 14. |
‘abc’ || ‘xyz’, when PIPES_AS_CONCAT is enabled, results in ____________$ |
| A. | 0 |
| B. | 1 |
| C. | abcxyz |
| D. | xyzabc |
| Answer» D. xyzabc | |
| 15. |
If the PIPES_AS_CONCAT is disabled, ‘abc’ || ‘xyz’ results in ____________$ |
| A. | 1 |
| B. | 0 |
| C. | error |
| D. | -1 |
| Answer» C. error | |
| 16. |
The expression 12 DIV 5 evaluates to ____________ |
| A. | 2.4 |
| B. | 2 |
| C. | error |
| D. | 0 |
| Answer» C. error | |