Which operator is used to check whether the expression is NULL ? – McqOptions

MCQOPTIONS

1.	Which operator is used to check whether the expression is NULL ?
A.	ON
B.	IS NULL
C.	NOT NULL
D.	All of above
E.	None of these
Answer» C. NOT NULL

Discussion

No Comment Found

Related MCQs

What will be the output of the following query?<br><pre class="prettyprint lang-c">SELECT First_name<br>FROM Employee<br>WHERE emp_id != 6;<br></pre>
What will be the output of the following query?<br><pre class="prettyprint lang-c">SELECT *<br>FROM Employee<br>WHERE emp_id = NULL;<br></pre>
What will be the output of the following query?<br><pre class="prettyprint lang-c">SELECT First_name<br>FROM Employee<br>WHERE emp_id != 6 OR emp_id IS NULL;<br></pre>
What will be the output of the following query?<br><pre class="prettyprint lang-c">SELECT * <br>FROM Student<br>WHERE id IS NULL;<br></pre>
What will be the output of the following query?<br><pre class="prettyprint lang-c">SELECT *<br>FROM Student<br>WHERE id IS NULL;<br></pre>
What is the meaning of NULL in Mysql?
Which operator is used to check the expression is not NULL ?
Which operator is used to check whether the expression is NULL ?