Computer Science

Modify the definition of column Grade. Increase its size to 2.

DDL & DML

3 Likes

Answer

ALTER TABLE Empl
MODIFY (Grade VARCHAR(2)) ;

Answered By

2 Likes

Related Questions

Add a constraint (NN-Grade) in table Empl that declares column Grade not null.
View Answer

Insert a record of your choice in table Empl. Make sure not to enter Grade.
View Answer
Drop the table Empl.
View Answer
Create the table Department table based on the following table instance chart.
Column Name ID Name
Data Type NUMBER VARCHAR
Length 8 25
View Answer