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 )