5 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 198
Correct 32
Incorrect 66
Viewed 100

Answers

Guest
Guest
Shamsa hafeez
Shamsa hafeez - 1 week ago

Shamsa hafeez from Lahore, Pakistan is saying ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0); is correct answer

Tsega Asresa Mengistu
Tsega Asresa Mengistu - 1 week ago

Tsega Asresa Mengistu from Dessie, Ethiopia is saying ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0); is correct answer

sureshbabu vampugadapa
sureshbabu vampugadapa - 1 month ago

sureshbabu vampugadapa from Guntur, India is saying ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0); is correct answer

Deep
Deep - 1 month ago

Deep from Kolkata, India is saying ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0); is correct answer

Arpita Dhote
Arpita Dhote - 1 month ago

Arpita Dhote from Pune, India is saying ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0); is correct answer

Related Questions

Which of the following is not the function of client?

  • [A] Compile queries
  • [B] Query optimization
  • [C] Receive queries
  • [D] Result formatting and presentation

Referential integrity controls relationships between :

  • [A] attributes in a table
  • [B] operations of an object
  • [C] instances of a class
  • [D] tables in a database

SQL stands for ________ .

  • [A] Structured Question Language
  • [B] Structured Query Language
  • [C] Sequential Question Language
  • [D] Sequential Query Language

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.