Examine the data in the PRODUCTS table:
Examine these queries:
Which queries generate the same output?
A. 1 and 2
B. 1 and 3
C. 1, 2, and 3
D. 2 and 3
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Examine the data in the PRODUCTS table:
Examine these queries:
Which queries generate the same output?
A. 1 and 2
B. 1 and 3
C. 1, 2, and 3
D. 2 and 3
|
Download Printable PDF. VALID exam to help you PASS. |
|
A is the true answer,tested
syntax wise both 1 and 3 are correct but ALL operator will return zero rows. If the “=” operator is removed in 2 and then option 1 and 2 will produce same results
Correct answer is A
the third query will return no rows
Answer will be A, if typo in 2nd statement is corrected. “list = IN” should be “list IN”. 3rd statement returns 0 rows
request 2 typo. “IN”, but not ” = IN ”
3 request is not satisfied because “= all (10, 20)” is not true. The query will return 0 records.