aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Database Management System
  • What would be the output of the following SQL query? SQL&...
Multiple choice

What would be the output of the following SQL query? SQL>select trunc(19.989776,1) from dual;

  1. 20.0

  2. 19.0

  3. 19.9

  4. None of these

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is the correct option as this function truncates the input number upto one decimal place.

Keep practicing — related questions

  • Compare the output of the following: SELECT TRUNC(99.57,1) FROM DUAL; and SELECT ROUND(99.57,1) FROM DUAL;
  • Compare the output of the following: SELECT TRUNC(99.57,1) FROM DUAL; and SELECT ROUND(99.57,1) FROM DUAL;
  • Compare the output of the following: SELECT TRUNC(99.57,1) FROM DUAL; and SELECT ROUND(99.57,1) FROM DUAL;
  • Compare the output of the following: SELECT TRUNC(99.57,1) FROM DUAL; and SELECT ROUND(99.57,1) FROM DUAL;
  • Evaluate the given SQL statement. SELECT ROUND (45.953, -1), TRUNC (45.936, 2) FROM dual; Which of the foll...
  • Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?
  • Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?
  • Evaluate the following SQL statement: SELECT ROUND (TRUNC (MOD (1600, 10),-1), 2) FROM dual; What will be d...
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy