The CUSTOMERS table has these columns: Which statement finds the rows in the CUSTOMERS table that do not have a postal code?

The correct answer is C. SELECT customer_id, customer_name. This statement returns the rows in the CUSTOMERS table that do not have a postal code. The correct syntax to check NULL values is usage of "IS NULL" clause. Incorrect Answers A: "CONTAINS NULL" is incorrect clause in Oracle. B: This statement will just check if postal code…

Restricting and Sorting Data

Question

The CUSTOMERS table has these columns:

Which statement finds the rows in the CUSTOMERS table that do not have a postal code?

Exhibit

Options

ASELECT customer_id, customer_name
BSELECT customer_id, customer_name
CSELECT customer_id, customer_name
DSELECT customer_id, customer_name
ESELECT customer_id, customer_name

How the community answered

(26 responses)

A
12% (3)
B
8% (2)
C
77% (20)
D
4% (1)

Explanation

This statement returns the rows in the CUSTOMERS table that do not have a postal code. The correct syntax to check NULL values is usage of "IS NULL" clause. Incorrect Answers A: "CONTAINS NULL" is incorrect clause in Oracle. B: This statement will just check if postal code equals to string `________'; D: Usage of "IS NVL" is incorrect in Oracle. But there is a function NVL() you can use to process E: You can not use equal comparison to check whether value is NULL or not. Use construction "IS NULL" or "IS NOT NULL" to do that.

Topics

#IS NULL#NULL handling#WHERE clause#filtering

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice