7 years ago in Database Management System

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?

[A] ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
[B] ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
[C] ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
[D] None of the above is correct.
Loading...
Next Question

Overall Stats

Attempted 124
Correct 21
Incorrect 37
Viewed 66

Answers

Guest
Guest
Zachery Chen
Zachery Chen - 1 month ago

Zachery Chen from Taiwan is saying ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0); is correct answer

Mihir Shah
Mihir Shah - 4 years ago

Mihir Shah from Majalgaon, India is saying ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0); is correct answer

Imran Ali
Imran Ali - 4 years ago

Imran Ali from Rawalpindi, Pakistan is saying ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0); is correct answer

ranaasif
ranaasif - 4 years ago

ranaasif from Multan, Pakistan is saying ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0); is correct answer

MD.OMAR FARUK
MD.OMAR FARUK - 4 years ago

MD.OMAR FARUK from Bangladesh is saying ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0); is correct answer

Related Questions

Which of the following is true concerning Web services standards?

  • [A] Led by only one group.
  • [B] Helped by cooperation between companies.
  • [C] Not necessary at this time.
  • [D] Important so that the web can flourish.

An object can have which of the following multiplicities?

  • [A] Zero
  • [B] One
  • [C] More than one
  • [D] All of the above.