Q. Add a constraint (NN-Grade) in table Empl (given before assignment) that declares column Grade not null.


Answer =

Alter table Empl add column grade int(1) Not null;

3 Comments

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

  1. Kya iska ye ho sakta h

    Alter table Empl add Not Null(Grade);

    Please reply

    ReplyDelete
    Replies
    1. No, question say to modify not to add column.

      Delete

Post a Comment

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

Previous Post Next Post