Databases that store data in tables and allow relationships between them are called what?

Databases that store data in tables and allow relationships between them are called what?

• A. Relational databases
• B. Non-relational databases
• C. Document databases
• D. Key/value databases

Answer: (A)

Storing data in structured tables that can be linked through keys is the concept being tested. In relational databases, data lives in tables with rows and columns, and a primary key uniquely identifies each row. Related information in different tables is connected via foreign keys, which lets you join tables and retrieve related data across the database while maintaining referential integrity. This tabular, schema-based approach supports clear relationships (one-to-one, one-to-many, many-to-many) and reliable, consistent transactions. Other database types don’t organize data primarily as related tables with enforced foreign-key relationships. Non-relational databases use models like documents, key-value pairs, or wide-column stores, prioritizing flexible schemas and scalability. Document databases store data as documents and may embed related data or reference others, but they don’t enforce relationships through foreign keys in the same way. Key-value stores map a key to a value with little to no inherent structure for relationships.

Storing data in structured tables that can be linked through keys is the concept being tested. In relational databases, data lives in tables with rows and columns, and a primary key uniquely identifies each row. Related information in different tables is connected via foreign keys, which lets you join tables and retrieve related data across the database while maintaining referential integrity. This tabular, schema-based approach supports clear relationships (one-to-one, one-to-many, many-to-many) and reliable, consistent transactions.

Other database types don’t organize data primarily as related tables with enforced foreign-key relationships. Non-relational databases use models like documents, key-value pairs, or wide-column stores, prioritizing flexible schemas and scalability. Document databases store data as documents and may embed related data or reference others, but they don’t enforce relationships through foreign keys in the same way. Key-value stores map a key to a value with little to no inherent structure for relationships.