Which of the following datatypes stores alphanumeric values and accepts text with rich text format, paragraphs, descriptions, etc?

Which of the following datatypes stores alphanumeric values and accepts text with rich text format,
paragraphs, descriptions, etc?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *