oracle部分面试题-DBA数据库管理员JAVA程序员架构师必看

数据库面试题,ORACLE面试题,MSSQL面试题,DBA数据库管理员面试题,华为DBA面试题,JAVA程序员面试必看

-DBA数据库管理员JAVA程序员架构师必看

面试题一（厦门）

Table: （员工emp1）

id name

1 a

2 b

3 c

4 d

Table:( 性别 sext)

id sex

1 男

4 女

5 男

找出忘记填写性别的员工（用 Oracle 的两种方式）

select id ,name from emp1 e where e.id not in(select id from sext);

select id from emp1 minus select id from sext;

select * from emp1 e where e.id <> all(select id from sext);

select e.* from emp1 e,(select id from emp1 minus select id from sext) s where e.id = s.id; select e.id,e.name from emp1 e,sext s where e.id=s.id(+) and s.sex is null;

select * from emp1 left outer join sext on emp1.id = sext.id where sext.sex is null;

select * from emp1 e where not exists(select * from sext s where e.id

= s.id);

select * from emp1 where id not in (select emp1.id from emp1, sext where emp1.id = sext.id); select name from emp1 where id not in (select id from emp1 intersect select id from sext); SELECT

*

FROM emp1 e WHERE (SELECT COUNT(*)

FROM

(SELECT id FROM emp1 UNION ALL SELECT id FROM sext) t

WHERE t.id = e.id) <2;

面试题二（上海）

表一(AAA)

商品名称 mc 商品总量 sl

A 100

B 120

表二(BBB)

商品名称 mc 出库数量 sl

A 10

A 20