Question 161Asked in DSSSB TGT Computer Science, 7 Feb 2024, Shift 2 (12:30 PM)

Which of the following maths function in SQL returns the smallest integer greater than,

Which of the following maths function in SQL returns the smallest integer greater than, or equal to, the specified numeric expression?
  1. AROUND
  2. BCEILING
  3. CABS
  4. DFLOOR
Show answerHide answer

Correct answer: (B) CEILING

Explanation

CEILING returns the smallest integer greater than or equal to the value, e.g. CEILING(4.2) = 5. FLOOR returns the largest integer less than or equal to it.

From DSSSB TGT Computer Science PYQ, 7 Feb 2024, Shift 2 (12:30 PM)

This is question 161 of DSSSB TGT Computer Science PYQ, 7 Feb 2024, Shift 2 (12:30 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.