CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 9

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