EMP: NUMBER (4) EMPNO VARCHAR2 (10) ΕΝΑΜΕ VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7, 2) SAL NUMBER (7, 2) СOMM NUMBER (2) DE PTNΟ DEPT: NUMBER (2) DE PTNΟ VARCHAR2 (14) DNAME VARCHAR2...


(check all that apply) Find all the employees located in Dallas
A) select ename from dept where loc = 'DALLAS';
B) select ename from dept, emp where dept.depto = emp.deptno and loc = 'DALLAS';
C) select ename from dept, emp where loc = 'DALLAS';
D) select ename from emp where loc = 'DALLAS';
E) select ename from emp where deptno in (select deptno from dept where loc = 'DALLAS');


EMP:<br>NUMBER (4)<br>EMPNO<br>VARCHAR2 (10)<br>ΕΝΑΜΕ<br>VARCHAR2 (9)<br>JOB<br>NUMBER (4)<br>MGR<br>HIREDATE<br>DATE<br>NUMBER (7, 2)<br>SAL<br>NUMBER (7, 2)<br>СOMM<br>NUMBER (2)<br>DE PTNΟ<br>DEPT:<br>NUMBER (2)<br>DE PTNΟ<br>VARCHAR2 (14)<br>DNAME<br>VARCHAR2 (13)<br>LOC<br>

Extracted text: EMP: NUMBER (4) EMPNO VARCHAR2 (10) ΕΝΑΜΕ VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7, 2) SAL NUMBER (7, 2) СOMM NUMBER (2) DE PTNΟ DEPT: NUMBER (2) DE PTNΟ VARCHAR2 (14) DNAME VARCHAR2 (13) LOC

Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here