A common type of database that stores data in tables and rows is a relational database. This structure organizes data into predefined relationships, allowing for easy access and manipulation of the information. Each table consists of columns representing different attributes and rows containing the data entries. Relational databases use Structured Query Language (SQL) for data management and retrieval, making them a popular choice for various applications where efficient data organization and querying are required.