CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com | Page 9

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;