Multiple Choice
Structure of the CUSTOMERS table
-Which of the following commands will add a new column named FIRST ORDER DATE to the CUSTOMERS table to store the date that the customer first placed an order with the company?
A) CREATE COLUMN firstorderdate,DATE TO customers;
B) ALTER TABLE customers ADD COLUMN firstorderdate DATE;
C) ALTER TABLE customers ADD firstorderdate DATE;
D) ALTER TABLE customers ADD (firstorderdate DATE) ;
Correct Answer:

Verified
Correct Answer:
Verified
Q44: The <u>MODIFY</u> clause can be included in
Q45: _ commands are used to create database
Q46: The _ clause of the ALTER TABLE
Q47: Once a table is _,any associated indexes
Q48: The DROP COLUMN clause of the ALTER
Q50: The <u>CHAR </u>datatype is used to store
Q51: The _ command can be used to
Q52: The ALPHANUMERIC datatype can be used to
Q53: When creating a table,which of the following
Q54: The default size of the CHAR column