When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

Have tested and results indicate – C is answer

Created 2 tables – populated with 4K rows each, same date – number “1”
No indexes

CREATE TABLE `bit_table` (
`id` bit(8) NOT NULL
)
COLLATE=’latin1_swedish_ci’
ENGINE=InnoDB;

CREATE TABLE `smallint_table` (
`id1` smallint NOT NULL,
`id2` smallint NOT NULL,
`id3` smallint NOT NULL,
`id4` smallint NOT NULL,
`id5` smallint NOT NULL,
`id6` smallint NOT NULL,
`id7` smallint NOT NULL,
`id8` smallint NOT NULL
)
COLLATE=’latin1_swedish_ci’
ENGINE=InnoDB;

Compared sizes

SELECT table_name AS “Tables”,
round(((data_length + index_length) / 1024 / 1024), 2) “Size in MB”
FROM information_schema.TABLES
WHERE table_name in (‘bit_table’,’smallint_table’)
ORDER BY (data_length + index_length) DESC;

+—————-+————+
| Tables | Size in MB |
+—————-+————+
| smallint_table | 0.20 |
| bit_table | 0.14 |
+—————-+————+

mysql> select count(1) from smallint_table;
+———-+
| count(1) |
+———-+
| 4001 |
+———-+
1 row in set (0.00 sec)

mysql> select count(1) from bit_table;
+———-+
| count(1) |
+———-+
| 4001 |
+———-+
1 row in set (0.00 sec)