Oracle9i笔试题面试题D

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


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