Which structures within a database hold data in rows and columns?

Which structures within a database hold data in rows and columns?

• A. Schema
• B. Tables
• C. Fields/columns
• D. Constraints

Answer: (B)

Data in a relational database is stored in tables, which organize information in rows and columns. Each table represents a set of records (rows), and each row contains the data for one record. Columns define the attributes being stored, so every row has a value for each column. The container that holds all these rows and columns is the table itself. A schema describes how tables relate and what they contain, but it doesn’t store the data. Constraints enforce rules on the data within tables. So the structure that holds data in rows and columns is the table.

Data in a relational database is stored in tables, which organize information in rows and columns. Each table represents a set of records (rows), and each row contains the data for one record. Columns define the attributes being stored, so every row has a value for each column. The container that holds all these rows and columns is the table itself. A schema describes how tables relate and what they contain, but it doesn’t store the data. Constraints enforce rules on the data within tables. So the structure that holds data in rows and columns is the table.