Multiple choice technology databases

which of the following is TRUE.

  1. NUMBER is the subtype of INTEGER data type

  2. PLS_INTEGER is the subtype of BINARY_INTEGER

  3. POSITIVE data type is defined in SYS package.

  4. None of the above.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In PL/SQL, PLS_INTEGER is indeed a subtype of BINARY_INTEGER. They're both integer types with similar performance characteristics, used for mathematical operations. NUMBER is not a subtype of INTEGER - they're separate types. POSITIVE is a predefined subtype, not defined in SYS package.

Keep practicing — related questions