chap02solutions

chap02solutions - The web warrior Guide to Web Programming,...

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

View Full Document Right Arrow Icon
Web Programming Chapter 2 Review Questions 1. What type of database is Access? a. modern b. relational database management system c. flat file d. ASCII 2. Tables in a database are composed of ___________. a. properties b. identities c. features d. columns 3. To create a table in SQL, the ________________ statement is used. a. NEW TABLE b. INSERT TABLE c. CREATE TABLE d. ALTER TABLE 4. A(n) _____________ is used to ensure that each record in a table contains a unique column value. a. primary key b. identity value c. foreign key d. unique value
Background image of page 1

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

View Full DocumentRight Arrow Icon
You would use the ___________ data type to store the value $199.99. a. NUMERIC b. DOLLAR c. CURRENCY d. DOUBLE 6. What data type would you use in Access to store both numeric and character data in a column. a. CURRENCY b. TEXT c. DATE/TIME d. AUTONUMBER 7. You use the _____________ clause to sort data returned by a SELECT statement. a. ORDER BY b. SORT DATA c. GROUP BY d. HAVING 8. The _________ function is used to determine the total number of records in a table. a.
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 note was uploaded on 11/25/2010 for the course CS 220 taught by Professor Christophersung during the Spring '11 term at NYU.

Page1 / 4

chap02solutions - The web warrior Guide to Web Programming,...

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