Q:

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

mhmadesk

Save to bookmark

|

2022-07-08

|

406

Medium

0

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
None of the above is correct.

Database, MCQ Questions, Database MCQ-questions,

login and add your own answer to this question

All Answers

mhmadesk

2022-07-08

need an explanation for this answer? contact us directly to get an explanation for this answer

(c).ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)