Question

select the correct answer.
a table has several fields related to computer data. you want the serial number (sr. no.) field to increase by one every time you add a new record. which data type would you use for the sr. no. field?
o a. null
o b. blod
o c. autonumber
o d. memo

Explanation:

• Null: Represents no value, not for auto - incrementing.
• BLOB (Binary Large Object): Stores large binary data (e.g., images, audio), not for numbering.
• AutoNumber: Automatically generates a unique number (usually increments by 1) for each new record, which fits the serial number requirement.
• Memo: Stores large text data, not for numbering.

Answer:

C. AutoNumber