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

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