🎴 Flashcard Mode
Relational Database Concepts and SQL Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which datatype you use to store a large block of text data having size around 3,500 characters in length ?
AnswerClick to flip back
A
VARCHAR2
💡 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.