What will happen if the data being loaded into a text column exceeds the maximum size of that type?
A. Extra memory will be allocated
B. Process terminate
C. Data will be truncated
D. Depend on the system
Answer:A
What will happen if the data being loaded into a text column exceeds the maximum size of that type?
A. Extra memory will be allocated B. Process terminate C. Data will be truncated D. Depend on the system
Explanation: Mysql cannot allocate dynamic memory therefore if data exceeds the memory then extra data will be truncated.