Question : What is the character length of the ‘Text’ data type and ‘memo’ data type -
Option 1:
- Text – 255 Characters
- Memo – 65536 Characters
Option 2:
- Text – 555 Characters
- Memo – 65535 Characters
Option 3:
- Text – 225 Characters
- Memo – 55536 Characters
Option 4:
- Text – 555 Characters
- Memo – 55536 Characters
Correct Answer:
- Text – 255 Characters
- Memo – 65536 Characters
Solution : Text data Type - It only has room for 255 characters. To limit the number of characters, it takes advantage of the field size property. e.g. Emp name
Memo data Type - It can hold as many as 65,536 characters. The field size property is not used. e.g. Emp description
Hence the Correct answer is option 1.