MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 63 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
INT3 maps to MySQL type _____________. |
| A. | BIGINT |
| B. | MEDIUMINT |
| C. | SMALLINT |
| D. | TINYINT |
| E. | None of these |
| Answer» C. SMALLINT | |
| 52. |
INT2 maps to MySQL type _____________. |
| A. | BIGINT |
| B. | TINYINT |
| C. | SMALLINT |
| D. | MEDIUMINT |
| E. | None of these |
| Answer» D. MEDIUMINT | |
| 53. |
The statement that suspends the replication related activity of the slave server is _____________. |
| A. | GET SLAVE |
| B. | STOP SLAVE |
| C. | START SLAVE |
| D. | RESUME SLAVE |
| E. | None of these |
| Answer» C. START SLAVE | |
| 54. |
How many of the following do not support BIT data type? |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» E. None of these | |
| 55. |
IP numbers can be represented as _________________. |
| A. | integers but not a string |
| B. | a string but not integers |
| C. | neither a string nor integers |
| D. | both integers and a string |
| E. | None of these |
| Answer» E. None of these | |
| 56. |
What is used to produce a new string from an old string in a desired character set. |
| A. | CONVERTS() |
| B. | CONVERTER() |
| C. | Introducers |
| D. | CONVERT() |
| E. | None of these |
| Answer» E. None of these | |
| 57. |
The number of legal hexadecimal values among 0x0a, 0x0A, 0X0a and 0X0A is ___________. |
| A. | 4 |
| B. | 3 |
| C. | 2 |
| D. | 1 |
| E. | None of these |
| Answer» D. 1 | |
| 58. |
X 61626364 and X 61626364 are respectively __________. |
| A. | dcba and 1633837924 |
| B. | dcba and 4297383361 |
| C. | abcd and 1633837924 |
| D. | abcd and 4297383361 |
| E. | None of these |
| Answer» D. abcd and 4297383361 | |
| 59. |
x ffff in decimal is ___________ |
| A. | 65536 |
| B. | 65537 |
| C. | 66535 |
| D. | 65534 |
| E. | None of these |
| Answer» B. 65537 | |
| 60. |
The NUL ( 0 ) is same as the SQL NULL value. |
| A. | False |
| B. | True |
| C. | NA |
| D. | NA |
| E. | NA |
| Answer» B. True | |
| 61. |
If ANSI_QUOTES is enabled, MySQL treats the double quotes as ________________. |
| A. | string |
| B. | hexadecimal |
| C. | string-quoting character |
| D. | identifier-quoting character |
| E. | None of these |
| Answer» E. None of these | |
| 62. |
2341 is a ____________ |
| A. | hexadecimal |
| B. | string |
| C. | floating point |
| D. | integer |
| E. | None of these |
| Answer» C. floating point | |
| 63. |
The escape sequence for carriage return is ___________. |
| A. | b |
| B. | z |
| C. | c |
| D. | r |
| E. | All of above |
| Answer» E. All of above | |