_________ data type stores unstructured binary data upto 4GB length.
-
CLOB
-
BLOB
-
LONG
-
All of the above
BLOB (Binary Large Object) is the data type designed to store unstructured binary data up to 4GB in length. CLOB (Character Large Object) is for character data, while LONG is an older data type with limitations. Option D 'All of the above' is incorrect because only BLOB specifically handles binary data.
To answer this question, you need to understand the different data types used to store unstructured binary data in databases.
Option A) CLOB - The CLOB (Character Large Object) data type is used to store large amounts of character data. It is not specifically designed to store binary data.
Option B) BLOB - The BLOB (Binary Large Object) data type is specifically designed to store unstructured binary data. It can store binary data up to 4GB in length. This makes option B the correct answer.
Option C) LONG - The LONG data type is used to store variable-length character data of up to 2GB in length. It is not specifically designed to store binary data.
Option D) All of the above - This option is incorrect because option C (LONG) is not a suitable data type for storing unstructured binary data. Only option B (BLOB) is designed for this purpose.
Therefore, the correct answer is B) BLOB. This option is correct because the BLOB data type is specifically designed to store unstructured binary data up to 4GB in length.