EMP 表 EMP 表
列名称 定义 列名称 定义
Empno NUMBER(4),PK Deptno NUMBER(2)
Ename VARCHAR2(10) Dname VARCHAR2(14)
Job VARCHAR2(9) Loc VARCHAR2(13)
Mgr NUMBER(4)
Hiredate DATE
Sal NUMBER(7,2)
Comm NUMBER(7,2)
Deptno NUMBER(2),FK
Empno—-Employee
Ename—-Employee Name
Job—-Job Title
Mgr—-Manager of Employee
Hiredate—-Hire date
Sal—-Salary(每月)
Comm—-Commission(销售)
Deptno—-Department Number
Dname—-Department Name
Loc—-Location of Operation
1.下面哪两个查询可以用来确定员工 Blake 所在部门的名称?
a.SELECT dname FROM dept WHERE ename =(‘BLAKE’);
b.SELECT d. dname FROM dept d NATURAL JOIN emp e
WHERE e.ename =‘BLAKE’;
c.SELECT dname FROM dept d,emp e
WHERE e.ename =(‘BLAKE’)
AND d.deptno = e.deptno;
d.SELECT dname FROM dept JOIN emp USING (dname)
WHERE ename =‘BLAKE’;
e.SELECT dname FROM dept JOIN emp
ON dept.deptno = emp.deptno
WHERE ename =‘BLAKE’;
2.如果 Sal 包含各个员工的月薪,那么下面哪一个查询将显示 EMP 表中的各个员工的年薪?
a.SELECT sal * 12 ‘Annual Salary’FROM emp;
b.SELECT salary * 12 ‘annual FROM emp;
c.SELECT annual sal * 12 FROM emp;
d.SELECT sal * 12 FROM emp;
3.下面哪一个查询将显示存储在 EMP 表中的所有数据?
a.SELECT * FROM emp;
b.SELECT % FROM emp;
c.SELECT ^ FROM emp;
评论0