{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 7 - Homework of Chapter 7 CIS4271/CIS6274 Fall...

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

View Full Document Right Arrow Icon
Homework of Chapter 7 CIS4271/CIS6274 Fall Quarter 2007 MULTIPLE CHOICE: Choose the one alternative that best completes the statement or answers the question. 1. ( B ) DDL is typically used during which phases of the development process? A) Implementation B) Physical design C) Analysis D) All of the above 2. ( B ) The first in a series of steps to follow when creating a table is to: A) identify columns that must be unique. B) identify each attribute and its characteristics. C) create an index. D) identify columns that must be null. 3. ( C ) What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2)); A) Alters the Customer_T table to accept Type 2 Varchars B) Alters the Customer_T table to be a Type 2 Varchar C) Alters the Customer_T table, and adds a field called "Type" D) Alters the Customer_T table by adding a 2-byte field called "Varchar" 4. ( A ) What does the following SQL statement do? Delete from Customer_T where state = ‘HI’; 5. ( B ) What does the following SQL statement do? Update Product_T Set Unit_Price = 775 Where Product_ID = 7 A) Changes the price of a unit called Product_T to 7 B) Changes the unit price of Product 7 to 775 C) Changes the length of the Unit_Price field to 775 D) Updates the Product_T table to have a unit price of 775
Background image of page 1

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

View Full Document Right Arrow Icon
6. ( B ) Which of the following is a technique for optimizing the internal performance of the relational data model?
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.

{[ snackBarMessage ]}