Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 203

Examine this query and its output:

Examine this query with an incomplete WHERE clause:

Which two are true about operators that can be used in the WHERE clause? (Choose two.)

Using <> ANY will display all the product names except the product named Fork.

Using IN will display all the product names.

Using NOT IN or <> ANY will give the same result.

Using <> ANY will display all the product names.

Using NOT IN or <> ANY will give the same result.

Correct Answer: B, D

Using IN will display all the product names because the product list values present in the subquery will match all the product names in the main query. Using <> ANY will display all the product names because it's effectively looking for any values that are not equal to any value in the list, but since it's a comparison against the same table, it results in all rows being selected.

Discussion

lucemqy

E would be correct if it's NOT IN and <> ALL

kesammy9Option: A

A is a correct answer Using NOT IN or <> ANY will not give the same result.

McromeoOption: A

Only A is correct

lucemqyOption: A

A is correct

jm9999Options: CE

Maybe E is supposed to be using IN ..., then it would work.

jm9999

if C or E said will NOT give the same result then that would be true.

Sathitest071Options: AC

Answer is A and Using NOT IN or <> ANY will not give the same result. create table products ( prod_id number, prod_name varchar2(10), prod_list number) insert into products values( 101, 'Plate', 10); insert into products values( 102, 'Cup', 20); insert into products values( 103, 'Saucer', 30); insert into products values( 104, 'Knife', 40); insert into products values( 105, 'Fork', ''); select prod_name from products where prod_list not in (select prod_list from products) select prod_name from products where prod_list <> any (select prod_list from products)