《數(shù)據(jù)庫原理(雙語)》試卷

1、【精品文檔】如有侵權(quán)，請聯(lián)系網(wǎng)站刪除，僅供學(xué)習(xí)與交流數(shù)據(jù)庫原理(雙語)試卷.精品文檔.數(shù)據(jù)庫原理（雙語）考試試卷（第一套）課程號5807605040考試時間100分鐘適用專業(yè)年級（方向）：計算機(jī)科學(xué)與技術(shù)2007級考試方式及要求：閉卷筆試題號一二三四五總分得分閱卷人一、單項選擇題（每題2分，共40分，將答案填在下表內(nèi)）題號12345678910答案題號11121314151617181920答案1. Physical data independence(物理數(shù)據(jù)獨立性)（ ）AAllows us to access(訪問) the physical data independently(獨立地

2、) from all applications(應(yīng)用程序)BAllows us to rewrite(重寫) the queries(查詢) on the database without affecting(影響) the physical dataCAllows us to physically reorganize(重新組織) the data in the database without affecting the applications running on the databaseDAll of the above2. Which of the following is NOT

3、 an advantage（優(yōu)點） of database systems? （ ）ARedundant data（冗余的數(shù)據(jù)） BProgram-data independence(應(yīng)用程序與數(shù)據(jù)相互獨立) CBetter data quality （更好的數(shù)據(jù)質(zhì)量）DReduced program maintenance（減少應(yīng)用程序維護(hù)）3. Which of the following is an example of a database integrity constraint(完整性約束條件)? （ ）AThe grade assigned(分配) to a student fo

4、r a course must be either an A, B, C, D or FBEvery course must have a unique(唯一的) value for its course number CThe name of any student must be less than 30 characters(字母) in lengthDAll of the above4. Customers(顧客), cars, and parts(零件) are examples of （ ）Aentities(實體) Battributes(屬性) Crelations Drela

5、tionships(聯(lián)系) 5. A(n) _ is the relationship between a weak entity type and its owner. （ ） Aweak relationship B identifying(識別) relationship Cnon-identifying(非識別) relationship Downer relationship6. The relational data model（關(guān)系數(shù)據(jù)模型） consists of(由組成) which components(組件)? （ ）AData structure（數(shù)據(jù)結(jié)構(gòu)） BData

6、 manipulation（數(shù)據(jù)操作）CData integrity （完整性約束）DAll of the above 7. A primary key that consists of more than one attribute is called a（ ） Aforeign key（外鍵）Bcomposite key（復(fù)合鍵）Cmultivalued key（多值鍵）Dcandidate key（候選鍵）8. A rule that states that each foreign key value must match a primary key value in the othe

7、r relation is called the（ ）Areferential integrity constraint（參照完整性約束）Bentity integrity constraint（實體完整性約束）Cdomain integrity constraint（域完整性約束）Dnull constraint（空值約束）9. Which of the following are anomalies（異常） that can be caused by redundancies(冗余) in tables? （ ）Ainsertion（插入） Bdeletion（刪除） Cmodificat

8、ion（修改） Dall of the above 10. A candidate key（候選鍵） must satisfy（滿足） all of the following conditions EXCEPT（除了）（ ）Athe key must uniquely（唯一地） identify（識別） the row Bthe key must indicate the rows position in the table（表明行在表中的位置）Cthe key must be nonredundant（非冗余的）Deach nonprime attribute（非主屬性） is funct

9、ionally dependent upon（函數(shù)依賴于） it. 11. The intersection(交集) of two relations R(A,B,C) and S(A,B,C) can be computed by（ ）A R÷SBR(RS)C RSD all of the above12. This operation is commutative(可交換的) （ ）A Union(并)B Intersection(交)C Cartesian product(笛卡爾積)D all of the above13. What does the following SQ

