07

Database Processing, 13e (Kroenke/Auer)
Chapter 7: SQL for Database Construction and Application Processing

1) The SQL CREATE TABLE statement is used to name a new table and describe the table's columns.
Answer: TRUE
Diff: 1 Page Ref: 281

2) The SQL keyword CONSTRAINT is used to define one of five types of constraints.
Answer: TRUE
Diff: 1 Page Ref: 283

3) The SQL keyword PRIMARY KEY is used to designate the column(s) that are the primary key for the table.
Answer: TRUE
Diff: 1 Page Ref: 283, 289

4) The SQL keyword CONSTRAINT is used to limit column values to specific values.
Answer: TRUE
Diff: 2 Page Ref: 283, 289

5) The SQL keyword CONSTRAINT is used in conjunction with the SQL keywords PRIMARY KEY and FOREIGN KEY.
Answer: TRUE
Diff: 1 Page Ref: 289-290

6) One advantage of using the CONSTRAINT command to define a primary key is that the database designer controls the name of the constraint.
Answer: TRUE
Diff: 3 Page Ref: 289-290

7) The SQL keyword UNIQUE is used to define alternative keys.
Answer: TRUE
Diff: 2 Page Ref: 290

8) If the table PRODUCT has a column PRICE, and PRICE has the data type Numeric (8,2), the value 98765 stored in that field will be displayed by the DBMS as 98765.00.
Answer: FALSE
Diff: 3 Page Ref: 289 Fig 7-4

9) If the table ITEM has a column WEIGHT, and WEIGHT has the data type Numeric (7,2), the value 4321 with be displayed by the DBMS as 43.21.
Answer: TRUE
Diff: 2 Page Ref: 289 Fig 7-4

10) The SQL keyword CHECK is used to limit column values to specific values.
Answer: TRUE
Diff: 2 Page Ref: 289, 292
11) The SQL keyword MODIFY is used to change the structure, properties or constraints of a table.
Answer: FALSE
Diff: 1 Page Ref: 298

12) Data values to be added to a table are specified by using the SQL VALUES clause.
Answer: TRUE
Diff: 2 Page Ref: 300-301

13) The SQL keyword DELETE is used to delete a table's structure.
Answer: FALSE
Diff: 1 Page