Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 77 of 79

Table Creation and Data Manipulation Commands — Question 23

Back to all questions
23
Question

Question 23

Create table Department as per following Table Instance Chart.

Column NameDeptIDDeptName
Key TypePrimary 
Nulls/Unique NOT NULL
DatatypeNUMBERVARCHAR
Length220
Answer 
CREATE TABLE Department (
    DeptID NUMBER(2) PRIMARY KEY,
    DeptName VARCHAR(20) NOT NULL
);