MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 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. |
INT3 maps to MySQL type _____________ |
| A. | TINYINT |
| B. | SMALLINT |
| C. | MEDIUMINT |
| D. | BIGINT |
| Answer» D. BIGINT | |
| 2. |
INT2 maps to MySQL type _____________ |
| A. | TINYINT |
| B. | SMALLINT |
| C. | MEDIUMINT |
| D. | BIGINT |
| Answer» C. MEDIUMINT | |
| 3. |
If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ____________ |
| A. | MEDIUMINT SIGNED |
| B. | MEDIUMINT UNSIGNED |
| C. | SMALLINT SIGNED |
| D. | SMALLINT UNSIGNED |
| Answer» C. SMALLINT SIGNED | |
| 4. |
INT2_MAPS_TO_MYSQL_TYPE______________?$ |
| A. | TINYINT |
| B. | SMALLINT |
| C. | MEDIUMINT |
| D. | BIGINT |
| Answer» C. MEDIUMINT | |
| 5. |
INT3_maps_to_MySQL_type______________$ |
| A. | TINYINT |
| B. | SMALLINT |
| C. | MEDIUMINT |
| D. | BIGINT |
| Answer» D. BIGINT | |
| 6. |
If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ___________? |
| A. | MEDIUMINT SIGNED |
| B. | MEDIUMINT UNSIGNED |
| C. | SMALLINT SIGNED |
| D. | SMALLINT UNSIGNED |
| Answer» C. SMALLINT SIGNED | |
| 7. |
Which of these values is not valid as an AUTO_INCREMENT value? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» B. 1 | |
| 8. |
AUTO_INCREMENT columns must be NOT NULL. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 9. |
Which of these types store the longest length of strings? |
| A. | CHAR |
| B. | VARCHAR |
| C. | TINYTEXT |
| D. | TEXT |
| Answer» E. | |
| 10. |
If a column is expected to store values up to 2 million, the best datatype for it is _____________ |
| A. | SMALLINT |
| B. | TINYINT |
| C. | MEDIUMINT |
| D. | BIGINT |
| Answer» E. | |
| 11. |
MySQL provides a date type that has an optional time part. |
| A. | True |
| B. | False |
| Answer» C. | |
| 12. |
Which datatype is best suited to store currency values? |
| A. | INT |
| B. | FLOAT |
| C. | DOUBLE |
| D. | DECIMAL |
| Answer» E. | |
| 13. |
The AUTO_INCREMENT column attribute is best used with which type? |
| A. | FLOAT |
| B. | INT |
| C. | CHARACTER |
| D. | DOUBLE |
| Answer» C. CHARACTER | |