Oracle公司Oracle9i笔试题面试题D.doc

题目内容:EMP表EMP表列名称定义列名称定义EmpnoNUMBER(4),PKDeptnoNUMBER(2)EnameVARCHAR2(10)DnameVARCHAR2(14)JobVARCHAR2(9)LocVARCHAR2(13)MgrNUMBER(4)HiredateDATESalNUMBER(7,2)CommNUMBER(7,2)DeptnoNUMBER(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 Operation1.下面哪一个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_vuAS SELECT empno,ename,sal,comm FROM empWITH READ ONLY;b.REPLACE VIEW emp_sal_vu WITH READ ONLY;c.ALTER VIEW emp_vu READ ONLY;d.CREATE OR REPLACE emp_sal_vuAS SELECT empno,ename,sal,comm FROM empWITH 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 eejobs30AS SELECT empno,ename,jobFROM emp WHERE deptno = 30WITH CHECK OPTION;b.CREATE OR REPLACE VIEW eejobs30AS SELECT empno,ename,jobFROM emp WHERE deptno = 30WITH READ ONLY;c.CREATE VIEW eejobs30AS SELECT empno,ename,jobFROM emp WHERE deptno = 30WITH READ ONLY;d.CREATE OR REPLACE VIEW eejobs30AS SELECT empno,ename,jobFROM emp WHERE deptno = 308.下面关于简单和复杂视图的说法中,哪一种说法是错误的?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_grosspayAS SELECT empno,ename,sal + NVL(comm,0)FROM emp;b.CREATE VIEW inline_grosspay ASinline SELECT empno,ename,sal + NVL(comm,0)FROM emp;c.CREATE VIEW inline_grosspayAS SELECT empno,ename,sal + NVL(comm,0)FROM emp;d.SELECT empno,ename,dnameFROM(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_grosspayAS SELECT empno,ename,sal +NVL (comm,0)FROM emp;b.CREATE VIEW inline_grosspay ASinline SELECT empno,ename,sal + NVL (comm,0)FROM emp;c.CREATE VIEW inline_grosspayAS SELECT empno,ename,sal + NVL (comm,0)FROM emp;d.SELECT empno,ename,dnameFROM(SELECT * FROM emp NATURAL JOIN dept);16.下面哪一个术语用来说明属于一个特定用户的对象集合?a.用户帐b.角色c.数据字典d.架构17.下面哪些命令允许用户更改他自己的密码?选出所有正确的答案.a.ALTER USER IDENTIFIDE BYb.PASSWORDc.CREATE USER IDENTIFIDE BYd.ALTER USER PASSWORD18.下面哪一个命令禁止用户服务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 RESTRI