Multiple choice technology databases

Which datatype you use to store a large block of text data having size around 3,500 characters in length ?

  1. CLOB

  2. BLOB

  3. BFILE

  4. VARCHAR2
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

VARCHAR2 is the correct choice for text up to 4000 bytes. At 3,500 characters, VARCHAR2 is efficient and appropriate. CLOB is for large text (up to 4GB) and has overhead. BLOB is for binary data. BFILE stores file pointers, not actual text. VARCHAR2(4000) is the standard for moderate-length text in Oracle.

Keep practicing — related questions