Question

What does the term 'record' refer to in SQL?

• A. A row in a table
• B. A column in a table
• C. A primary key constraint
• D. A collection of all data in a table

Answer 1

Answer:

A. A row in a table

• A record, also called a row, is each individual entry that exists in a table.
• For example, there are 91 records in the above Customers table.
• A record is a horizontal entity in a table.
• A column is a vertical entity in a table that contains all information associated with a specific field in a table.