CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 9

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
ADD CONSTRAINT FOREIGN KEY (student_city) references city;