MENU
Which function measures a numeric value's distance from 0?
Suggested Answer: D
Get Premium Data Management - Foundations (D426) Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
The ABS() function in SQL returns the absolute value of a given number, effectively measuring its distance from zero.
Example Usage:
sql
SELECT ABS(-50), ABS(50);
Result:
50 | 50
This function ensures that numbers are always positive, regardless of their original sign.
Why Other Options Are Incorrect:
Option A (CONCAT) (Incorrect): Used to combine strings (not numbers).
Option B (LOWER) (Incorrect): Converts text to lowercase, not numerical operations.
Option C (FROM) (Incorrect): Part of SELECT FROM queries, not a function.
Thus, the correct choice is ABS(), which computes the absolute value of a number.
29 comments · newest first
MA
Margurite
6 months ago
FROM is irrelevant here, definitely D) ABS.
HA
Harris
6 months ago
I feel confident about this one, ABS is clear.
WI
Willodean
7 months ago
LOWER is about text, not numbers.
MA
Mariann
7 months ago
CONCAT doesn't fit at all.
MA
Maynard
7 months ago
Yeah, ABS measures distance from zero.
AR
Armanda
8 months ago
I agree, ABS is the correct answer!
TY
Tyra
8 months ago
Wait, is it really just ABS? Seems too simple.
CA
Carmen
8 months ago
ABS is the one that measures distance from 0, right?
RO
Rodolfo
8 months ago
I thought it was C) FROM at first.
LE
Leonor
8 months ago
It's definitely D) ABS!
FA
Fallon
8 months ago
I was hoping for a function that could measure my distance from the fridge, but ABS will have to do.
FE
Felicidad
9 months ago
D) ABS is the way to go. It's the function that gets the job done without any nonsense.
MO
Mose
9 months ago
The ABS function is like a bouncer at a club - it doesn't care if you're positive or negative, it just kicks you out and gives you the distance from 0.
BA
Barrett
9 months ago
D) ABS is the correct answer. It measures the absolute value of a numeric value.
TO
Tonette
9 months ago
I feel like LOWER has to do with text, so it can't be the right choice. ABS seems most likely.
ER
Erasmo
9 months ago
I remember practicing a question like this, and I believe ABS was the answer.
QU
Quentin
9 months ago
I think the function that measures distance from 0 is ABS, but I'm not completely sure.
AI
Aileen
10 months ago
The ABS function, that's the one! It returns the absolute value, which is the distance from 0. I remember learning this in class.
AR
Arleen
10 months ago
Okay, I've got this. The ABS function is the one that gives the absolute value, which is the distance from 0. I'm feeling confident about this one.
EA
Earnestine
10 months ago
I think it's D) ABS.
NI
Nieves
10 months ago
I'm not sure about this. Is it the FROM function that measures distance from 0? I'll have to review this concept again before answering.
ED
Eden
10 months ago
I’m a bit confused; I thought CONCAT was related to strings, not numeric values.
CR
Crista
11 months ago
I'm a bit confused on this one. Is it the LOWER function that measures distance from 0? I'll have to think about this more.
CA
Cammy
11 months ago
Hmm, this seems pretty straightforward. I think the ABS function is the one that measures the distance from 0.
AD
Adolph
5 months ago
Exactly! No other function does that.
TH
Thomasena
6 months ago
ABS is the only one that fits.
TR
Tracey
6 months ago
I thought it was obvious too!
DE
Dewitt
6 months ago
Yeah, it makes sense. It gives the absolute value.
AL
Albina
6 months ago
I agree, ABS is definitely the right choice!