Question 8 - Past Year - 1 Mark Questions - Chapter 9 - Structured Query Language

Last updated at July 14, 2026 by

This question asked in CBSE SQP-2021

In SQL, what is the use of IS NULL operator?

 

Answer:

The IS NULL operator is used to check if a column has null/empty value.

Syntax: SELECT column_names

      FROM table_name

      WHERE column_name IS NULL ;

 

Example:

Question 8 Very short- image 1.jpg

Question 8 Very short- image 2..jpg

Remove Ads Share on WhatsApp

Transcript

This question asked in CBSE SQP-2021 In SQL, what is the use of IS NULL operator? Answer: The IS NULL operator is used to check if a column has null/empty value. Syntax: SELECT column_names FROM table_name WHERE column_name IS NULL; Example:

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh is an IIT Kanpur graduate and has been teaching for 16+ years. At Teachoo, he breaks down Maths, Science and Computer Science into simple steps so students understand concepts deeply and score with confidence.

Many students prefer Teachoo Black for a smooth, ad-free learning experience.