Question 23Create table Department as per following Table Instance Chart.Column NameDeptIDDeptNameKey TypePrimary Nulls/Unique NOT NULLDatatypeNUMBERVARCHARLength220

Question

Question 23Create table Department as per following Table Instance Chart.Column NameDeptIDDeptNameKey TypePrimary Nulls/Unique NOT NULLDatatypeNUMBERVARCHARLength220

Bright Tutorials · Accepted Answer

CREATE TABLE Department (
    DeptID NUMBER(2) PRIMARY KEY,
    DeptName VARCHAR(20) NOT NULL
);

Column Name	DeptID	DeptName
Key Type	Primary
Nulls/Unique		NOT NULL
Datatype	NUMBER	VARCHAR
Length	2	20

Table Creation and Data Manipulation Commands — Question 23

Question 23