MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 14 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. |
If ANSI_QUOTES is enabled, MySQL treats the double quotes as ________________ |
| A. | identifier-quoting character |
| B. | string-quoting character |
| C. | hexadecimal |
| D. | string |
| Answer» B. string-quoting character | |
| 2. |
‘2341’ is a ____________ |
| A. | integer |
| B. | floating point |
| C. | hexadecimal |
| D. | string |
| Answer» E. | |
| 3. |
A BIT value in a result set is displayed as a binary string. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
Numbers prefixed with ‘0x’ are in base __________ |
| A. | 8 |
| B. | 16 |
| C. | 32 |
| D. | 64 |
| Answer» C. 32 | |
| 5. |
IF_ANSI_QUOTES_IS_ENABLED,_MYSQL_TREATS_THE_DOUBLE_QUOTES_AS_________________?$ |
| A. | identifier-quoting character |
| B. | string-quoting character |
| C. | hexadecimal |
| D. | string |
| Answer» B. string-quoting character | |
| 6. |
‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚Àւ§2341‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖ¬•_IS_A_____________?$# |
| A. | integer |
| B. | floating point |
| C. | hexadecimal |
| D. | string |
| Answer» E. | |
| 7. |
A BIT value in a result set is displayed as a binary string? |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
The bit-field values are prefixed with __________ |
| A. | 0b |
| B. | 0bit |
| C. | bit- |
| D. | ‘bit’ |
| Answer» B. 0bit | |
| 9. |
If a string is to be converted to a number, it is converted into a _____________ |
| A. | double precision floating point |
| B. | single precision floating point |
| C. | decimal integer |
| D. | hexadecimal integer |
| Answer» B. single precision floating point | |
| 10. |
The DECIMAL used for expressions containing only exact values with fractional part is of digit precision _________ |
| A. | 32 |
| B. | 64 |
| C. | 65 |
| D. | 16 |
| Answer» D. 16 | |
| 11. |
The BIGINT precision is of bit _________ |
| A. | 32 |
| B. | 64 |
| C. | 128 |
| D. | 16 |
| Answer» C. 128 | |
| 12. |
The mantissa in -1.58E5 is __________ |
| A. | -1.58 |
| B. | 1.58 |
| C. | E |
| D. | 5 |
| Answer» B. 1.58 | |
| 13. |
Hexadecimal numbers cannot be used in scientific notation. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 14. |
Numbers prefixed with ‘0x’ are in base __________ |
| A. | 8 |
| B. | 16 |
| C. | 32 |
| D. | 64 |
| Answer» C. 32 | |