Gate CS-2012 Question Paper With Solutions

Q. 15 Which of the following statements are TRUE about an SQL query?P: An SQL query can contain a Having clause even if it does not have a GROUP BY clause
Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause
R: All attributes used in the GROUP BY clause must appear in the SELECT clause
S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause

(A) P and R

(B) P and S

(C) Q and R

(D) Q and S

Answer: (B)

Explanation:

Gate CS-2012 Question Paper With Solutions Gate CS-2012 Question Paper With Solutions

Gate CS-2012 Question Paper With Solutions

Learn More:   Gate CS-2016-2 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here