Datasheet

Exercises

1. Database tables must include primary keys. Is this statement true or false?

2. Which of the following are actual types of joins between tables?

a. Inner joins

b. Sideways joins

c. Internal joins

d. Left outer joins

e. Dovetail joins

3. If you wanted to perform two update queries in which either both queries must succeed or both

must fail, what technology would you use?

4. What is wrong with the following SQL statements?

DELETE FROM MyTable

UPDATE MyTable (Title, Amount) SET (‘Oysters’, 17) WHERE ItemId = 3

5. Any XML document may be inserted into a SQL database table as a set of rows. Is this statement

true or false? Why?

Chapter 1

44063c01.qxd:WroxBeg 9/12/06 10:31 PM Page 34