Register

DB basics SQL

• edited by
2,471 views

1 Answer

Best answer
6 6 votes

Answer would be (D) It is variable.

TINYBLOB, TINYTEXT                       L + 1 bytes, where L < 2^8
BLOB, TEXT                                      L + 2 bytes, where L < 2^16
MEDIUMBLOB, MEDIUMTEXT            L + 3 bytes, where L < 2^24
LONGBLOB, LONGTEXT                     L + 4 bytes, where L < 2^32

Variable-length string types are stored using a length prefix plus data. The length prefix requires from one to four bytes depending on the data type, and the value of the prefix is L (the byte length of the string). For example, storage for a MEDIUMTEXT value requires L bytes to store the value plus three bytes to store the length of the value.

Here is the Reference. 

• selected by
Voting & Accepting an answer helps improve the community
← Previous · DB \ relational alge...Next → · Explain
← Previous in category · DB \ relational alge...Next in category → · FAN trap
Position:
Show:

Related questions

3 3 votes
1 1 answer
153
153 views
GO Classes asked Sep 3
153 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Insert
Consider the relation$\text{Student(sid,\ name,\ age)}$where the attributes occur in the schema in the order shown.Which of the following statements correctly inserts the...
2 2 votes
1 1 answer
124
124 views
GO Classes asked Sep 3
124 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Domain Types
A table contains the following attributes:$\text{code\ CHAR(6)}$$\text{name\ VARCHAR(10)}$Which of the following statements are correct?A value of $\text{code}$ has a fix...
2 2 votes
1 1 answer
454
454 views
shc asked Jan 19
454 views
SQL HAVING and SELECT possible attributes
In SQL-92 (which is what GATE assumes), which columns are allowed in SELECT and HAVING, when GROUP BY is present or not ?Which columns/attributes can be aggregated or non...
0 0 votes
0 0 answers
210
210 views
js__ asked Nov 24, 2025
210 views
Doubt - sql
Should we answer according to the latest version which is in real life practical or stick to the old versions in standard text books ? @Deepak Poonia @Sachin Mittal 1 Que...