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 DAT

Question

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 DAT

Quizplus · Accepted Answer

The Answer of 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 DAT

Structure of the CUSTOMERS Table