Exam 98-364 topic 1 question 26 discussion

Actual exam question from Microsoft's 98-364

Question #: 26
Topic #: 1

You have the following table definition:

CREATE TABLE Product -
(ID INTEGER PRIMARY KEY,
Name VARCHAR(20),
Quantity INTEGER)
The Product table contains the following data.

You execute the following statement:
SELECT Name FROM Product WHERE Quantity IS NOT NULL
How many rows are returned?

A. 0
B. 1
C. 2
D. 3
E. 4

Show Suggested Answer

Suggested Answer: D 🗳️

by leonardo at Nov. 18, 2019, 1:36 p.m.

Comments

Submit Cancel

Hunt5ta

Highly Voted 5 years, 6 months ago

This would be the right answer because in SQL Server if a cell were to be empty it would default be null. Proof: I did it in SQL server

upvoted 11 times

...

alperezs

Most Recent 3 years ago

Trick question. I can't insert row 4 with an empty value in an entire column. The answer is D.

upvoted 1 times

...

Morgane

3 years, 8 months ago

No expert here but the answer makes sense to me if NOT NULL means that a column value is required and NULL means column value is optional. Even 0 is a value.

upvoted 1 times

...

samuraipizza26

3 years, 12 months ago

I don't know about your experience but for me it is impossible to have an "empty" INT field. It is NULL and just showing empty in this image. C is the answer.

upvoted 1 times

...

Nate_DB

4 years, 3 months ago

The answer is wrong. Run this for the proof: CREATE TABLE #Temp (A INT, B VARCHAR(5)) -- INSERT INTO #Temp (A,B) select 1, 'abc' union select 2, '' union select 3, null union select 4, 'dd' select * from #Temp select * from #Temp where b is not null select * from #Temp where b <> '' select * from #Temp where ISNULL(b,'') <> ''

upvoted 1 times

...