Multiple choice technology databases

Which of the following correctly describe the LONG columns (choose all that apply):

  1. You can use them to store long text strings

  2. They have many of the characteristics of VARCHAR2 columns

  3. They store variable-length character strings containing up to 2 gigabytes

  4. None of the choices.

Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

Oracle LONG columns are used to store variable-length character strings containing up to 2 gigabytes of text. They share many characteristics with VARCHAR2 columns, although they have many more restrictions on usage.