ORACLE數(shù)據(jù)庫(kù)選擇題

1.下面語(yǔ)句錯(cuò)誤的原因是：Updatedepartmentssetdepartment_id=300wheredepartment_id=60;ERROR位于第1行:ORA-02292:違反完整約束條件(HR.EMP_DEPT_FK)-已找到子記錄日志A.where條件語(yǔ)法錯(cuò)誤B.違反主鍵約束，department_id為300的記錄已經(jīng)存在C.60號(hào)部門下已經(jīng)有員工，修改60號(hào)部門編號(hào)將違反完整性約束條件D.60號(hào)部門不存在答案：C2.下面創(chuàng)建表的語(yǔ)句錯(cuò)在哪里CREATETABLEabcASSelectlast_name,salary*12Fromemployees;A.CREATETABLEabcB.ASC.Selectlast_name,salary*12D.Fromemployees;答案：C3.下列關(guān)于主鍵說法正確的是：A.一個(gè)表只允許一個(gè)主鍵B.一個(gè)表可以有多個(gè)主鍵C.數(shù)據(jù)庫(kù)會(huì)為主鍵自動(dòng)創(chuàng)建對(duì)應(yīng)的唯一索引D.主鍵只表示該字段不允許為空答案：AC4.下面能修改表名字的命令是：A.ALTERTABLERENAMEB.RENAMEC.ALTERTABLEMOVED.ALTERTABLEMODIFY答案：B5.下面那個(gè)SQL命令是用于清空表中數(shù)據(jù)的DDL語(yǔ)句：A.UPDATEB.DELETEC.TRUNCATED.SELECT答案：C6.下面哪條語(yǔ)句可以取出薪水最高的前三個(gè)人：A.select*from(select*fromemployeesorderbysalary);B.select*from(select*fromemployeesorderbysalary)whererownum<=3;C.select*from(select*fromemployeesorderbysalarydesc)whererownum<=3;D.select*fromemployeeswhererownum<=3orderbysalarydesc;答案：C7.下面那個(gè)權(quán)限是連接數(shù)據(jù)庫(kù)所需要的權(quán)限：A.createtableB.createsessionC.createtablespaceD.createdatabase答案：B8.下面哪種情況會(huì)使沒有完成的事務(wù)“隱式”提交：A.執(zhí)行多個(gè)查詢語(yǔ)句B.執(zhí)行CommitC.執(zhí)行createtable命令D.服務(wù)器掉電答案：C9.表CLASSES和表SCHEDULE結(jié)構(gòu)如下:CLASSES：IDNUMBER(9)CLASS_NAMEVARCHAR2(20)TEACHER_IDNUMBER(9)SCHEDULE：CLASS_TIMEDATECLASS_IDNUMBER(9)你建一個(gè)視圖顯示每一課的課名、課時(shí)，并按教師ID排序判斷下面語(yǔ)句將返回何種結(jié)果？CREATEVIEWclass_scheduleASSELECTC.class_nameas“Name”,s.class_timeFROMclassesc,schedulesWHEREC.id=s.class_idORDERBYteacher_id;A.語(yǔ)句創(chuàng)建視圖CLASS_SCHEDULE且可產(chǎn)生預(yù)期結(jié)果.B.“Name”別名有語(yǔ)法錯(cuò)誤C.語(yǔ)法錯(cuò)誤，因?yàn)橐晥D不可基于連接查詢.D.語(yǔ)法錯(cuò)誤，因?yàn)橐晥D不可包含ORDERBY子句.答案：A10.表TEACHER包含如下字段：列名可為空否？數(shù)據(jù)類型TEACHER_IDNOTNULLNUMBER(9)NAMEVARCHAR2(25)SALARYNUMBER(7,2)SUBJECT_IDNOTNULLNUMBER(5)SUBJECT_DESCRIPTIONVARCHAR2(2)你需要將理科教師的工資上浮8%，理科教師的SUBJECT_ID是011，你需用哪一句實(shí)現(xiàn)?A.UPDATEteachersalary=salary*1.08WHEREsubject_id=011B.UPDATEteacherSETsalary=salary*1.08WHEREsubject_id==011C.UPDATEteacherSETsalary=salary*1.08WHEREsubject_id=011D.UPDATEteacherSETsalary=salary*1.08WHEREsubject_idlike‘%011%’11.哪句可以實(shí)現(xiàn)顯示id_number和description，條件滿足訂單時(shí)間order_date在January1,1997以前的，且單價(jià)price小于1.00或者大于5.00的，結(jié)果用訂單時(shí)間降序排列。A.SELECTid_number,descriptionFROMinventoryWHERE(price<1.00ORprice>5.00)ANDorder_date<to_date('yyyy-mm-dd','1997-01-01')ORDERBYorder_dateDESC;B.SELECTid_number,descriptionFROMinventoryWHERE(price<1.00ORprice>5.00)ANDorder_date<to_date('yyyy-mm-dd','1997-01-01')ORDERBYorder_date;C.SELECTid_number,descriptionFROMinventoryWHERE(price<1.00ORprice>5.00)ANDorder_date<to_date('1997-01-01','yyyy-mm-dd')ORDERBYorder_dateASC;D.SELECTid_number,descriptionFROMinventoryWHERE(price<1.00ORprice>5.00)ANDorder_date<to_date('1997-01-01','yyyy-mm-dd')ORDERBYorder_dateDESC;答案：D12.哪一子句可實(shí)現(xiàn)SELECT語(yǔ)句查詢員工平均工資小于5000的部門信息?A.GROUPBYdept_idWHEREAVG(sal)<5000B.GROUPBYAVG(sal)HAVINGAVG(sal)<5000C.GROUPBYdept_idHAVINGAVG(sal)<5000D.GROUPBYAVG(sal)<5000答案：C13.試圖使用下面句子查詢數(shù)據(jù)：SELECT100/NVL(quantity,0)FROMinventory;QUANTITY為null空值時(shí)，將導(dǎo)致出錯(cuò)，其原因是？A.除數(shù)表達(dá)式為空值.B.函數(shù)參數(shù)數(shù)據(jù)類型不一致.C.空值不能被轉(zhuǎn)成實(shí)際值D.除數(shù)表達(dá)式為零.答案：D14.下列哪個(gè)集合操作符返回兩個(gè)查詢所選擇的所有的行。A.UnionB.UnionallC.UniononlyD.connectby答案：B15.有如下SQL片段Deletefromempewheree.hiredate>’14-Dec-09’ande.sal<>‘1’其含義為：A.從表emp中刪除hiredate不小于2009年12月14日，且sal不為1的記錄，一定不可恢復(fù)B.從表emp中刪除hiredate和sal列C.對(duì)表emp中hiredate不小于2009年12月14日，且sal不為1的記錄實(shí)施刪除D.刪除emp表的全部記錄答案：C16.SQL語(yǔ)言中修改表結(jié)構(gòu)的命令是？A.MODIFYTABLEB.MODIFYSTRUCTUREC.ALTERTABLED.ALTERSTRUCTURE答案：C17.Delete和truncate都可以用來刪除表內(nèi)容，以下描述正確的是？A.Truncate不需要rollbacksegmentB.Delete需要rollbacksegmentC.Truncate在提交commit之前仍可回滾D.Truncate還可以刪除表結(jié)構(gòu)答案：AB18.下列屬于DML語(yǔ)句的是A.commitB.updateC.deleteD.creat答案：BC19.從“員工”表的“姓名”字段中找出名字包含“瑪麗”的人，下面哪條select語(yǔ)句正確：A.Select*from員工where姓名=’_瑪麗_’B.Select*from員工where姓名=’%瑪麗_’C.Select*from員工where姓名like‘_瑪麗%’D.Select*from員工where姓名like‘%瑪麗%’答案：D20.Oracle數(shù)據(jù)庫(kù)表空間與數(shù)據(jù)文件的關(guān)系描述正確的是()A.一個(gè)表空間只能對(duì)應(yīng)一個(gè)數(shù)據(jù)文件B.一個(gè)表空間可以對(duì)應(yīng)多個(gè)數(shù)據(jù)文件C.一個(gè)數(shù)據(jù)文件可以對(duì)應(yīng)多個(gè)表空間D.表空間與數(shù)據(jù)文件沒任何對(duì)應(yīng)關(guān)系答案：B21.下面約束中只能定義在列級(jí)的是A.CHECKB.UNIQUEC.NOTNULLD.FOREIGNKEYE.PRIMARYKEY答案：C22.Student表的表結(jié)構(gòu)sid_idnumberstart_datedateend_datedate在start_date列上使用哪些函數(shù)是正確的？A.sum(start_date)B.count(start_date)C.avg(start_date,end_date)D.min(start_date)答案：BD23.下面不是SQL命令的有A.DESCB.ALTERTABLEADD…C.SELECT*FROMTABD.CONNECT答案：AD24.下面對(duì)視圖的作用描述正確的是：A.視圖可以加速數(shù)據(jù)訪問B.視圖可以屏蔽掉對(duì)部分原始數(shù)據(jù)的訪問C.視圖可以降低查詢復(fù)雜度D.視圖可以代替原始數(shù)據(jù)表\答案：BC25.在Oracle中，用于在多個(gè)會(huì)話之間控制對(duì)數(shù)據(jù)的并發(fā)訪問的是A.鎖B.索引C.分區(qū)D.鍵答案：A26.在EMPLOYEES和DEPARTMENTS表里檢查下列數(shù)據(jù)。EMPLOYEESLAST_NAMEDEPARTMENT_IDSALARYGetz103000Davis201500King202200Davis305000Kochhar5000DEPARTMENT_IDDEPARTMENT_NAME10Sales20Marketing30Accounts40Administration如果你想獲得所有的employees的last_name,department_name，不管他們是否匹配部門表中的部門，那么下面的查詢語(yǔ)句正確的是A.SELECTlast_name,department_nameFROMemployeeseJOINdepartmentsdONe.department_id(+)=d.department_id;B.SELECTlast_name,department_nameFROMemployeeseRIGHTOUTERJOINdepartmentsdONe.department_id=d.department_id;C.SELECTlast_name,department_nameFROMemployeese,departmentsdWHEREe.department_id=d.department_id(+)D.SELECTlast_name,department_nameFROMemployeeseLEFTOUTERJOINdepartmentsdONe.department_id=d.department_id;答案：CD27.EMPLOYEES表的結(jié)構(gòu)如下：EMPLOYEE_IDNUMBERPrimaryKeyFIRST_NAMEVARCHAR2(25)LAST_NAMEVARCHAR2(25)下面選項(xiàng)中可以向該表中插入一行數(shù)據(jù)的是A.INSERTINTOemployees(employee_id)VALUES(1000);B.INSERTINTOemployees(first_name,last_name)VALUES(‘John’,’Smith’);C.INSERTINTOemployeesVALUES(1000,’John’,’NULL’);D.INSERTINTOemployeesVALUES(‘1000’,’John’);答案：AC28.檢查下列EMPLOYEES表中的數(shù)據(jù)。LAST_NAMEDEPARTMENT_IDSALARYGetz103000Davis201500King202200Davis305500下面子查詢正確的是A.select*fromemployeeswheresalary>(selectmin(salary)fromemployeesgroupbydepartment.id);B.select*fromemployeeswheresalary=(selec