1、1北京邮电大学 20072008 学年第一学期数据库技术与应用 期末考试试题考试注意事项一、学生参加考试须带学生证或学院证明，未带者不准进入考场。学生必须按照监考教师指定座位就坐。二、书本、参考资料、书包等与考试无关的东西一律放到考场指定位置。三、学生不得另行携带、使用稿纸，要遵守北京邮电大学考场规则 ，有考场违纪或作弊行为者，按相应规定严肃处理。四、学生必须将答题内容做在专用答题纸上，做在试卷、草稿纸上一律无效。考试课程数据库技术与应用 考试时间 年 月 日题号 一 二 三 四 五 六 七 八 总分满分 20 30 10 30 10得分阅卷教师True-False Questions（20）
2、题号1 2 3 4 5 6 7 8 9 10答案题号11 12 13 14 15 16 17 18 19 20答案班级： 学号： 姓名：2Multiple Choice Questions（30）题号 1 2 3 4 5 6 7 8 9 10答案题号 11 12 13 14 15 16 17 18 19 20答案题号 21 22 23 24 25 26 27 28 29 30答案Fill in the Blank Questions（10）题号答案12345678910Essay Questions（30）1323445Give your suggestion about this cours
3、e（10）5True-False Questions（1point*20 ）1. The purpose of a database is to help people keep track of things.2. The relational model was first proposed in 1970 by E. F. Codd at IBM.3. A relation is a three-dimensional table.4. An asterisk (*) following the SELECT verb means that all columns are to be o
4、btained.5. The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.6. In an E-R model, the three types of maximum cardinality are 1:1, 1:N and N:M.7. A null value is an attribute value that has been set to zero.8. A data constraint is a limitatio
5、n on data values.9. In a relational database design, all relationships are expressed by creating a foreign key.10. A transaction is a group of alternative database actions from which the database can choose to perform only one of them.11. Two-phased locking has a growing phase and a shrinking phase.
6、12. “Repeatable Reads“ isolation is the most restrictive level of isolation.13. A “database save“ is used to mark the end of a transaction.14. To add a NULL column to a table, we simply use the MODIFY TABLE statement.15. Deleting tables and relationships is basically a matter of dropping foreign key
7、 constraints and then dropping the tables.16. The SQL keyword DELETE is used to delete a tables structure.17. Joins that show only matching rows from the joined tables in their results are called inner joins.18. An SQL virtual table is called a view.19. SQL triggers are used for providing default va
8、lues, validity checking, updating views, and performing referential integrity actions.20. Stored procedures have the advantage of greater security, decreased network traffic, SQL optimized by the DBMS compiler, and code sharing.6Multiple Choice Questions（1 point*30）1. A database stores:a.) data.b.)
9、relationships.c.) metadata.d.) a and be.) a, b and c2. A program whose job is to create, process and administer databases is called the _.a.) Database Modeling Systemb.) Database Management Systemc.) Data Business Model Systemd.) Relational Model Managere.) Data Business Management Service3. A datab
10、ase is considered “self-describing“ because _ .a.) all the users data is in one placeb.) it reduces data duplicationc.) it contains a description of its own structured.) it contains a listing of all the programs that use ite.) All of the above.4. A very popular development technique used by database
11、 professionals for database design is known as _ .a.) data martsb.) normalizationc.) data modelsd.) entity-relationship data modelinge.) data migration5. In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be selected?a.) EXISTSb.) FROMc.) SELECTd.) SET
12、e.) WHERE6. In an SQL query, which of the following symbols is used by ANSI SQL to represent a single unspecified character?a.) (underscore)b.) ? (question mark)c.) * (asterisk)d.) % (percent)e.) # (pound)7. Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the fol
13、lowing would find all employees whose name begins with the letter “S“ using standard SQL?7a.) SELECT *FROM EMPLOYEEWHERE Name IN S;b.) SELECT EmpNoFROM EMPLOYEEWHERE Name LIKE S;c.) SELECT *FROM NameWHERE EMPLOYEE LIKE S*;d.) SELECT *FROM EMPLOYEEWHERE Name LIKE S%;e.) None of the above.8. Given a t
14、able with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following is not a valid ANSI SQL command?a.) SELECT *FROM EMPLOYEEWHERE Name LIKE Ja%;b.) SELECT COUNT(*)FROM EMPLOYEEWHERE Salary 30000;c.) SELECT COUNT(EmpNo)FROM EMPLOYEE;d.) SELECT HireDate, COUNT(*)FROM EMPLOYEEWHE
15、RE Salary 30000;e.) SELECT HireDate, COUNT(*)FROM EMPLOYEEGROUP BY HireDate;9. A relation _ .a.) has rows containing data about an entityb.) has columns containing data about attributes of the entityc.) has cells that hold only a single valued.) has no two identical rowse.) All of the above.10. Whic
16、h of the following is true about the functional dependency A (X, Y)?a.) X is functionally dependent on A.b.) A determines Y.c.) A is a determinant.d.) X and Y are functionally dependent on A.e.) All of the above.11. A relation is in fourth normal form if it is in BCNF and it has no _ .a.) transitive
17、 dependenciesb.) multivalued dependenciesc.) partial dependenciesd.) deletion dependencies8e.) referential integrity conflicts12. The advantages of normalization include _ .a.) the elimination of modification anomaliesb.) the elimination of duplicated datac.) more complex SQL for multitable subqueri
18、es and joinsd.) a and be.) a, b and c13. To check for null values in a column in a table, use the SQL phrase _ .a.) ISb.) IS NOTc.) IS NULLd.) COUNT(IS NOT)e.) COUNT(IS NULL)14. A composite attribute is an attribute that _ .a.) is multivaluedb.) describes a characteristic of the relationshipc.) cons
19、ists of a group of attributes d.) is calculated at run-timee.) is an identifier15. Maximum cardinality refers to _ .a.) the most instances of one entity class that can be involved in a relationship instance with another entity classb.) the minimum number of entity classes involved in a relationshipc
20、.) whether or not an instance of one entity class is required to be related to an instance of another entity classd.) whether or not an entity is a weak entitye.) None of the above.16. An entity whose existence depends on the presence of another entity, but whose identifier does not include the iden
21、tifier of the other entity is a(n) _ .a.) strong entityb.) weak entityc.) ID-dependent entityd.) a and ce.) b and c 17. You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown below, and are asked to draw the relationship between them. If a given customer can place only one orde
22、r and a given order can be placed by at most one customer, which of the following should be indicated in the relationship symbol between the two entities?a.) 0:1b.) 1:1ORDER CUSTOMER9c.) 1:Nd.) N:1 e.) N:M18. When an entity has a relationship to itself, we have a (n) _ .a.) supertype/subtype relatio
23、nshipb.) archetype/instance relationshipc.) recursive relationshipd.) a or ce.) b or c 19. Each attribute of an entity becomes a _ of a table.a.) columnb.) primary keyc.) foreign keyd.) alternate keye.) b or d20. Which of the following is not true about surrogate keys?a.) They are identifiers that a
24、re supplied by the system, not the users.b.) They have no meaning to the users.c.) They are nonunique within a table.d.) They can be problematic when combining databases.e.) The DBMS will not allow their values to be changed.21. To which of the following actions are referential integrity constraints
25、 not applied?a.) createb.) insertc.) modifyd.) deletee.) referential integrity constraints are applied to all of the listed actions22. Which SQL keyword is used to impose restrictions on a table, data or relationship?a.) SETb.) CREATEc.) SELECTd.) ALTERe.) CONSTRAINT23. SQL views are constructed fro
26、m .a.) CREATE statementsb.) INSERT statementsc.) UPDATE statementsd.) SELECT statementse.) VIEW statements24. In the SQL statementsSELECT C1.CustName, C1.SalesRepNoFROM CUSTOMER C1;10the “C1“ is called a(n) _ .a.) termb.) aliasc.) conventiond.) phrasee.) label25. If a DEFAULT constraint is included
27、when a new column is added to a table, the default value is applied to .a.) all existing rows at the time the column is addedb.) all new rowsc.) all new rows but only after the UPDATE command is issuedd.) a and be.) a and c26. When dropping tables and relationships, which of the following steps are
28、included in the process the order of the steps listed below is not relevant, only the steps themselves?a.) Drop the foreign key constraints from the tablesb.) Drop the tablesc.) Drop the primary key constraints from the tablesd.) a and be.) a, b and c27. Which of the following is not a database admi
29、nistration responsibility of a DBA?a.) Managing the database structureb.) Managing data activityc.) Managing the DBMSd.) Maintaining the data repositorye.) All of the above are database administration responsibilities of a DBA.28. Measures that are taken to prevent one users work from inappropriatel
30、y influencing another users work are called:a.) concurrency control.b.) checkpoint.c.) database recovery.d.) database logging.e.) interleaving.29. The situation that occurs when two users are each waiting for a resource that the other person has locked is known as a(n):a.) lost update problem.b.) de
31、adlock.c.) inconsistent read problem.d.) inconsistent write problem.e.) checkpoint.30. Locks that are placed assuming that a conflict will not occur are called:a.) dynamic.b.) explicit.11c.) implicit.d.) optimistic.e.) pessimistic.Fill in the Blank Questions（1 point*10）1. SQL stands for .2. To remov
32、e duplicate rows from the result of a query, specify the SQL qualifier .3. If a table is a relation then it is in NF.4. To limit the number of rows retrieved from a table, use the SQL keyword .5. By default, the identifier of the entity becomes the of the corresponding table.6. Rows in a table can b
33、e changed by using the statement.7. To add a NULL column to a table, we use the TABLE statement.8. A(n) is a series of actions to be taken on the database such that either all of them are performed successfully or none of them is performed at all.9. A(n) lock locks the item from access of any type.1
34、0. A(n) cursor processes a snapshot of the relation that was taken when the cursor was opened.Essay Questions（6 points*5）1. Briefly describe subqueries and joins. Explain when each is not an acceptable alternative for the other.2. Briefly describe the process of converting an extended E-R model into
35、 a relational database design.3. The following database will be used in this question:GENERAL SALES DATABASE:SALESREPSalesRepNo RepName HireDate654 Jones 01/02/1999734 Smith 02/03/2000345 Chen 01/25/1998434 Johnson 11/23/1998CUSTOMERCustNo CustName Balance SalesRepNo9870 Winston 500 3458590 Gonzales
36、 350 43412Explain the use of the SQL statement CREATE TABLE. Do NOT discuss the ALTER statement in your answer, but DO include an example based on the SALESREP table in the General Sales database.4. Explain the concept of serializable transactions.5. Explain the SQL Server IDENTITY constraint.Give your suggestion about this course（10 points*1）7840 Harris 800 6544870 Miles 100 345
