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

Question

Options

• AMemo
• BOLE Object
• CHyperlink
• DAttachment

• A
  82% (50)
• B
  3% (2)
• C
  10% (6)
• D
  5% (3)

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.

No community discussion yet for this question.