ISA Certified Automation Professional (CAP) program

CAP logo

Certified Automation Professionals (CAPs) are responsible for the direction, design, and deployment of systems and equipment for manufacturing and control systems.

CAP question

Which of the following statements describes a database record?
A. all data related to a particular subject kept in a group
B. a single row of information in a table
C. a single piece of data in a single row of a table
D. an electronic filing system

CAP Answer

The answer is B, a single row of information in a table. Regarding answer C, single pieces of data (cells or fields) that describe related data entities can be combined into a single row, or database record. For example, the values in the single data fields FIRST NAME, MIDDLE NAME, and LAST NAME in a single row could define a record called EMPLOYEE NAME.

Multiple records make up answer A, which defines a table, or group of records, which defines EMPLOYEES.

All of the tables, records, and data are managed by answer D, an electronic filing system.

Reference: Trevathan, Vernon L., A Guide to the Automation Body of Knowledge, Second Edition, ISA, 2006.