Multiple choice technology databases

CAN SIMPLE_INTEGERS CONTAIN NULL VALUES

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The SIMPLE_INTEGER datatype in Oracle (introduced in 11g) is a subtype of PLS_INTEGER that does not allow NULL values. It's designed for performance-critical code where NULL handling overhead is unwanted. SIMPLE_INTEGER always ranges from -2,147,483,648 to 2,147,483,647 and cannot be NULL.