Which of the following datatypes is used for inserting a number automatically and incrementing it by
one when a new record is inserted in a table?
A.
OLE Object
B.
Memo
C.
AutoNumber
D.
Yes/No
Explanation:
The AutoNumber datatype is used for inserting a number automatically and incrementing it by one
when a new record is inserted in a table. The increment can be changed through the New Values
property. This property has the following two values:
Increment
Random
Answer B is incorrect. The Memo datatype stores alphanumeric values. These values can be
numbers, alphabets, special characters such as <, >, ?, etc. This datatype is used in place of the Text
datatype. It can store 65,535 characters. It also accepts text with rich text format, paragraphs,
descriptions, etc.
Answer A is incorrect. The OLE Object datatype is used to attach files and add binary data to a table.
This datatype stores each data in a bitmap format. This results in an increase in the size of a
database file. Only a single file can be added to each row of a table. The files attached can be
Microsoft Office files, graphics files, sound files, pdf files, etc.
Answer D is incorrect. The Yes/No datatype is a Boolean datatype that is used to specify whether a
condition is true or false. A record can be retrieved based on any given condition. A user can use the
WHERE clause to retrieve the data for those records that have been set to yes or no.