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 remove a column from an existing table. (Points : 3)

MODIFY COLUMN ADD COLUMN DELETE COLUMN DROP COLUMN

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

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

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

dates only times only dates and times None of the above

Question 5. 5. (TCO 3) What constraint can only be applied at table level or with an ALTER statement? (Points : 3)

Foreign key Not null Single field primary key Composite primary key

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 Primary Key INTEGER , deptName NOT NULL VARCHAR(10) ); (Points : 3)

You must use curly braces, not parentheses. The data type must immediately follow the field name. 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 can be omitted from the column list? (Points : 3)

AUTO_INCREMENT only DEFAULT only NOT NULL only AUTO_INCREMENT, DEFAULT, and fields that allow NULL