Relational databases store data in tables made up of rows and columns. Considering this structure, what is meant by a record (also called a row) within a table?
A graphical output that summarizes data for printing.
A single, complete set of related field values stored together in one row.
A command used to delete existing data from a table.
A column that uniquely identifies every other table in the database.
A record is a single, complete set of related data values stored together in one row of a table. Each field (column) in that row holds one attribute of the same entity. Records themselves are not automatically unique; uniqueness is enforced only when a primary-key or UNIQUE constraint is applied. Options describing commands, reports, or columns do not fit the definition of a record.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What are fields and records in a database?
Open an interactive chat with Bash
Why is it important for each record to be unique?
Open an interactive chat with Bash
What are some common types of databases and how do they store records?