Question:
Which of the following statement is NOT correct ?
A. By default, ORDER by clause sorts the result set in decreasing order
B. SUM() function is used to count the total no. of records in a table
C. By default, ORDER BY clause sorts the results set in increasing order
D. AVG() is an aggregrate function
E. The WHERE clause is used to specify filtering conditions for groups
Consider the correct answer from the options given below :
Which of the following statement is NOT correct ?
A. By default, ORDER by clause sorts the result set in decreasing order
B. SUM() function is used to count the total no. of records in a table
C. By default, ORDER BY clause sorts the results set in increasing order
D. AVG() is an aggregrate function
E. The WHERE clause is used to specify filtering conditions for groups
Consider the correct answer from the options given below :
A. By default, ORDER by clause sorts the result set in decreasing order
B. SUM() function is used to count the total no. of records in a table
C. By default, ORDER BY clause sorts the results set in increasing order
D. AVG() is an aggregrate function
E. The WHERE clause is used to specify filtering conditions for groups
Consider the correct answer from the options given below :
Updated On: Sep 23, 2024
- A, C and D only
- B, C and D only
- A, B and E only
- A, B and C only
Hide Solution
Verified By Collegedunia
The Correct Option is C
Solution and Explanation
The correct option is (C) :A, B and E only.
Was this answer helpful?
0
0
Top Questions on Query using SQL
- Mohan wants to display all the attributes and all the tupIes of the table 'Teacher', help him to choose the correct SQL statement :
(A) Select % from teacher ;
(B) Select from teacher ;
(C) Select all from teacher ;
(D) Select * from teacher ;
Choose the correct answer from the options given below :- CUET (UG) - 2023
- Computer Science
- Query using SQL
- What will be the output of the given SQL Query SELECT DAY("2023-03-01);
- CUET (UG) - 2023
- Computer Science
- Query using SQL
- What will be returned by the given query ?
SELECT INSTR("DBITBTTSIT", “IT”);- CUET (UG) - 2023
- Computer Science
- Query using SQL
- What is the output of the following SQL query ?
SELECT * FROM STUDENTS WHERE SName like ‘%S’ and age > 18;- CUET (UG) - 2023
- Computer Science
- Query using SQL
Questions Asked in CUET exam
- 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
- Who devised the concept of Intelligence Quotient (IQ)?
- CUET (UG) - 2024
- Psychological attributes
- Two pipes A and B can fill a tank in 32 minutes and 48 minutes respectively. If both the pipes are opened simultaneously, after how much time B should be turned off so that the tank is full in 20 minutes?
- CUET (UG) - 2024
- Time and Work
- 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
- The spin-only magnetic moment of Hexacyanomanganate(II) ion is.........BM
- CUET (UG) - 2024
- Magnetic moment
View More Questions