How many rows are returned?

Posted by: Pdfprep Category: 98-364 Tags: , ,

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

Answer: D

Leave a Reply

Your email address will not be published.