Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 18 of 25

Table Creation and Data Manipulation Commands — Question 18

Back to all questions
18
Question

Question 18

Create table Customer as per following Table Instance Chart.

Column NameData TypeLength
Cust_IDNUMBER7
Cust_NameVARCHAR30
Cust_Address1VARCHAR20
Cust_Address2VARCHAR30
PincodeNUMBER6
Cust_PhoneVARCHAR10
Answer 
CREATE TABLE Customer (
Cust_ID NUMBER(7),
Cust_Name VARCHAR(30),
Cust_Address1 VARCHAR(20),
Cust_Address2 VARCHAR(30),
Pincode NUMBER(6),
Cust_Phone VARCHAR(10)
);