Multiple choice technology databases

what are the minimum values that can be assigned to POSITIVE , NATURAL and SIGNTYPE data types respectively.

  1. 1 , 1 and 1

  2. 0 , 1 and 0

  3. 1 , 0 and -1

  4. 0 , 0 and -1
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In PL/SQL, the POSITIVE subtype restricts values to integers starting at 1. NATURAL restricts values to non-negative integers starting at 0. SIGNTYPE restricts values to -1, 0, or 1. Thus, their minimum values are 1, 0, and -1 respectively.

Keep practicing — related questions