Solveeit Logo

Question

DBMS Question on SQL

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 thecorrect answer from the options given below:

A

(A) and (C) only

B

(C) and (E) only

C

(B) and (D) only

D

(A), (C) and (E) only

Answer

(B) and (D) only

Explanation

Solution

The correct option is(C): (B) and (D) only