Multiple choice technology

The SQL function SIGN (-50) gives value as

  1. -50

  2. 50

  3. -1

  4. 1
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The SIGN function returns -1 for negative numbers, 0 for zero, and 1 for positive numbers. Since -50 is negative, SIGN(-50) returns -1, not the original value or its absolute value.

AI explanation

To answer this question, we need to understand the SQL function SIGN().

The SIGN() function in SQL returns the sign of a given number. It returns -1 if the number is negative, 0 if the number is zero, and 1 if the number is positive.

In this case, the given number is -50.

When we apply the SIGN() function to -50, it will return -1.

Therefore, the correct answer is C) -1.

Keep practicing — related questions