Explanation:With is used to create temporary relation and its not a aggregate function. 9. The EXISTS keyword will be true if:
A. Any row in the subquery meets the condition only.
B. All rows in the subquery fail the condition only.
C. Both of these two conditions are met.
D. Neither of these two conditions is met.
Answer:A
Explanation:With is used to create temporary relation and its not a aggregate function. 9. The EXISTS keyword will be true if:
A. Any row in the subquery meets the condition only. B. All rows in the subquery fail the condition only. C. Both of these two conditions are met. D. Neither of these two conditions is met.
Explanation:EXISTS keyword checks for existance of condition. 10. How can you find rows that do not match some specified condition?