Chapter 7

Question 1

The SQL CREATE TABLE statement is used to name a new table and describe the table’s columns.

Answer 1

True

Question 2

The SQL keyword CONSTRAINT is used to define one of five types of constraints.

Answer 2

True

Question 3

The SQL keyword PRIMARY KEY is used to designate the column(s) that are the primary key for the table

Answer 3

True

Question 4

The SQL keyword CONSTRAINT is used to limit column values to specific values.

Answer 4

True

Question 5

The SQL keyword CONSTRAINT is used in conjunction with the SQL keywords PRIMARY KEY and FOREIGN KEY.

Answer 5

True

Question 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 6

True

Question 7

The SQL keyword UNIQUE is used to define alternative keys.

Answer 7

True

Question 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 8

False

Question 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 9

True

Question 10

The SQL keyword CHECK is used to limit column values to specific values.

Answer 10

True

Question 11

The SQL keyword MODIFY is used to change the structure, properties or constraints of a table.

Answer 11

False

Question 12

Data values to be added to a table are specified by using the SQL VALUES clause.

Answer 12

True

Question 13

The SQL keyword DELETE is used to delete a table’s structure.

Answer 13

False

Question 14

When the correct SQL command is used to delete a table’s structure, the command can only be used with a table that has already had its data removed.

Answer 14

False

Question 15

Which SQL keyword is used to name a new table and describe the table's columns?
A) SET
B) CREATE
C) SELECT
D) ALTER
E) CONSTRAINT

Answer 15

B

Question 16

If the table PRODUCT has a column PRICE that has the data type Numeric (8,2), the value 12345 will be displayed by the DBMS as ________.

Answer 16

A

Question 17

Which SQL keyword is used to impose restrictions on a table, data or relationship?

Answer 17

E

Question 18

One advantage of using the CONSTRAINT phrase to define a primary key is that the database designer controls the \_\_\_\_\_\_\_\_.
A) name of the primary key
B) name of the foreign key
C) name of the constraint
D) A and B
E) A, B, and C

Answer 18

C

Question 19

Which of the following illustrates the authors' preferred style of defining a primary key?
A) CREATE TABLE CUSTOMER (
	CustomerID	Integer	Primary Key
	LastName	Char(35)	Not Null
	First Name	Char(25)	Null
B) CREATE TABLE CUSTOMER (
	CustomerID	Integer	Not Null
	LastName	Char(35)	Not Null
	First Name	Char(25)	Null	
	CONSTRAINT CustomerPK PRIMARY KEY (CustomerID)
C) CREATE TABLE CUSTOMER (
	CustomerID	Integer	Not Null
	LastName	Char(35)	Not Null
	First Name	Char(25)	Null
ALTER TABLE CUSTOMER	
	ADD CONSTRAINT CustomerPK PRIMARY KEY        (CustomerID);
D) either B or C
E) The authors do not demonstrate a preference for how to define a primary key.

Answer 19

B

Question 20

Given the SQL statement

CREATE TABLE SALESREP (
SalesRepNo	int	NOT NULL,
RepName	char(35)	NOT NULL,
HireDate	date	NOT NULL,

CONSTRAINT	SalesRepPK	PRIMARY KEY (SalesRepNo),
CONSTRAINT	SalesRepAK1	UNIQUE (RepName)
);

we know that \_\_\_\_\_\_\_\_.
A) RepName is the primary key
B) RepName is a foreign key
C) RepName is a candidate key
D) RepName is a surrogate key
E) None of the above is true

Answer 20

C

Question 21

The SQL keyword used to limit column values to specific values is \_\_\_\_\_\_\_\_.
A) CONSTRAINT
B) CHECK
C) NOT NULL
D) UNIQUE
E) UPDATE

Answer 21

B

Question 22

Which SQL keyword is used to change the structure, properties or constraints of a table?
A) SET
B) CREATE
C) SELECT
D) ALTER
E) CONSTRAINT

Answer 22

D

Question 23

Which SQL keyword is used to delete a table's structure?
A) DELETE
B) DROP
C) DISPOSE
D) ALTER
E) MODIFY

Answer 23

B

Question 24

When the correct SQL command is used to delete a table’s structure, what happens to the data in the table?
A) If the deleted table was a parent table, the data is added to the appropriate rows of the child table.
B) If the deleted table was a child table, the data is added to the appropriate rows of the parent table.
C) The data in the table is also deleted.
D) Nothing because there was no data in the table since only an empty table can be deleted.
E) A and B

Answer 24

C

Question 25

``` Which SQL keyword is used to add one or more rows of data to a table? A) DELETE B) INSERT C) SELECT D) SET E) UPDATE ```

Answer 25

B