Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 77-885 Topic 5 Question 29 Discussion

Actual exam question for Microsoft's exam
Question #: 29
Topic #: 5
[All Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: A

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.

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!

Save Cancel