What Is the Smallest Unit of Data in a Database?


Quick Answer

The smallest unit of data in a database is a bit or character, which is represented by 0, 1 or NULL. Numbers may also be stored in a binary format.

Continue Reading
Related Videos

Full Answer

The bit values are grouped into bytes, which comprise 8 bits. Bytes represent a specific character, special symbol or character code. The string values TRUE and FALSE may also be stored or converted to bit values. In this case, TRUE becomes 1, and FALSE becomes 0.

Depending on the type of server, a database engine may store information in bit columns, which are, in turn, stored as bytes. In some cases, the engine rounds the bits up to the nearest byte. For example, 6 bits are stored as 1 byte, and 12 bits are stored as 2 bytes.

Learn more about Software

Related Questions