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. Text
C. OLE Object
D. Hyperlink
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, what field property constraint must be deployed to guarantee that an auto-incremented database table row cannot hold duplicate records?
A. Required set to 'No'
B. Indexed set to 'Yes (No Duplicates)'
C. Input Mask application
D. Validation Rule mapping

Correct Answer: Option B


Explanation:
Setting the Indexed property to 'Yes (No Duplicates)' establishes a unique constraint rule index that prevents identical values from being entered into that field.

This question belongs to: Computer Microsoft Office
Question #2
In MS PowerPoint, what are the motion pathways that dictate how an object changes its physical position on a slide canvas during an animation timeline?
A. Motion Paths
B. Transition Tracks
C. Emphasis Animations
D. Entrance Effects Layout

Correct Answer: Option A


Explanation:
Motion Paths allow design assets to animate along custom curved tracks, lines, or geometric paths across the slide canvas area.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, what is the intersection of a row and a column called?
A. Cell
B. Range
C. Record
D. Field

Correct Answer: Option A


Explanation:
A cell is the intersection point. Range is a group of cells.

This question belongs to: Computer Microsoft Office