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 8 Question 15 Discussion

Actual exam question for Microsoft's exam
Question #: 15
Topic #: 8
[All Questions]

Which of the following datatypes is used to specify whether a condition is true or false?

Show Suggested Answer Hide Answer
Suggested Answer: C

The Yes/No datatype is a Boolean datatype that is used to specify whether a condition is true or false. A record can be retrieved based on any given condition. A user can use the WHERE clause to retrieve the data for those records that have been set to yes or no.

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

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.

Answer D is incorrect. 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


Contribute your Thoughts:

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


Save Cancel