Which of the following describes Records in tables?

• A. They are the definitions of field types
• B. They contain fields and represent a row in a table
• C. They link to user accounts
• D. They represent columns in a database

Answer: (B)

Records in tables are structures used to store specific instances of data related to a particular entity. The statement that records contain fields and represent a row in a table is accurate because each record corresponds to one unique entry, or instance, within the database.

In database terminology, a record is structured with various fields that hold data, similar to how a row in a spreadsheet contains specific values under different categories represented by the headers (which are the fields). This is foundational to relational database management systems, where a table is organized into rows (records) and columns (fields).

Understanding this concept helps distinguish between different components of a database. Fields define the types of data that can be stored, while records encapsulate those definitions into actual data entries. Hence, choice B correctly identifies the nature of records within the context of tables.