ORACLE数据库期末考试题目及答案.docxVIP

ORACLE数据库期末考试题目及答案

姓名：__________考号：__________

一、单选题(共10题)

1.什么是SQL语言的主要功能？()

A.数据库设计

B.数据库维护

C.数据查询与操作

D.数据库安全

2.在ORACLE数据库中，如何创建一个名为EMPLOYEES的表，包含EMPLOYEE_ID（主键）、NAME和DEPARTMENT三个字段？()

A.CREATETABLEEMPLOYEES(EMPLOYEE_IDNUMBERPRIMARYKEY,NAMEVARCHAR2(100),DEPARTMENTVARCHAR2(100));

B.CREATETABLEEMPLOYEES(EMPLOYEE_IDINTPRIMARYKEY,NAMEVARCHAR(100),DEPARTMENTVARCHAR(100));

C.CREATETABLEEMPLOYEES(EMPLOYEE_IDINTPRIMARYKEY,NAMETEXT,DEPARTMENTTEXT);

D.CREATETABLEEMPLOYEES(EMPLOYEE_IDNUMBERPRIMARYKEY,NAMEVARCHAR(100),DEPARTMENTVARCHAR(100),CONSTRAINTPK_EMPLOYEESPRIMARYKEY(EMPLOYEE_ID))

3.以下哪个命令可以用来删除ORACLE数据库中的表？()

A.DROPTABLE

B.DELETETABLE

C.ERASETABLE

D.REMOVETABLE

4.在ORACLE数据库中，如何查询所有部门的员工姓名？()

A.SELECTNAMEFROMEMPLOYEESWHEREDEPARTMENT=SALES;

B.SELECTNAMEFROMEMPLOYEESWHEREDEPARTMENTIN(SALES,MARKETING,IT);

C.SELECTNAMEFROMEMPLOYEESWHEREDEPARTMENTLIKE%SALES%;

D.SELECTNAMEFROMEMPLOYEESGROUPBYDEPARTMENT;

5.在ORACLE数据库中，如何更新一个名为EMPLOYEES的表的NAME字段？()

A.UPDATEEMPLOYEESSETNAME=JohnDoe;

B.UPDATEEMPLOYEESSETNAME=JohnDoeWHEREEMPLOYEE_ID=1;

C.MODIFYEMPLOYEESNAME=JohnDoe;

D.ALTERTABLEEMPLOYEESMODIFYNAME=JohnDoe;

6.在ORACLE数据库中，如何创建一个视图来显示所有部门的员工姓名和部门名称？()

A.CREATEVIEWEMPLOYEE_DEPARTMENTSASSELECTNAME,DEPARTMENTFROMEMPLOYEES;

B.CREATEVIEWEMPLOYEE_DEPARTMENTS(NAME,DEPARTMENT)ASSELECTNAME,DEPARTMENTFROMEMPLOYEES;

C.CREATEVIEWEMPLOYEE_DEPARTMENTSASSELECTNAME,DEPARTMENTFROMEMPLOYEESWHEREDEPARTMENTISNOTNULL;

D.CREATEVIEWEMPLOYEE_DEPARTMENTSASSELECTNAME,DEPARTMENTFROMEMPLOYEESGROUPBYNAME,DEPARTMENT;

7.在ORACLE数据库中，如何创建一个索引来提高查询性能？()

A.CREATEINDEXINDEX_NAMEONTABLE_NAME(COLUMN_NAME);

B.CREATEINDEXINDEX_NAMEFORTABLE_NAME(COLUMN_NAME);

C.INDEXINDEX_NAMEONTABLE_NAME(COLUMN_NAME);

D.ALTERINDEXINDEX_NAMEONTABLE_NAME(COLUMN_NAME);

8.在ORACLE数据库中，如何将一个名为EMPLOYEES的表中的数据备份到另一个名为EMP