aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Oracle 9i and SQL Database Quiz
  • Which of the following functions can be used to determine...
Multiple choice technology databases

Which of the following functions can be used to determine whether a column value is NULL

  1. SUBSTR

  2. VALUE

  3. COALESCE

  4. NULLIF

Reveal answer Fill a bubble to check yourself
B,C Correct answer

Keep practicing — related questions

  • Choose the functions that can be used with NULL values
  • Which function can return a non-NULL value if passed a NULL argument?
  • Which function can return a non-NULL value if passed a NULL argument?
  • which statement(s) does the following If @variable is NULL return '5', else return @variable
  • SELECT NULLIF(NULL,'testing') FROM DUAL ;
  • SELECT NULLIF('testing','testing') FROM DUAL ;
  • COUNT will consider NULL values in the column while counting.
  • Which Function can return a non-Null value if passed null arguments?
Play the full quiz 🎤 Practise this topic out loud

Practice this topic

  • Programming Fundamentals (2381 questions)
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy