CIS 336 Final Exam 1 CIS 336 Final Exam 1 | Page 4

conceptual
logical
condensed
physical
5. (TCO 6) Which of the following commands will add a new column named FIRSTORDERDATE
to the CUSTOMERS table to store the date that the customer first placed an order with the
company? (Points : 4)
CREATE COLUMN firstorderdate, DATE TO customers;
ALTER TABLE customers ADD COLUMN firstorderdate DATE;
ALTER TABLE customers ADD firstorderdate DATE;
ALTER TABLE customers ADD (firstorderdate DATE);
6. (TCO 6) When modifying the data characteristics of a column in Oracle, which of the
following is correct? (Points : 4)
The column size can be increased.
The size of the column can be decreased.
Changing the default value of a column will change the values of data already in a table.
If a NUMBER column is empty, its precision and scale cannot be changed.
7. (TCO 6) Which of the followig SQL commands would alter the table DEVRY and add a foreign
key that references the CITY table? (Points : 4)
ALTER table DEVRY
ADD CONSTRAINT devry_studentcity_fk references city;
ALTER table DEVRY
ADD CONSTRAINT devry_studentcity_fk FOREIGN KEY references city;
ALTER table DEVRY
ADD CONSTRAINT devry_studentcity_fk FOREIGN KEY (student_city) references city;
ALTER table DEVRY