CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.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
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)