數(shù)據(jù)庫應(yīng)用技術(shù)題庫

2：從一個數(shù)據(jù)庫文件中取出滿足某個條件的所有記錄形成一個新的數(shù)據(jù)庫文件的操作是HTMLCONTROLForms.HTML:Option.11.投影操作HTMLCONTROLForms.HTML:Option.12.連接操作HTMLCONTROLForms.HTML:Option.13.選擇操作HTMLCONTROLForms.HTML:Option.14.復(fù)制操作3：下述不是DBA數(shù)據(jù)庫管理員的職責(zé)的是HTMLCONTROLForms.HTML:Option.11.完整性約束說明HTMLCONTROLForms.HTML:Option.12.定義數(shù)據(jù)庫模式HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)庫安全HTMLCONTROLForms.HTML:Option.14.數(shù)據(jù)庫管理系統(tǒng)設(shè)計(jì)4：下面列出的數(shù)據(jù)庫管理技術(shù)發(fā)展的三個階段中，沒有專門的軟件對數(shù)據(jù)進(jìn)行管理的是I．人工管理階段II．文件系統(tǒng)階段III．?dāng)?shù)據(jù)庫階段HTMLCONTROLForms.HTML:Option.11.I和IIHTMLCONTROLForms.HTML:Option.12.只有IIHTMLCONTROLForms.HTML:Option.13.II和IIIHTMLCONTROLForms.HTML:Option.14.只有I5：概念結(jié)構(gòu)設(shè)計(jì)是整個數(shù)據(jù)庫設(shè)計(jì)的關(guān)鍵，它通過對用戶需求進(jìn)行綜合、歸納與抽象，形成一個獨(dú)立于具體DBMS的HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)模型HTMLCONTROLForms.HTML:Option.12.概念模型HTMLCONTROLForms.HTML:Option.13.層次模型HTMLCONTROLForms.HTML:Option.14.關(guān)系模型6：下面關(guān)于函數(shù)依賴的敘述中，不正確的是HTMLCONTROLForms.HTML:Option.11.若X→Y，Y→Z，則X→YZHTMLCONTROLForms.HTML:Option.12.若XY→Z，則X→Z，Y→ZHTMLCONTROLForms.HTML:Option.13.若X→Y，Y→Z，則X→ZHTMLCONTROLForms.HTML:Option.14.若X→Y，Y’包含Y，則X→Y’7：設(shè)計(jì)性能較優(yōu)的關(guān)系模式稱為規(guī)范化，規(guī)范化主要的理論依據(jù)是HTMLCONTROLForms.HTML:Option.11.關(guān)系規(guī)范化理論HTMLCONTROLForms.HTML:Option.12.關(guān)系運(yùn)算理論HTMLCONTROLForms.HTML:Option.13.關(guān)系代數(shù)理論HTMLCONTROLForms.HTML:Option.14.數(shù)理邏輯8：假設(shè)在一個E-R模型中，存在10個不同的實(shí)體集和12個不同的二元聯(lián)系（二元聯(lián)系是指兩個實(shí)體集之間的聯(lián)系），其中3個1：1聯(lián)系、4個1：N、5個M：N聯(lián)系，則這個E-R模型轉(zhuǎn)換成關(guān)系的數(shù)目可能是HTMLCONTROLForms.HTML:Option.11.14HTMLCONTROLForms.HTML:Option.12.15HTMLCONTROLForms.HTML:Option.13.19HTMLCONTROLForms.HTML:Option.14.229：規(guī)范化理論是關(guān)系數(shù)據(jù)庫進(jìn)行邏輯設(shè)計(jì)的理論依據(jù)，根據(jù)這個理論，關(guān)系數(shù)據(jù)庫中的關(guān)系必須滿足：其每一屬性都是HTMLCONTROLForms.HTML:Option.11.互不相關(guān)的HTMLCONTROLForms.HTML:Option.12.不可分解的HTMLCONTROLForms.HTML:Option.13.長度可變的HTMLCONTROLForms.HTML:Option.14.互相關(guān)聯(lián)的10：數(shù)據(jù)庫系統(tǒng)是采用了數(shù)據(jù)庫技術(shù)的計(jì)算機(jī)系統(tǒng)，數(shù)據(jù)庫系統(tǒng)由數(shù)據(jù)庫、數(shù)據(jù)庫管理系統(tǒng)、應(yīng)用系統(tǒng)和HTMLCONTROLForms.HTML:Option.11.系統(tǒng)分析員HTMLCONTROLForms.HTML:Option.12.程序員HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)庫管理員HTMLCONTROLForms.HTML:Option.14.操作員1：SQL語言具有的功能是HTMLCONTROLForms.HTML:Option.11.關(guān)系規(guī)范化HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)定義、數(shù)據(jù)操縱、數(shù)據(jù)控制、數(shù)據(jù)查詢HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)庫系統(tǒng)設(shè)計(jì)HTMLCONTROLForms.HTML:Option.14.能繪制E-R圖2：若要在基本表S中增加一列CN（課程名），可用HTMLCONTROLForms.HTML:Option.11.ADDTABLES（CNCHAR（８））HTMLCONTROLForms.HTML:Option.12.ADDTABLESALTER（CNCHAR（８））HTMLCONTROLForms.HTML:Option.13.ALTERTABLESADD（CNCHAR（８））HTMLCONTROLForms.HTML:Option.14.ALTERTABLES（ADDCNCHAR（８））3：如何構(gòu)造出一個合適的數(shù)據(jù)邏輯結(jié)構(gòu)是（）主要解決的問題。HTMLCONTROLForms.HTML:Option.11.物理結(jié)構(gòu)設(shè)計(jì)HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)字典HTMLCONTROLForms.HTML:Option.13.邏輯結(jié)構(gòu)設(shè)計(jì)HTMLCONTROLForms.HTML:Option.14.關(guān)系數(shù)據(jù)庫查詢4：根據(jù)關(guān)系數(shù)據(jù)庫規(guī)范化理論，關(guān)系數(shù)據(jù)庫中的關(guān)系要滿足第一范式，下面“部門”關(guān)系中，因哪個屬性而使它不滿足第一范式？部門（部門號，部門名，部門成員，部門總經(jīng)理）HTMLCONTROLForms.HTML:Option.11.部門總經(jīng)理HTMLCONTROLForms.HTML:Option.12.部門成員HTMLCONTROLForms.HTML:Option.13.部門名HTMLCONTROLForms.HTML:Option.14.部門號5：在通常情況下，下面的關(guān)系中，不可以作為關(guān)系數(shù)據(jù)庫的關(guān)系是HTMLCONTROLForms.HTML:Option.11.R1（學(xué)生號，學(xué)生名，性別）HTMLCONTROLForms.HTML:Option.12.R2（學(xué)生號，學(xué)生名，班級號）HTMLCONTROLForms.HTML:Option.13.R3（學(xué)生號，班級號，宿舍號）HTMLCONTROLForms.HTML:Option.14.R4（學(xué)生號，學(xué)生名，簡歷）6：一個結(jié)點(diǎn)可以有多個雙親，結(jié)點(diǎn)之間可以有多種聯(lián)系的模型是HTMLCONTROLForms.HTML:Option.11.網(wǎng)狀模型HTMLCONTROLForms.HTML:Option.12.關(guān)系模型HTMLCONTROLForms.HTML:Option.13.層次模型HTMLCONTROLForms.HTML:Option.14.以上都有7：關(guān)系規(guī)范化中的插入操作異常是指HTMLCONTROLForms.HTML:Option.11.不該刪除的數(shù)據(jù)被刪除HTMLCONTROLForms.HTML:Option.12.不該插入的數(shù)據(jù)被插入HTMLCONTROLForms.HTML:Option.13.應(yīng)該刪除的數(shù)據(jù)被刪除HTMLCONTROLForms.HTML:Option.14.應(yīng)該插入的數(shù)據(jù)未被插入8：在下面所列出的條目中，不屬于數(shù)據(jù)庫管理系統(tǒng)的基本功能的是HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)庫定義HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)庫的建立和維護(hù)HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)庫的存取HTMLCONTROLForms.HTML:Option.14.數(shù)據(jù)庫和網(wǎng)絡(luò)中其他軟件系統(tǒng)的通信9：關(guān)系數(shù)據(jù)庫的規(guī)范化理論指出：關(guān)系數(shù)據(jù)庫中的關(guān)系應(yīng)滿足一定的要求，最起碼的要求是達(dá)到1NF，即滿足HTMLCONTROLForms.HTML:Option.11.每個非主屬性都完全依賴于主屬性HTMLCONTROLForms.HTML:Option.12.主屬性唯一標(biāo)識關(guān)系中的元組HTMLCONTROLForms.HTML:Option.13.關(guān)系中的元組不可重復(fù)HTMLCONTROLForms.HTML:Option.14.每個屬性都是不可分解的10：關(guān)系數(shù)據(jù)庫中，實(shí)現(xiàn)實(shí)體之間的聯(lián)系是通過關(guān)系與關(guān)系之間的HTMLCONTROLForms.HTML:Option.11.公共索引HTMLCONTROLForms.HTML:Option.12.公共存儲HTMLCONTROLForms.HTML:Option.13.公共元組HTMLCONTROLForms.HTML:Option.14.公共屬性1：當(dāng)B屬性函數(shù)依賴于A屬性時，屬性A與B的聯(lián)系是HTMLCONTROLForms.HTML:Option.11.1對多HTMLCONTROLForms.HTML:Option.12.多對1HTMLCONTROLForms.HTML:Option.13.多對多HTMLCONTROLForms.HTML:Option.14.以上都不是2：已知關(guān)系R（P，Q，M，N），F(xiàn)是R上成立的函數(shù)依賴集，F(xiàn)={（P→Q，Q→M）}，則R的侯選關(guān)鍵字是HTMLCONTROLForms.HTML:Option.11.PHTMLCONTROLForms.HTML:Option.12.QHTMLCONTROLForms.HTML:Option.13.PQHTMLCONTROLForms.HTML:Option.14.PN3：在SQL語言的SELECT語句中，能實(shí)現(xiàn)投影操作的是HTMLCONTROLForms.HTML:Option.11.SELECTHTMLCONTROLForms.HTML:Option.12.FROMHTMLCONTROLForms.HTML:Option.13.WHEREHTMLCONTROLForms.HTML:Option.14.GROUPBY4：若要撤銷數(shù)據(jù)庫中已經(jīng)存在的表S，可用HTMLCONTROLForms.HTML:Option.11.DELETETABLESHTMLCONTROLForms.HTML:Option.12.DELETESHTMLCONTROLForms.HTML:Option.13.DROPTABLESHTMLCONTROLForms.HTML:Option.14.DROPS5：在數(shù)據(jù)庫中，下列說法不正確的是HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)庫避免了一切數(shù)據(jù)重復(fù)HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)庫減少了數(shù)據(jù)冗余HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)庫中的數(shù)據(jù)可以共享HTMLCONTROLForms.HTML:Option.14.若系統(tǒng)是完全可以控制的，則系統(tǒng)可確保更新的一致性6：對實(shí)體和實(shí)體之間的聯(lián)系采用同樣的數(shù)據(jù)結(jié)構(gòu)表達(dá)的數(shù)據(jù)模型為HTMLCONTROLForms.HTML:Option.11.網(wǎng)狀模型HTMLCONTROLForms.HTML:Option.12.關(guān)系模型HTMLCONTROLForms.HTML:Option.13.層次模型HTMLCONTROLForms.HTML:Option.14.非關(guān)系模型7：SQL語言中，下列涉及空值的操作，不正確的是HTMLCONTROLForms.HTML:Option.11.AGEISNULLHTMLCONTROLForms.HTML:Option.12.AGEISNOTNULLHTMLCONTROLForms.HTML:Option.13.AGE=NULLHTMLCONTROLForms.HTML:Option.14.NOT（AGEISNULL）8：數(shù)據(jù)庫三級模式體系結(jié)構(gòu)的劃分，有利于保持?jǐn)?shù)據(jù)庫的HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)獨(dú)立性HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)安全性HTMLCONTROLForms.HTML:Option.13.結(jié)構(gòu)規(guī)范化HTMLCONTROLForms.HTML:Option.14.操作可行性9：關(guān)系數(shù)據(jù)模型的基本數(shù)據(jù)結(jié)構(gòu)是HTMLCONTROLForms.HTML:Option.11.樹HTMLCONTROLForms.HTML:Option.12.圖HTMLCONTROLForms.HTML:Option.13.索引HTMLCONTROLForms.HTML:Option.14.關(guān)系10：在數(shù)據(jù)庫中存儲的是HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)模型HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)以及數(shù)據(jù)之間的聯(lián)系HTMLCONTROLForms.HTML:Option.14.信息1：設(shè)在某個公司環(huán)境中，一個部門有多名職工，一名職工只能屬于一個部門，則部門與職工之間的聯(lián)系是HTMLCONTROLForms.HTML:Option.11.一對一HTMLCONTROLForms.HTML:Option.12.一對多HTMLCONTROLForms.HTML:Option.13.多對多HTMLCONTROLForms.HTML:Option.14.不確定2：在訂單管理系統(tǒng)中，客戶一次購物（一張訂單）可以訂購多種商品。有訂單關(guān)系R：R（訂單號，日期，客戶名稱，商品編碼，數(shù)量），則R的主關(guān)鍵字是HTMLCONTROLForms.HTML:Option.11.訂單號HTMLCONTROLForms.HTML:Option.12.訂單號，客戶名稱HTMLCONTROLForms.HTML:Option.13.商品編碼HTMLCONTROLForms.HTML:Option.14.訂單號，商品編碼3：在關(guān)系數(shù)據(jù)庫設(shè)計(jì)中，對關(guān)系進(jìn)行規(guī)范化處理，使關(guān)系達(dá)到一定的范式，例如達(dá)到3NF，這是（）階段的任務(wù)HTMLCONTROLForms.HTML:Option.11.需求分析階段HTMLCONTROLForms.HTML:Option.12.概念設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.13.物理設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.14.邏輯設(shè)計(jì)階段4：關(guān)系代數(shù)運(yùn)算的基礎(chǔ)是HTMLCONTROLForms.HTML:Option.11.關(guān)系運(yùn)算HTMLCONTROLForms.HTML:Option.12.謂詞演算HTMLCONTROLForms.HTML:Option.13.集合運(yùn)算HTMLCONTROLForms.HTML:Option.14.代數(shù)運(yùn)算5：假設(shè)有關(guān)系R和S，關(guān)系代數(shù)表達(dá)式R－（R－S）表示的是HTMLCONTROLForms.HTML:Option.11.R∩SHTMLCONTROLForms.HTML:Option.12.R∪SHTMLCONTROLForms.HTML:Option.13.R－SHTMLCONTROLForms.HTML:Option.14.R×S6：提供數(shù)據(jù)庫定義、數(shù)據(jù)操縱、數(shù)據(jù)控制和數(shù)據(jù)庫維護(hù)功能的軟件稱為HTMLCONTROLForms.HTML:Option.11.OSHTMLCONTROLForms.HTML:Option.12.DSHTMLCONTROLForms.HTML:Option.13.DBMSHTMLCONTROLForms.HTML:Option.14.DBS7：設(shè)關(guān)系R和S具有相同的結(jié)構(gòu)，由屬于S但不屬于R的元組構(gòu)成的關(guān)系，記為HTMLCONTROLForms.HTML:Option.11.R?SHTMLCONTROLForms.HTML:Option.12.S?RHTMLCONTROLForms.HTML:Option.13.R∪SHTMLCONTROLForms.HTML:Option.14.S∩S8：規(guī)范化過程主要為克服數(shù)據(jù)庫邏輯結(jié)構(gòu)中的插入異常，刪除異常以及HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)的不一致性的缺欠HTMLCONTROLForms.HTML:Option.12.結(jié)構(gòu)不合理的缺欠HTMLCONTROLForms.HTML:Option.13.冗余度大的缺欠HTMLCONTROLForms.HTML:Option.14.數(shù)據(jù)丟失的缺欠9：下列陳述中，錯誤的是HTMLCONTROLForms.HTML:Option.11.2NF必然屬于1NFHTMLCONTROLForms.HTML:Option.12.3NF必然屬于2NFHTMLCONTROLForms.HTML:Option.13.3NF必然屬于BCNFHTMLCONTROLForms.HTML:Option.14.BCNF必然屬于3NF10：下列聚合函數(shù)中不忽略空值(null)的是HTMLCONTROLForms.HTML:Option.11.SUN（列名）HTMLCONTROLForms.HTML:Option.12.MAX（列名）HTMLCONTROLForms.HTML:Option.13.AVG（列名）HTMLCONTROLForms.HTML:Option.14.COUNT（*）1：X→Y，當(dāng)下列哪一條成立時，稱為平凡的函數(shù)依賴HTMLCONTROLForms.HTML:Option.11.X∈YHTMLCONTROLForms.HTML:Option.12.Y∈XHTMLCONTROLForms.HTML:Option.13.X∩Y＝ΦHTMLCONTROLForms.HTML:Option.14.X∩Y≠Φ2：實(shí)體完整性規(guī)則約束HTMLCONTROLForms.HTML:Option.11.侯選關(guān)鍵字HTMLCONTROLForms.HTML:Option.12.主關(guān)鍵字HTMLCONTROLForms.HTML:Option.13.外關(guān)鍵字HTMLCONTROLForms.HTML:Option.14.超關(guān)鍵字3：關(guān)系數(shù)據(jù)庫管理系統(tǒng)應(yīng)能實(shí)現(xiàn)的專門關(guān)系運(yùn)算包括HTMLCONTROLForms.HTML:Option.11.排序、索引、統(tǒng)計(jì)HTMLCONTROLForms.HTML:Option.12.選擇、投影、連接HTMLCONTROLForms.HTML:Option.13.關(guān)聯(lián)、更新、排序HTMLCONTROLForms.HTML:Option.14.顯示、打印、制表4：設(shè)關(guān)系R和S具有相同的結(jié)構(gòu)，由屬于S但不屬于R的元組構(gòu)成的關(guān)系，記為HTMLCONTROLForms.HTML:Option.11.R?SHTMLCONTROLForms.HTML:Option.12.S?RHTMLCONTROLForms.HTML:Option.13.R∪SHTMLCONTROLForms.HTML:Option.14.S∩S5：一般情況下，當(dāng)對關(guān)系R和S進(jìn)行自然連接時，要求R和S含有一個或者多個共有的HTMLCONTROLForms.HTML:Option.11.記錄HTMLCONTROLForms.HTML:Option.12.行HTMLCONTROLForms.HTML:Option.13.屬性HTMLCONTROLForms.HTML:Option.14.元組6：用戶或應(yīng)用程序看到的那部分局部邏輯結(jié)構(gòu)和特征的描述是HTMLCONTROLForms.HTML:Option.11.模式HTMLCONTROLForms.HTML:Option.12.物理模式HTMLCONTROLForms.HTML:Option.13.子模式HTMLCONTROLForms.HTML:Option.14.內(nèi)模式7：已知關(guān)系R和S，R∩S等價于HTMLCONTROLForms.HTML:Option.11.(R?S)?SHTMLCONTROLForms.HTML:Option.12.S?(S?R)HTMLCONTROLForms.HTML:Option.13.(S?R)?RHTMLCONTROLForms.HTML:Option.14.S?(R?S)8：關(guān)系中任何一列的屬性取值HTMLCONTROLForms.HTML:Option.11.可以再分成更小的數(shù)據(jù)項(xiàng)，并可取自不同域中的數(shù)據(jù)HTMLCONTROLForms.HTML:Option.12.可以再分成更小的數(shù)據(jù)項(xiàng)，不能取自不同域中的數(shù)據(jù)HTMLCONTROLForms.HTML:Option.13.不可再分的數(shù)據(jù)項(xiàng)，只能取自同一域中的數(shù)據(jù)HTMLCONTROLForms.HTML:Option.14.不可再分的數(shù)據(jù)項(xiàng)，可取自大在不同域中數(shù)據(jù)9：SQl語言是（）的語言，易學(xué)習(xí)HTMLCONTROLForms.HTML:Option.11.過程化HTMLCONTROLForms.HTML:Option.12.非過程化HTMLCONTROLForms.HTML:Option.13.格式化HTMLCONTROLForms.HTML:Option.14.導(dǎo)航化10：數(shù)據(jù)庫設(shè)計(jì)的概念設(shè)計(jì)階段，表示概念結(jié)構(gòu)的常用方法和描述工具是HTMLCONTROLForms.HTML:Option.11.層次分析法和層次結(jié)構(gòu)圖HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)流程分析法和數(shù)據(jù)流程圖HTMLCONTROLForms.HTML:Option.13.實(shí)體聯(lián)系方法HTMLCONTROLForms.HTML:Option.14.結(jié)構(gòu)分析法和模塊結(jié)構(gòu)圖1：用二維表結(jié)構(gòu)表示實(shí)體以及實(shí)體間聯(lián)系的數(shù)據(jù)模型稱為HTMLCONTROLForms.HTML:Option.11.網(wǎng)狀模型HTMLCONTROLForms.HTML:Option.12.層次模型HTMLCONTROLForms.HTML:Option.13.關(guān)系模型HTMLCONTROLForms.HTML:Option.14.面向?qū)ο竽Ｐ?：關(guān)系模型中，一個關(guān)鍵字是HTMLCONTROLForms.HTML:Option.11.可以由多個任意屬性組成HTMLCONTROLForms.HTML:Option.12.至多由一個屬性組成HTMLCONTROLForms.HTML:Option.13.由一個或多個屬性組成，其值能夠惟一標(biāo)識關(guān)系中一個元組HTMLCONTROLForms.HTML:Option.14.以上都不是3：設(shè)有關(guān)系R（S，D，M）F={S→D，D→M}。則關(guān)系R至多滿足HTMLCONTROLForms.HTML:Option.11.1NFHTMLCONTROLForms.HTML:Option.12.2NFHTMLCONTROLForms.HTML:Option.13.3NFHTMLCONTROLForms.HTML:Option.14.BCNF4：關(guān)系模式的主關(guān)鍵字有HTMLCONTROLForms.HTML:Option.11.0個HTMLCONTROLForms.HTML:Option.12.1個HTMLCONTROLForms.HTML:Option.13.1個或多個HTMLCONTROLForms.HTML:Option.14.多個5：關(guān)系模式中的關(guān)系模式至少是HTMLCONTROLForms.HTML:Option.11.1NFHTMLCONTROLForms.HTML:Option.12.2NFHTMLCONTROLForms.HTML:Option.13.3NFHTMLCONTROLForms.HTML:Option.14.BCNF6：下列所述數(shù)據(jù)模型概念，不正確的是HTMLCONTROLForms.HTML:Option.11.不同記錄型的集合HTMLCONTROLForms.HTML:Option.12.各種記錄型及其聯(lián)系的集合HTMLCONTROLForms.HTML:Option.13.E-R圖表示的實(shí)體聯(lián)系模型HTMLCONTROLForms.HTML:Option.14.數(shù)據(jù)庫的概念模型7：在關(guān)系數(shù)據(jù)庫設(shè)計(jì)中，設(shè)計(jì)關(guān)系模式是數(shù)據(jù)庫設(shè)計(jì)中（）階段的任務(wù)。HTMLCONTROLForms.HTML:Option.11.邏輯設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.12.概念設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.13.物理設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.14.需求分析階段8：關(guān)系規(guī)范化中的插入操作異常是指HTMLCONTROLForms.HTML:Option.11.不該刪除的數(shù)據(jù)被刪除HTMLCONTROLForms.HTML:Option.12.不該插入的數(shù)據(jù)被插入HTMLCONTROLForms.HTML:Option.13.應(yīng)該刪除的數(shù)據(jù)被刪除HTMLCONTROLForms.HTML:Option.14.應(yīng)該插入的數(shù)據(jù)未被插入9：在下面的兩個關(guān)系中，職工號和部門號分別為職工關(guān)系和部門關(guān)系的主關(guān)鍵字。職工（職工號、職工名、部門號、職務(wù)、工資）部門（部門號、部門名、部門人數(shù)、工資總額）在這兩個關(guān)系的屬性中，只有一個屬性是外關(guān)鍵字。它是HTMLCONTROLForms.HTML:Option.11.職工關(guān)系的“職工號”HTMLCONTROLForms.HTML:Option.12.職工關(guān)系的“部門號”HTMLCONTROLForms.HTML:Option.13.部門關(guān)系的“部門號”HTMLCONTROLForms.HTML:Option.14.部門關(guān)系的“部門名”10：SQL語言是HTMLCONTROLForms.HTML:Option.11.高級語言HTMLCONTROLForms.HTML:Option.12.宿主語言HTMLCONTROLForms.HTML:Option.13.匯編語言HTMLCONTROLForms.HTML:Option.14.非過程化語言1：已知關(guān)系R（P，Q，M，N），F(xiàn)是R上成立的函數(shù)依賴集，F(xiàn)={（P→Q，Q→M）}，則R的侯選關(guān)鍵字是HTMLCONTROLForms.HTML:Option.11.PHTMLCONTROLForms.HTML:Option.12.QHTMLCONTROLForms.HTML:Option.13.PQHTMLCONTROLForms.HTML:Option.14.PN2：設(shè)有一個關(guān)系：DEPT(DNO，DNAME)，如果要找出倒數(shù)第三個字母為W，并且至少包含4個字母的DNAME，則查詢條件子句應(yīng)寫成WHEREDNAMELIKEHTMLCONTROLForms.HTML:Option.11.'__W_%'HTMLCONTROLForms.HTML:Option.12.'_W_%'HTMLCONTROLForms.HTML:Option.13.'_W__'HTMLCONTROLForms.HTML:Option.14.'_%W__'3：在數(shù)據(jù)庫系統(tǒng)中，空值是HTMLCONTROLForms.HTML:Option.11.0HTMLCONTROLForms.HTML:Option.12.空格HTMLCONTROLForms.HTML:Option.13.空字符串HTMLCONTROLForms.HTML:Option.14.不確定4：在SQL語言查詢語句中，WHERE子句實(shí)現(xiàn)關(guān)系代數(shù)的HTMLCONTROLForms.HTML:Option.11.投影運(yùn)算HTMLCONTROLForms.HTML:Option.12.選擇運(yùn)算HTMLCONTROLForms.HTML:Option.13.連接運(yùn)算HTMLCONTROLForms.HTML:Option.14.交運(yùn)算5：當(dāng)關(guān)系R和S做自然聯(lián)接時，能夠保留R中不滿足連接條件元組的操作是HTMLCONTROLForms.HTML:Option.11.左外聯(lián)接HTMLCONTROLForms.HTML:Option.12.右外聯(lián)接HTMLCONTROLForms.HTML:Option.13.內(nèi)部連接HTMLCONTROLForms.HTML:Option.14.全外聯(lián)接6：X→Y，當(dāng)下列哪一條成立時，稱為平凡的函數(shù)依賴HTMLCONTROLForms.HTML:Option.11.X∈YHTMLCONTROLForms.HTML:Option.12.Y∈XHTMLCONTROLForms.HTML:Option.13.X∩Y＝ΦHTMLCONTROLForms.HTML:Option.14.X∩Y≠Φ7：在關(guān)系數(shù)據(jù)庫設(shè)計(jì)中，設(shè)計(jì)關(guān)系模式是數(shù)據(jù)庫設(shè)計(jì)中（）階段的任務(wù)。HTMLCONTROLForms.HTML:Option.11.邏輯設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.12.概念設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.13.物理設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.14.需求分析階段8：有殞為”列車運(yùn)營”實(shí)體，含有：車次、日期、實(shí)際發(fā)車時間、實(shí)際抵達(dá)時間、情況摘要等屬性，該實(shí)體主鍵是HTMLCONTROLForms.HTML:Option.11.車次HTMLCONTROLForms.HTML:Option.12.日期HTMLCONTROLForms.HTML:Option.13.車次+日期HTMLCONTROLForms.HTML:Option.14.車次+情況摘要9：關(guān)系規(guī)范化中的插入操作異常是指HTMLCONTROLForms.HTML:Option.11.不該刪除的數(shù)據(jù)被刪除HTMLCONTROLForms.HTML:Option.12.不該插入的數(shù)據(jù)被插入HTMLCONTROLForms.HTML:Option.13.應(yīng)該刪除的數(shù)據(jù)被刪除HTMLCONTROLForms.HTML:Option.14.應(yīng)該插入的數(shù)據(jù)未被插入10：設(shè)關(guān)系數(shù)據(jù)庫中一個表S的結(jié)構(gòu)為S（SN，CN，grade），其中SN為學(xué)生名，CN為課程名，二者均為字符型；grade為成績，數(shù)值型，取值范圍0－100。若要把“張二的化學(xué)成績80分”插入S中，則可用HTMLCONTROLForms.HTML:Option.11.ADDINTOSVALUES（’張二’，’化學(xué)’，’80’）HTMLCONTROLForms.HTML:Option.12.INSERTINTOSVALUES（’張二’，’化學(xué)’，’80’）HTMLCONTROLForms.HTML:Option.13.ADDINTOSVALUES（’張二’，’化學(xué)’，80）HTMLCONTROLForms.HTML:Option.14.INSERTINTOSVALUES（’張二’，’化學(xué)’，80）1：在通常情況下，下面關(guān)系中不可以作為關(guān)系數(shù)據(jù)庫的關(guān)系是HTMLCONTROLForms.HTML:Option.11.R1（學(xué)生號，學(xué)生名，性別）HTMLCONTROLForms.HTML:Option.12.R2（學(xué)生號，學(xué)生名，班級號）HTMLCONTROLForms.HTML:Option.13.R3（學(xué)生號，學(xué)生名，宿舍號）HTMLCONTROLForms.HTML:Option.14.R4（學(xué)生號，學(xué)生名，簡歷）4：反映現(xiàn)實(shí)世界中實(shí)體及實(shí)體間聯(lián)系的信息模型是HTMLCONTROLForms.HTML:Option.11.關(guān)系模型HTMLCONTROLForms.HTML:Option.12.層次模型HTMLCONTROLForms.HTML:Option.13.網(wǎng)狀模型HTMLCONTROLForms.HTML:Option.14.E-R模型6："元數(shù)據(jù)"是指HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)結(jié)構(gòu)的描述HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)項(xiàng)的描述HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)的來源HTMLCONTROLForms.HTML:Option.14.基本數(shù)據(jù)1：假設(shè)有關(guān)系R和S，關(guān)系代數(shù)表達(dá)式R－（R－S）表示的是HTMLCONTROLForms.HTML:Option.11.R∩SHTMLCONTROLForms.HTML:Option.12.R∪SHTMLCONTROLForms.HTML:Option.13.R－SHTMLCONTROLForms.HTML:Option.14.R×S2：在關(guān)系數(shù)據(jù)庫設(shè)計(jì)中，設(shè)計(jì)關(guān)系模式是數(shù)據(jù)庫設(shè)計(jì)中（）階段的任務(wù)。HTMLCONTROLForms.HTML:Option.11.邏輯設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.12.概念設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.13.物理設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.14.需求分析階段3：在數(shù)據(jù)庫設(shè)計(jì)中，將E-R圖轉(zhuǎn)換成關(guān)系數(shù)據(jù)模型的過程屬于HTMLCONTROLForms.HTML:Option.11.需求分析階段HTMLCONTROLForms.HTML:Option.12.邏輯設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.13.概念設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.14.物理設(shè)計(jì)階段4：DBMS是HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)庫HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)庫系統(tǒng)HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)庫應(yīng)用軟件HTMLCONTROLForms.HTML:Option.14.數(shù)據(jù)庫管理軟件5：層次數(shù)據(jù)模型的基本數(shù)據(jù)結(jié)構(gòu)是HTMLCONTROLForms.HTML:Option.11.樹HTMLCONTROLForms.HTML:Option.12.圖HTMLCONTROLForms.HTML:Option.13.索引HTMLCONTROLForms.HTML:Option.14.關(guān)系6：下列所述數(shù)據(jù)模型概念，不正確的是HTMLCONTROLForms.HTML:Option.11.不同記錄型的集合HTMLCONTROLForms.HTML:Option.12.各種記錄型及其聯(lián)系的集合HTMLCONTROLForms.HTML:Option.13.E-R圖表示的實(shí)體聯(lián)系模型HTMLCONTROLForms.HTML:Option.14.數(shù)據(jù)庫的概念模型7：關(guān)系模式的分解HTMLCONTROLForms.HTML:Option.11.惟一HTMLCONTROLForms.HTML:Option.12.不惟一8：概念模型是現(xiàn)實(shí)世界的第一層抽象，這一類最著名的模型是HTMLCONTROLForms.HTML:Option.11.層次模型HTMLCONTROLForms.HTML:Option.12.關(guān)系模型HTMLCONTROLForms.HTML:Option.13.網(wǎng)狀模型HTMLCONTROLForms.HTML:Option.14.實(shí)體-關(guān)系模型9：關(guān)系數(shù)據(jù)模型的基本數(shù)據(jù)結(jié)構(gòu)是HTMLCONTROLForms.HTML:Option.11.樹HTMLCONTROLForms.HTML:Option.12.圖HTMLCONTROLForms.HTML:Option.13.索引HTMLCONTROLForms.HTML:Option.14.關(guān)系10：存取路徑對用戶透明，從而具有更高的數(shù)據(jù)獨(dú)立性、更好的安全保密性，簡化程序員和數(shù)據(jù)庫開發(fā)建立工作的模型是HTMLCONTROLForms.HTML:Option.11.網(wǎng)狀模型HTMLCONTROLForms.HTML:Option.12.關(guān)系模型HTMLCONTROLForms.HTML:Option.13.層次模型HTMLCONTROLForms.HTML:Option.14.以上都有1：下述不是DBA數(shù)據(jù)庫管理員的職責(zé)的是HTMLCONTROLForms.HTML:Option.11.完整性約束說明HTMLCONTROLForms.HTML:Option.12.定義數(shù)據(jù)庫模式HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)庫安全HTMLCONTROLForms.HTML:Option.14.數(shù)據(jù)庫管理系統(tǒng)設(shè)計(jì)2：在通常情況下，下面的關(guān)系中，不可以作為關(guān)系數(shù)據(jù)庫的關(guān)系是HTMLCONTROLForms.HTML:Option.11.R1（學(xué)生號，學(xué)生名，性別）HTMLCONTROLForms.HTML:Option.12.R2（學(xué)生號，學(xué)生名，班級號）HTMLCONTROLForms.HTML:Option.13.R3（學(xué)生號，班級號，宿舍號）HTMLCONTROLForms.HTML:Option.14.R4（學(xué)生號，學(xué)生名，簡歷）3：關(guān)系模式的候選關(guān)鍵字可以有HTMLCONTROLForms.HTML:Option.11.0個HTMLCONTROLForms.HTML:Option.12.1個HTMLCONTROLForms.HTML:Option.13.1個或多個HTMLCONTROLForms.HTML:Option.14.多個4：反映現(xiàn)實(shí)世界中實(shí)體及實(shí)體間聯(lián)系的信息模型是HTMLCONTROLForms.HTML:Option.11.關(guān)系模型HTMLCONTROLForms.HTML:Option.12.層次模型HTMLCONTROLForms.HTML:Option.13.網(wǎng)狀模型HTMLCONTROLForms.HTML:Option.14.E-R模型5：從ER圖導(dǎo)出關(guān)系模型時，如果實(shí)體間的聯(lián)系是M：N的，下列說法中正確的是HTMLCONTROLForms.HTML:Option.11.將N方碼和聯(lián)系的屬性納入M方的屬性中HTMLCONTROLForms.HTML:Option.12.將M方碼和聯(lián)系的屬性納入N方的屬性中HTMLCONTROLForms.HTML:Option.13.增加一個關(guān)系表示聯(lián)系，其中納入M方和N方的碼HTMLCONTROLForms.HTML:Option.14.在M方屬性和N方屬性中均增加一個表示級別的屬性6：在數(shù)據(jù)管理技術(shù)的發(fā)展過程中，經(jīng)歷了人工管理階段、文件系統(tǒng)階段和數(shù)據(jù)庫系統(tǒng)階段。在這幾個階段中，數(shù)據(jù)獨(dú)立性最高的階段是HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)庫系統(tǒng)HTMLCONTROLForms.HTML:Option.12.文件系統(tǒng)HTMLCONTROLForms.HTML:Option.13.人工管理HTMLCONTROLForms.HTML:Option.14.數(shù)據(jù)項(xiàng)管理7：下列語句中修改表結(jié)構(gòu)的是HTMLCONTROLForms.HTML:Option.11.ALTERHTMLCONTROLForms.HTML:Option.12.CREATEHTMLCONTROLForms.HTML:Option.13.UPDATEHTMLCONTROLForms.HTML:Option.14.INSERT8：SQL語言中實(shí)現(xiàn)數(shù)據(jù)庫檢索的語句是HTMLCONTROLForms.HTML:Option.11.SELECTHTMLCONTROLForms.HTML:Option.12.INSERTHTMLCONTROLForms.HTML:Option.13.UPDATEHTMLCONTROLForms.HTML:Option.14.DELETE9：數(shù)據(jù)庫設(shè)計(jì)中，確定數(shù)據(jù)庫存儲結(jié)構(gòu)，即確定關(guān)系、索引、聚簇、日志、備份等數(shù)據(jù)的存儲安排和存儲結(jié)構(gòu)，這是數(shù)據(jù)庫設(shè)計(jì)的HTMLCONTROLForms.HTML:Option.11.需求分析階段HTMLCONTROLForms.HTML:Option.12.邏輯設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.13.概念設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.14.物理設(shè)計(jì)階段10：下面關(guān)于關(guān)系性質(zhì)的說法，錯誤的是HTMLCONTROLForms.HTML:Option.11.表中的一行稱為一個元組HTMLCONTROLForms.HTML:Option.12.行與列交叉點(diǎn)不允許有多個值HTMLCONTROLForms.HTML:Option.13.表中的一列稱為一個屬性HTMLCONTROLForms.HTML:Option.14.表中任意兩行可能相同1：關(guān)系代數(shù)運(yùn)算的基礎(chǔ)是HTMLCONTROLForms.HTML:Option.11.關(guān)系運(yùn)算HTMLCONTROLForms.HTML:Option.12.謂詞演算HTMLCONTROLForms.HTML:Option.13.集合運(yùn)算HTMLCONTROLForms.HTML:Option.14.代數(shù)運(yùn)算2：在數(shù)據(jù)庫管理系統(tǒng)中，下面不是數(shù)據(jù)庫存取功能模塊的是HTMLCONTROLForms.HTML:Option.11.事務(wù)管理程序模塊HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)更新程序模塊HTMLCONTROLForms.HTML:Option.13.交互式程序查詢模塊HTMLCONTROLForms.HTML:Option.14.查詢處理程序模塊3：從ER圖導(dǎo)出關(guān)系模型時，如果實(shí)體間的聯(lián)系是M：N的，下列說法中正確的是HTMLCONTROLForms.HTML:Option.11.將N方碼和聯(lián)系的屬性納入M方的屬性中HTMLCONTROLForms.HTML:Option.12.將M方碼和聯(lián)系的屬性納入N方的屬性中HTMLCONTROLForms.HTML:Option.13.增加一個關(guān)系表示聯(lián)系，其中納入M方和N方的碼HTMLCONTROLForms.HTML:Option.14.在M方屬性和N方屬性中均增加一個表示級別的屬性4：規(guī)范化理論是關(guān)系數(shù)據(jù)庫進(jìn)行邏輯設(shè)計(jì)的理論依據(jù)，根據(jù)這個理論，關(guān)系數(shù)據(jù)庫中的關(guān)系必須滿足：其每一屬性都是HTMLCONTROLForms.HTML:Option.11.互不相關(guān)的HTMLCONTROLForms.HTML:Option.12.不可分解的HTMLCONTROLForms.HTML:Option.13.長度可變的HTMLCONTROLForms.HTML:Option.14.互相關(guān)聯(lián)的5：模式是數(shù)據(jù)庫HTMLCONTROLForms.HTML:Option.11.全局物理結(jié)構(gòu)HTMLCONTROLForms.HTML:Option.12.局部物理結(jié)構(gòu)HTMLCONTROLForms.HTML:Option.13.全局邏輯結(jié)構(gòu)HTMLCONTROLForms.HTML:Option.14.局部邏輯結(jié)構(gòu)6：數(shù)據(jù)庫系統(tǒng)的核心是HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)庫HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)庫管理系統(tǒng)HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)模型HTMLCONTROLForms.HTML:Option.14.軟件工具7：有一名為”銷售”實(shí)體，含有：商品名、客戶名、數(shù)量等屬性，該實(shí)體主鍵HTMLCONTROLForms.HTML:Option.11.商品名HTMLCONTROLForms.HTML:Option.12.客戶名HTMLCONTROLForms.HTML:Option.13.商品名+客戶名HTMLCONTROLForms.HTML:Option.14.商品名+數(shù)量8：在數(shù)據(jù)庫的三級模式結(jié)構(gòu)中，內(nèi)模式有HTMLCONTROLForms.HTML:Option.11.1個HTMLCONTROLForms.HTML:Option.12.2個HTMLCONTROLForms.HTML:Option.13.3個HTMLCONTROLForms.HTML:Option.14.任意多個9：在ER模型中，如果有3個不同的實(shí)體型，3個M：N聯(lián)系，根據(jù)ER模型轉(zhuǎn)換為關(guān)系模型的規(guī)則，轉(zhuǎn)換為關(guān)系的數(shù)目是HTMLCONTROLForms.HTML:Option.11.4HTMLCONTROLForms.HTML:Option.12.5HTMLCONTROLForms.HTML:Option.13.6HTMLCONTROLForms.HTML:Option.14.710：若要撤銷數(shù)據(jù)庫中已經(jīng)存在的表S，可用HTMLCONTROLForms.HTML:Option.11.DELETETABLESHTMLCONTROLForms.HTML:Option.12.DELETESHTMLCONTROLForms.HTML:Option.13.DROPTABLESHTMLCONTROLForms.HTML:Option.14.DROPS1：SQL語言具有的功能是HTMLCONTROLForms.HTML:Option.11.關(guān)系規(guī)范化HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)定義、數(shù)據(jù)操縱、數(shù)據(jù)控制、數(shù)據(jù)查詢HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)庫系統(tǒng)設(shè)計(jì)HTMLCONTROLForms.HTML:Option.14.能繪制E-R圖2："元數(shù)據(jù)"是指HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)結(jié)構(gòu)的描述HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)項(xiàng)的描述HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)的來源HTMLCONTROLForms.HTML:Option.14.基本數(shù)據(jù)3：關(guān)系代數(shù)中的連接操作是由HTMLCONTROLForms.HTML:Option.11.選擇和投影操作組合而成HTMLCONTROLForms.HTML:Option.12.選擇和笛卡爾積操作組合而成HTMLCONTROLForms.HTML:Option.13.投影、選擇、笛卡爾積操作組合而成HTMLCONTROLForms.HTML:Option.14.投影和笛卡爾積操作組合而成4：現(xiàn)有如下關(guān)系：患者（患者編號，患者姓名，性別，出生日期，所在單位）醫(yī)療（患者編號，醫(yī)生編號，醫(yī)生姓名，診斷日期，診斷結(jié)果）其中，醫(yī)療關(guān)系中的外關(guān)鍵字是HTMLCONTROLForms.HTML:Option.11.患者編號HTMLCONTROLForms.HTML:Option.12.患者姓名HTMLCONTROLForms.HTML:Option.13.患者編號和患者姓名HTMLCONTROLForms.HTML:Option.14.醫(yī)生編號和患者編號5：下面列出的數(shù)據(jù)庫管理技術(shù)發(fā)展的三個階段中，沒有專門的軟件對數(shù)據(jù)進(jìn)行管理的是I．人工管理階段II．文件系統(tǒng)階段III．?dāng)?shù)據(jù)庫階段HTMLCONTROLForms.HTML:Option.11.I和IIHTMLCONTROLForms.HTML:Option.12.只有IIHTMLCONTROLForms.HTML:Option.13.II和IIIHTMLCONTROLForms.HTML:Option.14.只有I6：數(shù)據(jù)庫的概念模型獨(dú)立于HTMLCONTROLForms.HTML:Option.11.具體的機(jī)器和DBMSHTMLCONTROLForms.HTML:Option.12.E-R圖HTMLCONTROLForms.HTML:Option.13.信息世界HTMLCONTROLForms.HTML:Option.14.現(xiàn)實(shí)世界7：關(guān)系數(shù)據(jù)庫規(guī)范化是為解決關(guān)系數(shù)據(jù)庫中HTMLCONTROLForms.HTML:Option.11.插入、刪除和數(shù)據(jù)冗余問題而引入的HTMLCONTROLForms.HTML:Option.12.提高查詢速度問題而引入的HTMLCONTROLForms.HTML:Option.13.減少數(shù)據(jù)操作的復(fù)雜性問題而引入的HTMLCONTROLForms.HTML:Option.14.保證數(shù)據(jù)的安全性和完整性問題而引入的8：數(shù)據(jù)庫系統(tǒng)是采用了數(shù)據(jù)庫技術(shù)的計(jì)算機(jī)系統(tǒng)，數(shù)據(jù)庫系統(tǒng)由數(shù)據(jù)庫、數(shù)據(jù)庫管理系統(tǒng)、應(yīng)用系統(tǒng)和HTMLCONTROLForms.HTML:Option.11.系統(tǒng)分析員HTMLCONTROLForms.HTML:Option.12.程序員HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)庫管理員HTMLCONTROLForms.HTML:Option.14.操作員9：在關(guān)系數(shù)據(jù)庫設(shè)計(jì)中，設(shè)計(jì)關(guān)系模式是數(shù)據(jù)庫設(shè)計(jì)中（）階段的任務(wù)。HTMLCONTROLForms.HTML:Option.11.邏輯設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.12.概念設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.13.物理設(shè)計(jì)階段HTMLCONTROLForms.HTML:Option.14.需求分析階段10：數(shù)據(jù)庫三級模式體系結(jié)構(gòu)的劃分，有利于保持?jǐn)?shù)據(jù)庫的HTMLCONTROLForms.HTML:Option.11.數(shù)據(jù)獨(dú)立性HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)安全性HTMLCONTROLForms.HTML:Option.13.結(jié)構(gòu)規(guī)范化HTMLCONTROLForms.HTML:Option.14.操作可行性1：關(guān)系模式的候選關(guān)鍵字可以有1個或多個，而主關(guān)鍵字有HTMLCONTROLForms.HTML:Option.11.多個HTMLCONTROLForms.HTML:Option.12.0個HTMLCONTROLForms.HTML:Option.13.1個HTMLCONTROLForms.HTML:Option.14.1個或多個2：關(guān)系模式的任何屬性HTMLCONTROLForms.HTML:Option.11.不可再分HTMLCONTROLForms.HTML:Option.12.可再分HTMLCONTROLForms.HTML:Option.13.命名在該關(guān)系模式中可心不惟一HTMLCONTROLForms.HTML:Option.14.以上都不對3：SQL語言具有的功能是HTMLCONTROLForms.HTML:Option.11.關(guān)系規(guī)范化HTMLCONTROLForms.HTML:Option.12.數(shù)據(jù)定義、數(shù)據(jù)操縱、數(shù)據(jù)控制、數(shù)據(jù)查詢HTMLCONTROLForms.HTML:Option.13.數(shù)據(jù)庫系統(tǒng)設(shè)計(jì)HTMLCONTROLForms.HTML:Option.14.能繪制E-R圖4：設(shè)關(guān)系R和S具有相同的結(jié)構(gòu)，由屬于S但不屬于R的元組構(gòu)成的關(guān)系，記為HTMLCONTROLForms.HTML:Option.11.R?SHTMLCONTROLForms.HTML:Option.12.S?RHTMLCONTROLForms.HTML:Option.13.R∪SHTMLCONTROLForms.HTML:Option.14.S∩S5：在數(shù)據(jù)庫的三級模式結(jié)構(gòu)中，內(nèi)模式有HTMLCONTROLForms.HTML:Option.11.1個HTMLCONTROLForms.HTML:Option.12.2個HTMLCONTROLForms.HTML:Option.13.3個HTMLCONTROLForms.HTML:Option.14.任意多個6：為在查詢結(jié)果中去掉重復(fù)元組，要使用保留字HTMLCONTROLForms.HTML:Option.11.UNIQUEHTMLCONTROLForms.HTML:Option.12.COUNTHTMLCONTROLForms.HTML:Option.13.DISTINCTHTMLCONTROLForms.HTML:Option.14.UNION7：若要在基本表S中增加一列CN（課程名），可用HTMLCONTROLForms.HTML:Option.11.ADDTABLES（CNCHAR（８））HTMLCONTROLForms.HTML:Option.12.ADDTABLESALTER（CNCHAR（８））HTMLCONTROLForms.HTML:Option.13.ALTERTABLESADD（CNCHAR（８））HTMLCONTROLForms.HTML:Option.14.ALTERTABLES（ADDCNCHAR（８））8：關(guān)系數(shù)據(jù)庫管理系統(tǒng)應(yīng)能實(shí)現(xiàn)的專門關(guān)系運(yùn)算包括HTMLCONTROLForms.HTML:Option.11.排序、索引、統(tǒng)計(jì)HTMLCONTROLForms.HTML:Option.12.選擇、投影、連接HTMLCONTROLForms.HTML:Option.13.關(guān)聯(lián)、更新、排序HTMLCONTROLForms.HTML:Option.14.顯示、打印、制表9：有關(guān)系S（S＃，SNAME，SAGE），C（C＃，CNAME），SC（S＃，C＃，GRADE）。其中S＃是學(xué)生號，SNAME是學(xué)生姓名，SAGE是學(xué)生年齡，C＃是課程號，CNAME是課程名稱。要查詢選修“ACCESS”課的年齡不小于20的全體學(xué)生姓名的SQL語句是SELECTSNAMEFROMS，C，SCWHERE子句。這里的WHERE子句的內(nèi)容是HTMLCONTROLForms.HTML:Option.11.S.S#=SC.S#andC.C#=SC.C#andSAGE>=20andCNAME=‘ACCESS’HTMLCONTROLForms.HTML:Option.12.S.S#=SC.S#andC.C#=SC.C#andSAGEin>=20andCNAMEin‘ACCESS’HTMLCONTROLForms.HTML:Option.13.SAGEin>=20andCNAMEin‘ACCESS’HTMLCONTROLForms.HTML:Option.14.SAGE>=20andCNAME=’ACCESS’10：在關(guān)系模式中，如果屬性A和B存在1對1的聯(lián)系，則說HTMLCONTROLForms.HTML:Option.11.A→BHTMLCONTROLForms.HTML:Option.12.B→AHTMLCONTROLForms.HTML:Option.13.A?BHTMLCONTROLForms.HTML:Option.14.以上都不是1：數(shù)據(jù)庫DB、數(shù)據(jù)庫系統(tǒng)DBS、數(shù)據(jù)庫管理系統(tǒng)DBMS三者之間的關(guān)系是1.DBS包括DB、DBMS2.DB包括DBS、DBMS3.DBMS包括DB、DBS4.DB就是DBS，也就是DBMS7：關(guān)系模型要求關(guān)系必須是規(guī)范化的，即要求關(guān)系模式必須滿足一定的條件，這些規(guī)范條件中最基本的一條就是1.每一個分量是一個不可分的數(shù)據(jù)項(xiàng)，即不允許表中表結(jié)構(gòu)2.二維表中各列的寬度必須完全相等3.二維表中各行和各列的順序不能交換4.屬性名要么完全使用漢字，要么全部使用字母2：下列四項(xiàng)中，不屬于數(shù)據(jù)庫系統(tǒng)特點(diǎn)的是1.數(shù)據(jù)共享2.數(shù)據(jù)完整性3.數(shù)據(jù)冗余度高4.數(shù)據(jù)獨(dú)立性高6：有關(guān)系S（S＃，SNAME，SEX），C（C＃，CNAME），SC（S＃，C＃，GRADE）。其中S＃是學(xué)生號，SNAME是學(xué)生姓名，SEX是性別，C＃是課程號，CNAME是課程名稱。要查詢選修“數(shù)據(jù)庫”課的全體男生姓名的SQL語句是SELECTSNAMEFROMS，C，SCWHERE子句。這里的WHERE子句的內(nèi)容是1.S.S#=SC.S#andC.C#=SC.C#andSEX=’男’andCNAME=’數(shù)據(jù)庫’2.S.S#=SC.S#andC.C#=SC.C#andSEXin’男’andCNAMEin’數(shù)據(jù)庫’3.SEX’男’andCNAME’數(shù)據(jù)庫’4.S.SEX=’男’andCNAME=’數(shù)據(jù)庫’8：若用如下的SQL語句創(chuàng)建一個student表，則可插入至表中的是CREATETABLEstudent(NOC(4)NOTNULL,NAMEC(8)NOTNULL,SEXC(2),AGEN(2));1.（‘1031’，‘曾華’，男，23）2.（‘1031’，‘曾華’，NULL，NULL）3.（NULL，‘曾華’，’男’，’23’）4.（‘1031’，NULL，’男’，23）1：關(guān)系模型中，一個關(guān)鍵字是1.可由多個任意屬性組成2.至多由一個屬性組成3.可由一個或多個其值能唯一標(biāo)識該關(guān)系模式中任何元組的屬性組成4.以上都不是2：DBMS是1.數(shù)據(jù)庫2.數(shù)據(jù)庫系統(tǒng)3.數(shù)據(jù)庫應(yīng)用軟件4.數(shù)據(jù)庫管理軟件3：在數(shù)據(jù)庫中產(chǎn)生數(shù)據(jù)不一致的根本原因是1.數(shù)據(jù)存儲量太大2.未對數(shù)據(jù)進(jìn)行完整性控制3.沒有嚴(yán)格保護(hù)數(shù)據(jù)4.數(shù)據(jù)冗余4：下列所述數(shù)據(jù)模型概念，不正確的是1.不同記錄型的集合2.各種記錄型及其聯(lián)系的集合3.E-R圖表示的實(shí)體聯(lián)系模型4.數(shù)據(jù)庫的概念模型5：關(guān)系模式的任何屬性1.不可再分2.可再分3.命名在該關(guān)系模式中可心不惟一4.以上都不對6：SQl語言是1.層次數(shù)據(jù)庫語言2.網(wǎng)絡(luò)數(shù)據(jù)庫語言3.關(guān)系數(shù)據(jù)庫語言4.非數(shù)據(jù)庫語言7：要保證數(shù)據(jù)庫的數(shù)據(jù)獨(dú)立性，需要修改的是1.模式與外模式2.模式與內(nèi)模式3.三級模式之間的兩層映射4.三層模式8：數(shù)據(jù)流程圖是用于數(shù)據(jù)庫設(shè)計(jì)中（）階段的工具。1.概要設(shè)計(jì)2.可行性分析3.程序編碼4.需求分析9：若用如下的SQL語句創(chuàng)建了一個表SC：CREATETABLESC（S#CHAR（6）NOTNULL，C#CHAR（3）NOTNULL，SCOREINTEGER，NOTECHAR（20））；向SC表插入如下行時，（）行可以被插入。1.（’201009’，’111’，60，必修）2.（’200823’，’101’，NULL，NULL）3.（NULL，’103’，80，’選修’）4.（’201132’，NULL，86，’’）10：關(guān)系數(shù)據(jù)庫中的投影操作是指從關(guān)系中1.抽出特定記錄2.抽出特定字段3.建立相應(yīng)的影像4.建立相應(yīng)的圖形1：下面關(guān)于函數(shù)依賴的敘述中，不正確的是1.若X→Y，X→Z，則X→YZ2.若XY→Z，則X→Z，Y→Z3.若X→Y，WY→Z，則XW→Z4.若X→Y，則XZ→YZ2：關(guān)系模式中的關(guān)系模式至少是1.1NF2.2NF3.3NF4.BCNF3：存儲在計(jì)算機(jī)內(nèi)有結(jié)構(gòu)的數(shù)據(jù)的集合是1.數(shù)據(jù)庫系統(tǒng)2.數(shù)據(jù)庫3.數(shù)據(jù)庫管理系統(tǒng)4.數(shù)據(jù)結(jié)構(gòu)4：在數(shù)據(jù)庫設(shè)計(jì)中，將E-R圖轉(zhuǎn)換成關(guān)系數(shù)據(jù)模型的過程屬于1.需求分析階段2.邏輯設(shè)計(jì)階段3.概念設(shè)計(jì)階段4.物理設(shè)計(jì)階段5：數(shù)據(jù)庫設(shè)計(jì)中，概念模型1.依賴于計(jì)算機(jī)的硬件2.獨(dú)立于DBMS3.依賴于DBMS4.獨(dú)立于計(jì)算機(jī)的硬件和DBMS6：在關(guān)系數(shù)據(jù)庫設(shè)計(jì)中，對關(guān)系進(jìn)行規(guī)范化處理，使關(guān)系達(dá)到一定的范式，例如達(dá)到3NF，這是（）階段的任務(wù)1.需求分析階段2.概念設(shè)計(jì)階段3.物理設(shè)計(jì)階段4.邏輯設(shè)計(jì)階段7：若用如下的SQL語句創(chuàng)建一個student表，則可插入至表中的是CREATETABLEstudent(NOC(4)NOTNULL,NAMEC(8)NOTNULL,SEXC(2),AGEN(2));1.（‘1031’，‘曾華’，男，23）2.（‘1031’，‘曾華’，NULL，NULL）3.（NULL，‘曾華’，’男’，’23’）4.（‘1031’，NULL，’男’，23）8：若要撤銷數(shù)據(jù)庫中已經(jīng)存在的表S，可用1.DELETETABLES2.DELETES3.DROPTABLES4.DROPS9：SQL語言具有的功能是1.關(guān)系規(guī)范化2.數(shù)據(jù)定義、數(shù)據(jù)操縱、數(shù)據(jù)控制、數(shù)據(jù)查詢3.數(shù)據(jù)庫系統(tǒng)設(shè)計(jì)4.能繪制E-R圖10：在SQL語言的SELECT語句中，能實(shí)現(xiàn)投影操作的是1.SELECT2.FROM3.WHERE4.GROUPBY1：在SQL語言查詢語句中，WHERE子句實(shí)現(xiàn)關(guān)系代數(shù)的1.投影運(yùn)算2.選擇運(yùn)算3.連接運(yùn)算4.交運(yùn)算2：關(guān)系規(guī)范化中的插入操作異常是指1.不該刪除的數(shù)據(jù)被刪除2.不該插入的數(shù)據(jù)被插入3.應(yīng)該刪除的數(shù)據(jù)被刪除4.應(yīng)該插入的數(shù)據(jù)未被插入3：數(shù)據(jù)庫DB、數(shù)據(jù)庫系統(tǒng)DBS、數(shù)據(jù)庫管理系統(tǒng)DBMS三者之間的關(guān)系是1.DBS包括DB、DBMS2.DB包括DBS、DBMS3.DBMS包括DB、DBS4.DB就是DBS，也就是D