Which of the following statements are true? (A) Where condition in SQL can include aggregate functions. (B) Having condition in SQL can include aggregate functions. (C) SQL set operators tend to combine columns from two or more tables. (D) GROUP BY function is used to group rows of a table that contain the same values in a specified column. (E) Minus operator is also known as intersect operator. Choose the correct answer from the options given below:

Question

cdquestions Admin · Accepted Answer

(B) and (D) only

ENO	SALARY
A101	4000
B109	NULL
C508	6000
A305	2000

List-I	List-II
(A) SUBSTR()	(II) To extract a substring from a string.
(B) TRIM()	(IV) To remove spaces from both sides of the string.
(C) INSTR()	(I) To find the position of a substring in a string.
(D) LEFT()	(III) To extract characters from the left side of the string.

LIST-I (Rules of Deduction)	LIST-II (Examples)
A. Modus Ponens	III. P $\Rightarrow$ Q, P, Therefore, Q
B. Modus Tollens	I. P $\Rightarrow$ Q, $\neg$ Q, Therefore, $\neg$ P
C. Hypothetical Syllogism	IV. P $\Rightarrow$ Q, Q $\Rightarrow$ R, Therefore, P $\Rightarrow$ R
D. Disjunctive Syllogism	II. P $\vee$ Q, $\neg$ P, Therefore, Q

The Correct Option is C

Solution and Explanation

Top Questions on SQL

Questions Asked in CUET exam