ECDL Exam ECDL-ADVANCED Topic 5 Question 98 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 98
Topic #: 5

Which of the following datatypes cannot be filtered by using common filters?

Each correct answer represents a complete solution. Choose two.

AHyperlink

BOLE Object

CCalculated Field

DAutoNumber
Explanation:
The following datatypes cannot be filtered by using common filters:
OLE Object: 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.
Calculated Field: The Calculated Field datatype is used to store the results of a calculation. The calculation should refer to other fields created in the same table. In order to create the calculation, a user can use the Expression Builder that provides the use of IntelliSense and an easy way to access expression values.
Answer options A and D are incorrect. These datatypes can be filtered by using common filters.
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.
The AutoNumber datatype is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table. The increment can be changed through the New Values property. This property has the following two values:
Increment
Random

Show Suggested Answer

Suggested Answer: B, C

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Report Design

by Yan at Sep 14, 2024, 05:11 PM

Limited Time Offer

25%

Off

Get Premium ECDL-ADVANCED Questions as Interactive Web-Based Practice Test or PDF