10、L statement do? （ ）Alter Table Customer_T Add (Type Varchar (2);AAlters the Customer_T table to accept Type 2 VarcharsBAlters the Customer_T table to be a Type 2 VarcharCAlters the Customer_T table, and adds a field called "Type"DAlters the Customer_T table by adding a 2-byte field called

11、"Varchar"14. What does the following SQL statement do? （ ）Update Product_T Set Unit_Price = 775 Where Product_ID = 7AChanges the price of a unit called Product_T to 7BChanges the unit price of Product 7 to 775CChanges the length of the Unit_Price field to 775DUpdates the Product_T table to

12、 have a unit price of 77515. Assume(假設(shè)) we have executed(執(zhí)行) the following CREATE TABLE statement： CREATE TABLE Emp ( Ssn CHAR(9) Primary Key; SuperSsn CHAR(9) REFERENCES EMP(Ssn) ;Which of the following could be used to insert(插入) the first row into the Emp table? （ ）AINSERT INTO Emp(Ssn) VALUES (1

13、23456789)BINSERT INTO Emp(Ssn, SuperSsn) VALUES (123456789, 987654321)CINSERT INTO Emp(SuperSsn) VALUES (987654321)Dall of the above 16. _ is a set of commands（命令） used to update and query a database. （ ）ADML BDDL CDCL DDPL 17. In an SQL statement, which of the following finds all groups meeting sta

14、ted conditions（符合條件的組）? （ ）ASelectBWhereCHaving DFind 18.To eliminate duplicate rows（消除重復(fù)行） in a query, the _ qualifier（限定符） is used in the SQL Select command. （ ）AalterBdistinctCcheckDspecific 19. _ takes a value of true if a subquery（子查詢） returns an intermediate results(中間結(jié)果) table which contains（

15、包含） one or more rows. （ ）AInBHavingCExistsDExtents20.A _is a temporary table（臨時表） used in the FROM clause（子句） of an SQL query. （ ）Acorrelated subquery（相關(guān)子查詢）Bderived table（導(dǎo)出表）Cview table（視圖表）DNone of the above二、判斷題（每題1分，共10分，正確的填T，錯誤的填F，將答案填在下表內(nèi)）題號12345678910答案1. We can define(定義) a relation schema

16、(關(guān)系模式) R(A1, A2, A3) where A1 is the primary key(主鍵) and A3 is a foreign key(外鍵) that refers to(參考) R.（ ）2. A constraint（約束） is a rule in a database system that can be violated（違反） by users. （ ）3. The E-R model is used to construct（構(gòu)建） a conceptual model（概念模型）. （ ）4. The entity integrity rule（實體完整性規(guī)

17、則）states that a primary key attribute can be null. （ ）5. The attribute value in a tuple（元組） that makes up（組成） a foreign key(外鍵) can be null. （ ）6. A composite key（復(fù)合鍵） consists of only one attribute. （ ）7. One property（特征） of a relation is that each attribute within a relation has a unique（唯一的） name

18、. （ ）8. The columns of a relation can be interchanged（交換） without changing the meaning or use of the relation. （ ）9. The DELETE SQL command is used to remove（去掉） a table from the database. （ ）10. Subqueries（子查詢） can only be used in the WHERE clause. （ ）三、操作題（每題3分，共15分）現(xiàn)有關(guān)系數(shù)據(jù)庫模式如下：學(xué)生(學(xué)號，姓名，性別，專業(yè)，年齡)課程(課程號，名稱，學(xué)分)學(xué)習(xí)(學(xué)號，課程號，分?jǐn)?shù))用關(guān)系代數(shù)表達(dá)式實現(xiàn)12小題，用T-SQL語言實現(xiàn)35小題。1. 查詢“學(xué)生”關(guān)系學(xué)生中都有哪些專業(yè)。 2. 檢索“數(shù)據(jù)庫原理”課程成績高于90分的所有學(xué)生的學(xué)號、姓名、專業(yè)和分?jǐn)?shù)。  3. 檢索沒有選修課程號為“C135”課程的學(xué)生信息，包括學(xué)號，姓名和專業(yè)。  4. 從“學(xué)生”關(guān)系中刪除成績出現(xiàn)過0分的所有學(xué)生信息。 5. 定義“英語”專業(yè)學(xué)生所學(xué)課程的信息視圖English_View，包括學(xué)號、姓名、課程號和