Oracle笔试常见选择题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
Oracle笔试常见选择题A
1、答案（每题10分，有多选）：
12345678910
2、
1、在EMPLOYEES 和DEPARTMENTS表里检查下列数据。EMPLOYEES
LAST_NAME DEPARTMENT_ID SALARY
Getz 10 3000
Davis 20 1500
King 20 2200
Davis 30 5000
Kochhar 5000
DEPARTMENT_ID DEPARTMENT_NAME
10 Sales
20 Marketing
30 Accounts
40 Administration
如果你想获得所有的employees，不管他们是否匹配部门表中的部门，那么下面选项中哪个查询语句是正确的？
A．SELECT last_name,department_name FROM employees,departments(+);
B．SELECT last_name,department_name FROM employees JOIN departments(+);
C．SELECT last_name,department_name FROM employees(+) e JOIN departments d ON(e.department_id = d.department_id);
D．SELECT last_name,department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id =
d.department_id);
E．SELECT last_name,department_name FROM employees(+),departments ON (e.department_id = d.department_id);
F．SELECT last_name,department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id =
d.department_id);
2、查看下列EMPLOYEES表的结构。
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
下面哪3个选项可以插入一行到该表中？
A．INSERT INTO employees VALUES (NULL,’John’,’Smith’);
B．INSERT INTO employees (first_name,last_name) VALUES (‘John’,’Smith’);
C．INSERT INTO employees VALUES(‘1000’,’John’,’NULL’);
D．INSERT INTO employees(first_name,last_name,employee_id)VALUES (‘1000’,’John’,’NULL’);
E．INSERT INTO employees(employee_id) VALUES (1000);
F．INSERT INTO employees(employee_id,first_name,last_name) VALUES (1000,’John’,’ ’);
3、检查下列EMPLOYEES表中的数据。
LAST_NAME DEPARTMENT_ID SALARY
Getz 10 3000
Davis 20 1500
King 20 2200
Davis 30 5500
下面哪3个子查询是正确的？
A．select * from employees where salary>(select min(salary) from employees group by department.id);
B．select * from employees where salary=(select avg(salary) from employees group by department_id);
C．select distinct from department_id from employees where salary>any (select avg(salary) from employees group by
department_id);
D．select department_id from employees where salary>all (select
avg(salary) from employees group by department_id);
E．select last_name from employees where salary>any(select max(salary) from employees group by department_id);
F．select department_id from employees where salary>all (select avg(salary) from employees group by avg(salary));
4、下面关于视图的说法哪两项是正确的？
A．一个视图可以作为只读的被创建。
B．一个视图可以用来连接两个或更多的表而被创建。