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

Question

Options

• AHyperlink
• BMemo
• COLE object
• DText

• A
  10% (4)
• B
  2% (1)
• C
  83% (34)
• D
  5% (2)

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 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.

No community discussion yet for this question.