Oracle选择题复习(带答案)(精品文档).docxVIP

Oracle选择题复习(带答案)(精品文档)

姓名：__________考号：__________

一、单选题(共10题)

1.什么是SQL语句中的SELECT语句？()

A.用于插入数据的语句

B.用于查询数据的语句

C.用于删除数据的语句

D.用于更新数据的语句

2.在Oracle中，如何创建一个名为EMPLOYEES的表，其中包含EMPLOYEE_ID（主键）和NAME（字符串类型）两个字段？()

A.CREATETABLEEMPLOYEES(EMPLOYEE_IDNUMBERPRIMARYKEY,NAMEVARCHAR2(100))

B.CREATETABLEEMPLOYEES(EMPLOYEE_IDINTPRIMARYKEY,NAMETEXT)

C.CREATETABLEEMPLOYEES(EMPLOYEE_IDNUMBER,NAMEVARCHAR2(100)PRIMARYKEY)

D.CREATETABLEEMPLOYEES(EMPLOYEE_IDINT,NAMETEXTPRIMARYKEY)

3.在Oracle中，如何删除一个名为EMPLOYEES的表？()

A.DROPTABLEEMPLOYEES

B.DELETETABLEEMPLOYEES

C.TRUNCATETABLEEMPLOYEES

D.ALTERTABLEEMPLOYEESDROP

4.在Oracle中，如何更改现有表中的字段类型？()

A.ALTERTABLEtable_nameADDcolumn_namenew_data_type

B.ALTERTABLEtable_nameMODIFYcolumn_namenew_data_type

C.UPDATEtable_nameSETcolumn_name=new_data_type

D.INSERTINTOtable_name(column_name)VALUES(new_data_type)

5.在Oracle中，如何将一个名为EMPLOYEE_ID的字段从表EMPLOYEES中设置为NOTNULL？()

A.ALTERTABLEEMPLOYEESSETEMPLOYEE_IDNOTNULL

B.UPDATEEMPLOYEESSETEMPLOYEE_IDISNOTNULL

C.ALTERTABLEEMPLOYEESMODIFYEMPLOYEE_IDNOTNULL

D.INSERTINTOEMPLOYEES(EMPLOYEE_ID)VALUES(NULL)

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

A.CREATEVIEWEMPLOYEES_VIEWASSELECTNAME,DEPARTMENT_NAMEFROMEMPLOYEES

B.CREATEVIEWEMPLOYEES_VIEWASSELECTNAME,DEPARTMENTFROMEMPLOYEES

C.CREATEVIEWEMPLOYEES_VIEWASSELECTNAME,DEPT_NAMEFROMEMPLOYEES

D.CREATEVIEWEMPLOYEES_VIEWASSELECTNAME,DEPTFROMEMPLOYEES

7.在Oracle中，如何对表中的数据进行排序？()

A.ORDERBYcolumn_nameASC

B.SORTBYcolumn_nameDESC

C.SORTORDERcolumn_nameASC

D.ORDERBYcolumn_nameDESC

8.在Oracle中，如何使用子查询来查找特定部门中薪水最高的员工？()

A.SELECT*FROMEMPLOYEESWHEREDEPARTMENT=(SELECTMAX(SALARY)FROMEMPLOYEES)

B.SELECT*FROMEMPLOYEESWHEREDEPARTMENT=(SELECTMIN(SALARY)FROMEMPLOYEES)

C.SELECT*FROMEMPLOYEESWHEREDEPARTMENT=(SELECTAVG(SALARY)FROMEMPLOYEES)

D.SELECT*FROMEMPLOYEESWHEREDEPARTMENT=(SE