Table creation

Q:1
Create a table Student with fields
RollNo      Number (6)        Primary key
Name        Character (25)
Batch       Character (20)
Total       Number (4)
Batch have values COMMERCE, SCIENCE, HUMANITIES


SQL>  CREATE TABLE STUDENT(
  2   ROLLNO NUMBER(6) PRIMARY KEY,
  3  NAME CHARACTER(25),
  4  BRANCH CHARACTER(20) CHECK(BRANCH IN('COMMERCE','SCIENCE','HUMANITIES')),
  5  TOTAL NUMBER(4));

Table created.