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

ECDL Exam ECDL-ADVANCED Topic 8 Question 60 Discussion

Actual exam question for ECDL's ECDL ADVANCED WORD PROCESSING exam
Question #: 60
Topic #: 8

Which of the following datatypes generates a consecutive number that can be used as the primary key of a table?

Show Suggested Answer Hide Answer
Suggested Answer: B

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:



The AutoNumber datatype generates a consecutive number that can be used as the primary key of a table. Answer option C is incorrect. The Currency datatype is used to store monetary values. The format of the currency can be changed by using the Format property. The various formats of the Currency datatype are as follows:

* General Number

* Currency

* Euro

* Fixed

* Standard

* Percent

* Scientific

Answer option D 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 option A 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.


Objective: Table Design

Contribute your Thoughts:

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

Save Cancel