Solved

Structure of the CUSTOMERS Table

Question 49

Multiple Choice

Structure of the CUSTOMERS table
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) ;
-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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions