n a table, which of the following must be identified as the primary key? A. field B. record C. object D. query

Analysis of Options

1. A. Field: This is a column in a table, which can contain data. However, a single field does not ensure uniqueness for each record.

2. B. Record: This is a row in a table that contains data about a single item. While records themselves are essential, they are not necessarily unique unless a primary key is defined.

3. C. Object: This term can be vague in the context of databases. Generally, it refers to instances of data structures. Not specifically related to primary keys.

4. D. Query: This is a request for data from the database. Queries do not relate to how data is stored or identified uniquely within tables.

Conclusion

The primary key is a unique identifier for a record in a table, which typically correlates to a field that ensures each record is distinct.

Final Answer

A. field