IT公司面试手册

• 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.下面哪一个SQL语句将创建一个用户名为ACCTSUPER、密码为SUPERPWORD的新用户？

a.CREATE USER acctsuper PASSWORD superpword;

b.CREATE USER acctsuper PASS superpword;

c.CREATE USER acctsuper IDENTIFIED BY superpword;

d.CREATE acctsuper WITH PASSWORD superpword;

2.下面哪一个SQL语句将生成EMP_FMPNO序列中的下一个值?

a.SELECT emp_empno.nextvalue FROM dual;

b.SELECT emp_empno.currentvalue FROM dual;

c.SELECT emp_empno.nextval FROM dual;

d.SELECT emp_empno.currentval FROM dual;

3.下面哪一个SQL语句将修改现有的视图EMP_SAL_VU,使用户不能更新它显示的数据?

a.CREATE OR REPLACE VIEW emp_sal_vu

AS SELECT empno,ename,sal,comm FROM emp

WITH READ ONLY;

b.REPLACE VIEW emp_sal_vu WITH READ ONLY;

c.ALTER VIEW emp_vu READ ONLY;

d.CREATE OR REPLACE  emp_sal_vu

AS SELECT empno,ename,sal,comm FROM emp

WITH CHECK OPTION;

4.在发生下面哪些情况时,Oracle9i将自动创建一个索引?选出所有正确的答案.

a.创建一个序列

b.创建一个PRIMARY KEY约束

c.成功执行CREATE INDEX命令

d.创建一个PUBLIC同义词

5.下面哪一项可以包括在一个简单视图中?

a.组合的数据

b.联接的表

c.SUM函数

d.列别名

6.下面哪些SQL命令向名为ACCTSUPER的用户授予系统权限?选出所有正确的答案.

a.GRANT INSERT ON emp TO acctsuper;

b.GRANT CREATE TABLE TO acctsuper;

c.GRANT SELECT ON emp TO acctsuper;

d.GRANT UPDATE ANY TABLE TO acctsuper;

e.GRANT CREATE SESSION TO acctsuper;

7.下面哪一个SQL命令将创建一个视图,该视图禁止用户执行任何这样的操作:使视图以后无法访问视图当前显示的行?

a.XREATE VIEW eejobs30

AS SELECT empno,ename,job

FROM emp WHERE deptno = 30

WITH CHECK OPTION;

b.CREATE OR REPLACE VIEW eejobs30

AS SELECT empno,ename,job

FROM emp WHERE deptno = 30

WITH READ ONLY;

c.CREATE VIEW eejobs30

AS SELECT empno,ename,job

FROM emp WHERE deptno = 30

WITH READ ONLY;

d.CREATE OR REPLACE VIEW eejobs30

AS SELECT empno,ename,job

FROM emp WHERE deptno = 30

8.下面关于简单和复杂视图的说法中,哪一种说法是错误的?

a.在非key-preserved表上不允许DML操作

b.如果一行违反了底层的约束,那么不能通过视图将它添加到表中

c.不能通过视图向表添加NULL值

d.在包含伪列ROWNUM的简单视图上允许DML操作

9.下面哪一个SQL语句需要用户在下次访问他的账号时创建一个新密码?

a.CREATE USER acctsuper IDENTIFIFD BY NULL;

b.ALTER USER acctsuper PASSWORD EXPIRE;

c.ALTER USER acctsuper  EXPIRE PASSWORD;

d.CREATE USER acctsuper IDENTIFIFD BY PASSWORD EXPIRE;

10.下面哪一个SQL语句将在执行时创建一个内联视图?

a.CREATE FORCE VIEW inline_grosspay

AS SELECT empno,ename,sal + NVL(comm,0)

FROM emp;

b.CREATE VIEW inline_grosspay AS

inline SELECT empno,ename,sal + NVL(comm,0)

FROM emp;

c.CREATE VIEW inline_grosspay

AS SELECT empno,ename,sal + NVL(comm,0)

FROM emp;

d.SELECT empno,ename,dname

FROM(SELECT * FROM emp NATURAL JOIN dept);

11.下面哪一个SQL语句将删除PUBLIC同义词名称EMPLOEE?

a.DELETE SYNONYM employee;

b.DROR SYNONYM employee;

c.DROR PUBLIC SYNONYM employee;

d.DELETE PUBLIC SYNONYM employee;

e.DROR PUBLIC employee;

12.以下关于索引的说法哪一个是正确的?

a.在使用索引时,行检索总是更慢

b.当表的主键上存在一个索引时,DML操作总是更快

c.索引总是使DML操作变慢

d.基于函数的索引将自动使查询执行得更慢

13.下面哪一个术语应用于一组权限或一个权限集合?

a.架构

b.角色

c.数据字典

d.权限

e.组账号

14.下面哪一个命令将向两个用户Smith和Blake授予CONNECT角色?

a.GRANT CONNECT ON database TO SMITH BLAKE;

b.GRANT CONNECT TO SMITH BLAKE;

c.GRANT CONNECT TO ‘SMITH’,’ BLAKE’;

d.GRANT CONNECT TO SMITH, BLAKE;

15.下面哪一个命令即使在底层的表不存在时也将创建一个视图?

a.CREATE FORCE VIEW inline_grosspay

AS SELECT empno,ename,sal +NVL (comm,0)

FROM emp;

b.CREATE VIEW inline_grosspay AS

inline SELECT empno,ename,sal + NVL (comm,0)

FROM emp;

c.CREATE VIEW inline_grosspay

AS SELECT empno,ename,sal + NVL (comm,0)

FROM emp;

d.SELECT empno,ename,dname

FROM(SELECT * FROM emp NATURAL JOIN dept);

16.下面哪一个术语用来说明属于一个特定用户的对象集合?

a.用户帐

b.角色

c.数据字典

d.架构

17.下面哪些命令允许用户更改他自己的密码?选出所有正确的答案.

a.ALTER USER… IDENTIFIDE BY

b.PASSWORD

c.CREATE USER… IDENTIFIDE BY

d.ALTER USER… PASSWORD

18.下面哪一个命令禁止用户服务SMITH查看存储在EMP表中的数据,但仍然允许他访问DEPT表?

a.REVOKE select ON emp FROM smith;

b.LOCK TABLE emp FROM smit;

c.REVOKE SELECT ANY TABLE FROM smith;

d.ALTER USER smith RESTRICTED ACCESS on emp;

19.下面哪一个命令可以用来修改一个视图?

a.ALTER VIEW

b.MODIEY VIEW

c.ALTER VIEW… MODIEY

d.ALTER TABLE… MODIEY VIEW

e.不能修改视图

20.下面哪一个子句不能与ALTER SEQUENCE命令一起使用?

a.INCREMENT BY

b.START WITH

c.CACHE

d.NOMAXVALUE