Gate Exam Programming Database

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

option
(A) P and R
(B) P and S
(C) Q and R
(D) Q and S

Read Solution (Total 1)

Answer is Q and S
8 years agoHelpfull: Yes(0) No(1)

Gate Other Question

Given the b asic ER and relational models, which of the following is INCORRECT?
(A) An attribute of an entity can have more than one value
(B) An attribute of an entity can be composite
(C) In a row of a relational table, an attribute can have more than one value
(D) In a row of a relational table, an attribute can have exactly one value or a NULL value
The recurrence relation capturing the optimal execution time of the Towers of Hanoi problem with n discs is

option
(A) T(n) = 2T(n - 2) + 2
(B) T(n) = 2T(n - 1) + n
(C) T(n) = 2T(n/2) + 1
(D) T(n) = 2T(n - 1) + 1