In a database, what is a collection of information that contains many fields?

Study for the SQA Higher Computing Science Exam with flashcards and multiple choice questions. Each question offers hints and explanations. Prepare effectively for your exam!

A collection of information that contains many fields is best described as a record. In the context of databases, a record represents a single, complete set of related data items that are organized within a table—each record consists of multiple fields, with each field holding a different piece of information about the same entity. For example, in a table of students, a record might include fields for the student's name, ID, age, and grade.

While a database refers to the overall collection of data, including multiple tables and records, and a table is a structured arrangement of data into rows and columns, the term "record" specifically denotes one complete set of field values within that structure. An entry is often used informally and doesn't carry the same technical specificity as the term record does in database terminology. Thus, the answer that correctly describes a collection of information with many fields is a record.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy