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’; A) Deletes all records from customer_t where the state is equal to HI B) Removes the customer_t table from the database C) Deletes all records from the customer_t table D) None of the above 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 DocumentRight Arrow Icon
6. ( B ) Which of the following is a technique for optimizing the internal performance of the relational data model? A) Avoiding indexes on secondary keys B) Clustering data C) Not reporting statistics to save machine resources D) Using random index organizations 7. ( C ) Indexes are created in most RDBMSs to: A) provide a quicker way to store data. B)
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.

This homework help was uploaded on 04/17/2008 for the course CIS 4271 taught by Professor Du during the Fall '07 term at CSU East Bay.

Page1 / 5

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

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