匿名网友
|
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 |
||
- 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
