Question

What is the maximum field size of text data type?
a) 256 b) 255
c) 225 d) 252

Answer 1

a) 256 bytes is the maximum field size of text data type

Answer 2

Answer:

The answer to the given question is :

a)256

Explanation:

The TEXT data type stores any text data type. It can contain both single byte and multibyte characters supported by the language. The term large object simply refers to an instance of the TEXT or BYTE data type.

A TEXT column has a theoretical limit of 231 bytes (two gigabytes) and the actual limit is determined by your available disk memory. More than 195 columns of a table cannot be declared as TEXT data type. The same restriction also applies to the BYTE data types.

You can store, retrieve, update, or delete values ​​in the TEXT column.

You can only use the TEXT operand in a Boolean expression when testing for a NULL value with the IS NULL or IS NOT NULL operators.

#SPJ2