[Solved] Which of the following queries are legal?

McqMate

Q.	Which of the following queries are legal?
A.	select deptno, count(deptno) from emp group by ename;
B.	select deptno, count(deptno), job from emp group by deptno;
C.	select deptno, avg(sal) from emp;
D.	select deptno, avg(sal) from emp group by deptno;
Answer» D. select deptno, avg(sal) from emp group by deptno;

4.1k

0

Do you find this helpful?

25

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

Ranking of queries is done by which of the following?
Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?
Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?
The operator takes the results of two queries and returns only rows that appear in both result sets.
provides option for entering SQL queries as execution time, rather than at the development stage.
After conversion of high level queries into low level commands for file access and is called compiled_____:
Which of the following is a legal expression in SQL?
Which of the following creates a temporary relation for the query on which it is deﬁned?
Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?
Which of the following is the formal process for deciding which attributes should be grouped together in a relation?