Multiple choice technology databases How many LONG columns are allowed in a table ? 0 1 8 Any number Reveal answer Fill a bubble to check yourself B Correct answer Explanation In Oracle, a table can have only one LONG column. The LONG datatype is deprecated in favor of LOB datatypes (CLOB, BLOB), but the restriction of one LONG column per table still applies. This is a well-known Oracle limitation.