Question 1. 1. (TCO 3) The _____ column attribute will provide a value for a field if none is specified. (Points : 3)

DEFAULT AUTO_INCREMENT VALUE NOT NULL

Question 2. 2. (TCO 5) The _____ keyword is used in an ALTER statement to change the data type of an existing column in a table. (Points : 3)

MODIFY ADD INSERT DROP

Question 3. 3. (TCO 3) Which uses the least amount of storage? (Points : 3)

Example stored in a column of type CHAR(20) Exam stored in a column of type CHAR(20) Ex stored in a column of type CHAR(20) They all use the same amount of storage.

Question 4. 4. (TCO 3) The DATETIME data type in MySQL can store _____. (Points : 3)

dates only times only dates and times None of the above

Question 5. 5. (TCO 3) Which statement is false regarding the creation of a foreign key constraint at table level or with an ALTER statement? (Points : 3)

The parent table must already exist. The field must already be defined in the table. The PK and FK fields must have the same name. The PK and FK fields may have different names.

Question 6. 6. (TCO 3) When you build a script for creating tables in a database, _____. (Points : 3)

the order that you create the tables does not matter you must create child tables before parent tables you must create parent tables before child tables the primary key column must be created first in each table

Question 7. 7. (TCO 3) You are creating a table called Department, with fields for the primary key DeptID (Integer) and department name (VARCHAR). What (if anything) is wrong with the following code? CREATE TABLE Department ( deptID INTEGER Primary Key, deptName VARCHAR(10) NOT NULL ); (Points : 3)

You must use curly braces, not parentheses. The field names must be all lower case. The keywords cannot be in upper case. Nothing is wrong.

Question 8. 8. (TCO 3) What datatype is best to store a persons age? (Points : 3)

INTEGER VARCHAR DECIMAL FLOAT

Question 9. 9. (TCO 5) Which statement will add a new column named ORDERDATE to the CUSTOMERS table? (Points : 3)

CREATE COLUMN orderdate, DATE ADD to customers; ALTER TABLE customers ADD COLUMN orderdate DATE; ALTER TABLE customers ADD orderdate DATE; MODIFY TABLE customers ADD orderdate DATE;

Question 10. 10. (TCO 8) When you write an INSERT statement with a column list, which columns must be specified in the column list? (Points : 3)

AUTO_INCREMENT DEFAULT NOT NULL Fields that allow NULL