Question:
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:
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:
(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:
Updated On: Apr 19, 2024
- (A) and (C) only
- (C) and (E) only
- (B) and (D) only
- (A), (C) and (E) only
Hide Solution
Verified By Collegedunia
The Correct Option is C
Solution and Explanation
The correct option is(C): (B) and (D) only
Was this answer helpful?
0
0
Top Questions on SQL
Questions Asked in CUET exam
- Who devised the concept of Intelligence Quotient (IQ)?
- CUET (UG) - 2024
- Psychological attributes
- As per data collected in 2011, arrange the following Indian states in terms of child sex-ratio from lowest to highest:
(A) Punjab
(B) Haryana
(C) Tamil Nadu
(D) Sikkim
Choose the correct answer from the options given below:- CUET (UG) - 2024
- Social Inequality and Exclusion
- A molecule X associates in a given solvent as per the following equation:
X ⇌ (X)n
For a given concentration of X, the van’t Hoff factor was found to be 0.80 and the
fraction of associated molecules was 0.3. The correct value of ‘n’ is:- CUET (UG) - 2024
- Solutions
- If \(A = \begin{bmatrix} 3 & 2 \\ -1 & 1 \end{bmatrix} \quad \text{and} \quad B = \begin{bmatrix} -1 & 0 \\ 2 & 5 \\ 3 & 4 \end{bmatrix},\)then \((BA)^T\) is equal to:
- CUET (UG) - 2024
- Matrices
- Two resistances of 100 \(\Omega\) and 200 \(\Omega\) are connected in series across a 20 V battery as shown in the figure below. The reading in a 200 \(\Omega\) voltmeter connected across the 200 \(\Omega\) esistance is _______.
Fill in the blank with the correct answer from the options given below- CUET (UG) - 2024
- Current electricity
View More Questions