Which of the following datatypes stores alphanumeric values and accepts text with rich text format,
paragraphs, descriptions, etc?
A.
Memo
B.
OLE Object
C.
Hyperlink
D.
Attachment
Explanation:
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 D is incorrect. The Attachment datatype is used to attach one or more files in a column. The
files can be an office 2007 file, an image file, a text file, or a log file. Other types of files cannot be
attached to the column. A file can be edited using software that is used for editing the file. If the
datatype of a column is Attachment, the datatype for that column cannot be changed.Answer C is incorrect. The Hyperlink datatype is used to store a hyperlink that is linked to a Web
page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this
datatype. Each row of a table contains only one hyperlink.
Answer B 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.