Which Access data type would be most suitable for storing lengthy descriptive text up to about 1 GB? MCQ with Answer and Explanation

Which Access data type would be most suitable for storing lengthy descriptive text up to about 1 GB?
A. Long Text (Memo)
B. Hyperlink
C. OLE Object
D. Text
Answer: Option A
Solution (By JKSSB Mock Tests)
Long Text (formerly Memo) stores large amounts of text. Text holds up to 255 characters. OLE Object stores binary objects.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In MS Access, which property defines the pattern for data entry (like phone number)?
A. Input Mask
B. Validation Rule
C. Format
D. Default Value

Correct Answer: Option A


Explanation:
Input Mask controls entry format.

This question belongs to: Computer Microsoft Office
Question #2
What type of validation error code is returned by MS Excel if a cell formula uses an unrecognized function name, such as =SUUM(A1:A2)?
A. #NULL!
B. #VALUE!
C. #NAME?
D. #REF!

Correct Answer: Option C


Explanation:
The #NAME? error occurs when Excel does not recognize text within a formula, which is typically caused by a misspelled function name or a missing quote around a text string.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, what does the 'Ctrl + Shift + K' shortcut do?
A. Changes the font to Symbol
B. Inserts a hyperlink
C. Applies small caps formatting
D. Starts a new line without breaking paragraph

Correct Answer: Option C


Explanation:
Ctrl+Shift+K toggles small caps.

This question belongs to: Computer Microsoft Office