Second Midterm Exam Review B.

Second Midterm Exam Review B. - Second Midterm Exam Review...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
************************************** I. Study Guide - 研讀指南 : 2009/5/25 ************************************** A. General Principles - 一般原則 1. Study the summary in each chapter. - 研讀 章的總結 2. Study lecture notes - 研讀課程講義 3. Study the textbook - 研讀課本 4. Study the homework - 研讀作業 5. Study this study guide - 研讀本指南 6. Study the exercises in the textbook - 研讀課本習題 B. Review of the Second Midterm Exam - 期中考複習 1. Understand Logical Database Design and the Relational Model (Chapter 5 - 5 ) 2. Understand Physical Database Design and Performance (Chapter 6 - 6 ) 3. Understand Introduction to SQL (Chapter 7 - 7 ) ************************************** II. Test Bank - 題庫 : ************************************** A. Multiple Choice: (Identify the choice that best completes the statement or answers the question.) Chapter 5: Understand Logical Database Design and the Relational Model (D) 1. Which of the following are properties of relations? (A) No two rows in a relation are identical. (B) Each attribute has a unique name. (C) There are no multivalued attributes in a relation. (D) All of the above. (B) 2. An attribute (or attributes) that uniquely identifies each row in a relation is called a: (A) foreign field. (B) primary key. (C) duplicate key. (D) column. (D) 3. Physical database design decisions must be made carefully because of impacts on: (A) data accessibility. (B) security. (C) response times. (D) all of the above. (B) 4. Which of the following is NOT a reason to create an instance of a relational schema with sample data? (A) Sample data can be used for prototype generation. (B) Sample data can reverse database implementation errors. (C) Sample data provide a convenient way to check the accuracy of your design. (D) Sample data can be used to improve user communications. (C) 5. A relation that contains minimal redundancy and allows easy use is considered to be: (A) clean. (B) simple. (C) well-structured. (D) complex. (D) 6. ________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated. (A) Business integrity (B) Data structure (C) Business rule constraint (D) Data integrity (C) 7. A nonkey attribute is also called a(n): (A) unimportant datum. (B) column. (C) descriptor. (D) address. (C) 8. In the following figure, the primary key for "Order Line" is which type of key? Second Midterm Exam Review of Database Design - 第二次期中考 ... http://web.csie.chu.edu.tw/~chang/course/database/exam/database-exam2. .. 1 of 18 6/22/2009 10:09 PM
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
(A) Standard (B) Foreign (C) Composite (D) Grouped (B) 9. In the SQL language, the ________ statement is used to make table definitions. (A) create index (B) create table (C) create session (D) select
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 18

Second Midterm Exam Review B. - Second Midterm Exam Review...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online