Which Of The Following Queries Are Legal #631
Which of the following queries are legal?
This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Database Programming Techniques - Rapid Application Development - Quiz No.1.
Which of the following queries are legal?
SELECT deptno, count(deptno) FROM emp GROUP BY ename;
SELECT deptno, count(deptno), job FROM emp GROUP BY deptno;
SELECT deptno, avg(sal) FROM emp;
SELECT deptno, avg(sal) FROM emp GROUP BY deptno;
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes