Question
A database has the following schema:
| ID | Name | Age |
|---|---|---|
| 2 | John | 36 |
| 6 | Jane | 39 |
| 12 | Allison | 42 |
| 21 | Anna | 29 |
Which of the following is the number of records in the schema?
- A. 3
- B. 4 Correct
- C. 12
- D. 21
Explanation
A record is one row of a table. The table has four rows (John, Jane, Allison and Anna), so it holds four records. Three is the number of fields (columns: ID, Name and Age), and 12 and 21 are ID values, not counts.
