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

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