Which of the following datatypes is used to attach Microsoft Office files, graphics files, sound files, and pdf files to a table?

Which of the following datatypes is used to attach Microsoft Office files, graphics files, sound files,
and pdf files to a table?

A.
Hyperlink

B.
Memo

C.
OLE object

D.
Text

Explanation:
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 A 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 D is incorrect. The Text datatype is used to store alphanumeric values. These values can be
numbers, alphabets, special characters such as <, >, ?, etc. This datatype accepts values up to 255
characters. The number of characters can be limited to a fixed size by using the field size property.

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.