In MS Access, which data type is ideal for fields that store long strings of alphanumeric characters, sentences, or paragraphs exceeding 255 characters? MCQ with Answer and Explanation
In MS Access, which data type is ideal for fields that store long strings of alphanumeric characters, sentences, or paragraphs exceeding 255 characters?
A. Hyperlink
B. Short Text
C. OLE Object
D. Long Text
Answer: Option D
Solution (By JKSSB Mock Tests)
In modern versions of MS Access, 'Long Text' (previously called Memo) stores up to about 1 gigabyte of text, whereas 'Short Text' is capped at 255 characters.
Explanation:
An Inner Join is the default join type in MS Access. It extracts records from linked tables only when the values in the joined fields match exactly.
No comments yet. Be the first to start the discussion!