Home / Engineering / Database Management System (DBMS) / Question

M

Mr. Dubey • 51.62K Points
Coach 

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;
Correct answer : Option (D) - select deptno, avg(sal) from emp group by deptno;

Share

Previous

Next

Discusssion

Login to discuss.

Related MCQs on Database Management System (DBMS)

Q. Which of the following is not an example of a constituency that makes up the specific environment?

Q. What is the space complexity of the following dynamic programming implementation used to find the minimum number of jumps?

Q. A centralised system keeps decision making firmly at the top of the hierarchy

Q. When arguments are passed by value, the function works with the original arguments in the calling program.

Q. Cohesion is a qualitative indication of the degree to which a module

Q. A ____________ on this pin indicates a memory operation

Q. Which of the following is a Web service that can publish messages from an application and deliver them to other applications or to subscribers?

Q. The bit is used to indicate the validity of the page.

Q. Which one is true for unconditional disk formatting?

Q. A static constructor_____________.