In a relational database table, what is a record?

• A. A column value
• B. A database schema
• C. A row
• D. A partition

Answer: (C)

In a relational database table, a record is a row that represents one instance of the entity and contains values for every column in that row. It’s the complete set of data about a single item, across all attributes. For example, in a table of customers with columns like CustomerID, Name, and Email, a row such as 102, Maria Smith, [e-mail] is a record. Each column holds one piece of information for that customer, and together they describe that one customer.

Think of a column value as just one piece of information inside a row (like just the name or just the email). A database schema is the structure that defines what columns exist and their types. A partition is a way of dividing data for storage or performance. So the row captures one full set of related data for an entity across all its attributes.