CompTIA Tech+ (FC0-U71)Data and Database FundamentalsEasy
A database administrator opens a Customers table and looks at the row containing all the information for one specific customer, including their name, address, and phone number. What is this single row called?
- ARecord
- BQuery
- CSchema
- DField
Show answer & explanationAnswer & explanation
Correct answer: A. Record
A record (also called a row) represents all the data for a single entity, such as one customer, across all fields in a table. A field is a single column of data, not a full row.
Why the other options are wrong
- B. A query is a request to retrieve or manipulate data, not a row itself.
- C. A schema describes the overall structure of the database, not one row.
- D. A field is one column, like just 'Phone Number', not the whole row.
Table Structure: Fields and Records
A database table is organized into fields (columns) and records (rows). Each record represents one complete entry, and each field represents one attribute of that entry.
- Field = column = single attribute (e.g., Email)
- Record = row = one complete entity's data
- Table = collection of related records
Memory trick: Rows are Records, Columns are Categories (fields)