ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam
Go to Exam

Exam 1z0-082 topic 1 question 149 discussion

Actual exam question from Oracle's 1z0-082
Question #: 149
Topic #: 1
[All 1z0-082 Questions]

Examine the description of the PRODUCT_INFORMATION table:



Which query retrieves the number of products with a null list price?

  • A. SELECT COUNT(list_price) FROM product_information WHERE list_price IS NULL;
  • B. SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;
  • C. SELECT COUNT(DISTINCT list price) FROM product_information WHERE list_price IS NULL;
  • D. SELECT COUNT(list_price) FROM product_information WHERE list_price = NULL;
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by j_tw at April 23, 2023, 12:43 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Oracle2020
3 months ago
I agree B
upvoted 1 times
...
nautil2
10 months, 2 weeks ago
Selected Answer: B
A – false; function COUNT does not cover NULL values in its output B – true; NULLs become zeros and COUNT counts up all zero values, which is the same as the number of NULL values C – false; DISTINCT NULL is still NULL, see A D – false, NULL value is examined with WHERE IS NOT NULL and also see feature mentioned in A
upvoted 1 times
...
lchdb
12 months ago
Selected Answer: B
B ! :)
upvoted 1 times
...
Juv07
1 year, 1 month ago
Correct Answer is B. Count function can't calculate NULL
upvoted 1 times
...
j_tw
1 year, 2 months ago
Selected Answer: B
B is correct. COUNT function can calculate NULL only it use asterik. COUNT(*) : can count NULL COUNT(Column Name) : cannot count NULL
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago