MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The number of binary string types among the following is ___________.BINARY, VARBINARY, BLOB, CHAR |
| A. | 4 |
| B. | 3 |
| C. | 2 |
| D. | 1 |
| E. | None of these |
| Answer» C. 2 | |
| 2. |
How many of the following attributes are allowed only for numeric types?UNSIGNED, ZEROFILL, CHARACTER SET, COLLATE |
| A. | 4 |
| B. | 3 |
| C. | 2 |
| D. | 1 |
| E. | None of these |
| Answer» D. 1 | |
| 3. |
How many of the following do not support BIT data type?MyISAM, MEMORY, NDB |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» E. None of these | |
| 4. |
To minimize disk I/O, which of these should be chosen?CHAR, VARCHAR |
| A. | either CHAR or VARCHAR |
| B. | any one |
| C. | CHAR |
| D. | VARCHAR |
| E. | None of these |
| Answer» E. None of these | |
| 5. |
Which of these take more space?Variable length columns, Fixed length columns |
| A. | indeterminate |
| B. | fixed length |
| C. | same |
| D. | variable length |
| E. | None of these |
| Answer» C. same | |
| 6. |
Which of these columns are faster?Variable length, Fixed length |
| A. | indeterminate |
| B. | fixed length |
| C. | variable length |
| D. | same |
| E. | None of these |
| Answer» C. variable length | |