全國2012年1月高等教育自學(xué)考試

數(shù)據(jù)庫及其應(yīng)用試題

課程代碼：02120

一、單項(xiàng)選擇題(本大題共20小題，每小題2分，共40分)��

在每小題列出的四個(gè)備選項(xiàng)中只有一個(gè)是符合題目要求的，請(qǐng)將其代碼填寫在題后的括號(hào)內(nèi)。錯(cuò)選、多選或未選均無分。

1．下列敘述中，沒有反映數(shù)據(jù)庫系統(tǒng)優(yōu)點(diǎn)的是(      )��

A．?dāng)?shù)據(jù)結(jié)構(gòu)化                                                B．?dāng)?shù)據(jù)獨(dú)立性高��

C．?dāng)?shù)據(jù)面向應(yīng)用程序                                     D．?dāng)?shù)據(jù)冗余度低��

2．在關(guān)系規(guī)范化過程中，要消除非主屬性對(duì)主鍵的(      )��

A．函數(shù)依賴                                                   B．部分函數(shù)依賴��

C．完全函數(shù)依賴                                            D．非平凡函數(shù)依賴��

3．將E—R模型轉(zhuǎn)換成關(guān)系模型的過程，稱為數(shù)據(jù)庫的(      )��

A．概念設(shè)計(jì)                                                   B．邏輯設(shè)計(jì)��

C．物理設(shè)計(jì)                                                   D．關(guān)系設(shè)計(jì)��

4．在關(guān)系代數(shù)中，可以用選擇和笛卡兒積表示的運(yùn)算是(      )��

A．連接                                                          B．投影��

C．除法                                                          D．交��

5．在Access中，用于存儲(chǔ)數(shù)據(jù)的數(shù)據(jù)庫對(duì)象是 (      )��

A．表                                                              B．窗體��

C．查詢                                                          D．?dāng)?shù)據(jù)訪問頁��

6．要為數(shù)據(jù)庫設(shè)置密碼，則打開數(shù)據(jù)庫時(shí)應(yīng)采用(      )��

A．獨(dú)占方式                                                   B．共享方式��

C．只讀方式                                                   D．獨(dú)占只讀方式��

7．在Access中，用來保護(hù)敏感數(shù)據(jù)的手段是(      )��

A．備份和還原                                                B．壓縮和修復(fù)��

C．使用用戶級(jí)安全機(jī)制                                  D．以獨(dú)占方式打開數(shù)據(jù)庫��

8．有成績表：SC(學(xué)號(hào),課程號(hào)，成績)，下列選項(xiàng)中符合實(shí)體完整性要求的是(      )��

A．學(xué)號(hào)可以為空，課程號(hào)不能為空                B．課程號(hào)可以為空，學(xué)號(hào)不能為空��

C．學(xué)號(hào)和課程號(hào)都可以為空                           D．學(xué)號(hào)和課程號(hào)都不能為空��

9．下列選項(xiàng)中，能設(shè)置掩碼的字段類型是(      )��

A．備注                                                          B．OLE對(duì)象��

C．是／否                                                       D．文本��

10．公司的業(yè)務(wù)規(guī)定，一個(gè)客戶可以有多個(gè)訂單，且一個(gè)訂單只能屬于一個(gè)客戶，則客戶與訂單表之間的關(guān)系是(      )��

A．一對(duì)一                                                       B．一對(duì)多��

C．多對(duì)多                                                       D．不確定��